Informatica ETL Engineer

Role

ETL Engineer

Location

Chennai (Hybrid)

Experience

3-6Years

Visit our websiteto know more.

Follow us onLinkedInIInstagramIFacebookIXfor the exciting updates.

What awaits you/ Job Profile

• Designdeveloptest deploy andmaintainrobust ETL/ELT data pipelines with a strong focus on Informatica Intelligent Data Management Cloud (IDMC).

• Perform data quality analysisidentifyissues 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 andhighly available.

• Understanding deployment processes and system operations.

• Incident handling andenvironmentstability.

• Coordination with external operations teams.

• Support in decommissioning migration and environment readiness.

Whatshouldyoubringalong

• Strong problem-solving mindset with attention to detail.

• Understandingdata lifecycle integration patterns and best practices.

• Proactive approach toidentifyingissues and improving data processes.

• Excellent communication and collaboration skills.

• Domain background in Financial Services/banking.

Must have technical skill

• Hands-on experience with InformaticaIDMCandPowerCenter including mappings transformations workflows performance tuning scheduling and production support.

• 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 processing.

• Knowledge ofUnix/Linux commands and job monitoring.

• UnderstandingSDLC Agile methodologies version control and release processes.

• Familiarity with cluster basics job execution and pipeline troubleshooting.

• Develop technical documentation for Informatica configurationsscriptsand procedures.

• Experience working on cloud platforms such as AWS or Azure.

Good to have skills

• KnowledgeofSnowflakedatabase.

• Exposure to CI/CD and DevOps.