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.
