ETL Informatica/IDMC Developer - (Informatica, IDMC, SQL, Data Warehouse, Python, Data modeling)
Posted 7 days ago by GIOS Technology
Negotiable
Undetermined
Hybrid
Milton Keynes, England, United Kingdom
Summary: The ETL Informatica/IDMC Developer role involves designing, developing, and maintaining ETL processes for a Volkswagen project. The candidate should possess strong SQL skills and expertise in Informatica development, along with experience in IDMC cloud migration. This position requires collaboration with team members to translate business requirements into technical specifications while ensuring data quality and accuracy. The role is hybrid, requiring two days on-site work per week in Milton Keynes, UK.
Key Responsibilities:
- Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.
- Perform IDMC cloud migration and manage Informatica setup and development.
- Write and optimize SQL queries, join tables, and compare table data for accuracy.
- Conduct data quality checks and troubleshoot ETL-related issues.
- Collaborate with team members to translate business requirements into technical specifications.
- Participate in code reviews, document ETL workflows, and implement best practices in ETL and data integration.
- Optional: Use scripting languages such as Python or Shell scripting to automate ETL processes.
Key Skills:
- Informatica
- IDMC
- ETL
- SQL
- Data Warehouse
- Data Integration
- Python
- Shell Scripting
- Data Modeling
- Database Design
Salary (Rate): undetermined
City: Milton Keynes
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
I am hiring for ETL Informatica/IDMC Developer
Location: Milton Keynes, UK (2 days on-site per week, Hybrid)
Job Description
We are looking for an experienced ETL Informatica/IDMC Developer to design, develop, and maintain ETL processes for our Volkswagen project. The ideal candidate will have strong SQL skills, expertise in Informatica development, and experience with IDMC cloud migration.
Key Responsibilities:
- Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses or data marts.
- Perform IDMC cloud migration and manage Informatica setup and development.
- Write and optimize SQL queries, join tables, and compare table data for accuracy.
- Conduct data quality checks and troubleshoot ETL-related issues.
- Collaborate with team members to translate business requirements into technical specifications.
- Participate in code reviews, document ETL workflows, and implement best practices in ETL and data integration.
- Optional: Use scripting languages such as Python or Shell scripting to automate ETL processes.
Key Skills
- Informatica
- IDMC
- ETL
- SQL
- DataWarehouse
- DataIntegration
- Python
- ShellScripting
- DataModeling
- DatabaseDesign