Data ETL Engineering Expert

Role

Data / ETL Engineer Expert

Location

Chennai (Hybrid)

Experience

10 - 15 Years

Position Open

1

Visit our websiteto know more.

Follow us onLinkedInIInstagramIFacebookIXfor 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).
• Drive end-to-end data solution design from source ingestion to consumption layers (reporting analytics APIs).
• Mentor and guide junior developers conduct code reviews and enforce best practices across ETL development.
• Design and implement data governance frameworks including lineage tracking metadata management and data cataloging.
• Design and enforce CI/CD pipelines and DevOps practices for ETL deployments.
• 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

• Strong experience in solution design and architecture for enterprise data systems
• Ability to handle large-scale complex data environments with multiple integrations
• Experience in stakeholder management and requirement gathering
• Strong understanding of data governance compliance and security frameworks
• Ability to mentor teams and lead technical discussions
• Experience in performance optimization at scale
• Excellent communication and collaboration skills.
• Domain background in Financial Services/banking.

Must have technical skill

• Expertise in IDMC services such as Data Integration Data Quality Cloud Data Governance & Catalogmappings transformations workflows performance tuning scheduling and production support.
• Hands-onexpertisein Snowflake DBT Snow SQL SnowPipeETL Pipelines and data migration from RDBMS to Snowflake.
• Advanced SQL and data modelling skills (views mappings historization).
• Strong experience with CDC implementations Real-time/event-driven data pipelines.
• Hands-on experience with cloud data warehouses like Snowflake.
• Proficiency in shell scripting / automation.
• Experience implementing data validation & reconciliation frameworks.
• Strong understanding of partitioning indexing and performance tuning techniques.
• Experience with job orchestration tools and workflow automation.
• Understanding SDLC Agile methodologiesversion control and release processes.
• Develop technical documentation for Informatica configurations scripts and procedures.
• Experience working on cloud platforms such as AWS or Azure.

Good to have skills

• Exposure to Python or Spark for data processing
• Knowledge of DevOps tools (Github Jenkins Terraform etc.).