01Overview
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
Strong 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.
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 of Unix/Linux commands and job monitoring.
Understanding SDLC, Agile methodologies, version control, and release processes.
Familiarity with cluster basics, job execution, and pipeline troubleshooting.
Develop technical documentation for Informatica configurations, scripts and procedures.
Experience working on cloud platforms such as AWS or Azure.
Good to have skills
Knowledge of Snowflake database.
Exposure to CI/CD and DevOps. .
