ETL Engineer

Role
ETL Engineer
Location
Chennai (Hybrid)
Experience
3-6 Years

Visit our website bmwtechworks.in to know more.
Follow us on LinkedIn?I Instagram?I Facebook?I X for the exciting updates.

What awaits you/ Job Profile
- Design, develop, test, deploy and maintain robust ETL/ELT data pipelines, with a strong focus on Informatica Intelligent Data Management Cloud (IDMC).
- Perform data quality analysis, identify issues across data pipelines, and troubleshoot/debug effectively.
- Work with advanced SQL and data modeling, focusing on views, mappings, and historization practices.
- Ensure data accuracy, consistency, and performance across the data ecosystem.
- Good analytical/problem solving skills, algorithms, and logical thinking.
- Ensure the application is scalable, performant, secure and highly available.
- Understanding deployment processes and system operations.
- Incident handling and environment stability.
- Coordination with external operations teams.
- Support in decommissioning, migration, and environment readiness.

What should you bring along




- Solid problem-solving mindset with attention to detail.
- Understanding data lifecycle, integration patterns, and best practices.
- Proactive approach to identifying issues and improving data processes.
- Excellent communication and collaboration skills.
- Domain background in Financial Services/banking.

Must have technical skill
- Hands-on experience with Informatica IDMC and PowerCenter, including mappings, transformations, workflows, performance tuning, scheduling, and production support.
- Hands-on expertise in Snowflake, DBT, Snow SQL, Snow Pipe, ETL Pipelines and data migration from RDBMS to Snowflake.
- Advanced SQL and data modelling skills (views, mappings, historization).
- Solid understanding of data warehousing concepts such as SCD, CDC, surrogate keys, and basic dimensional modeling.
- Knowledge of ETL best practices, including incremental loads, reprocessing strategies, and idempotent pr

📌 Informatica ETL Engineer (Chennai)
🏢 BMW TechWorks
📍 Chennai