Data Engineer/MDM Support

We are looking for an experienced and motivated Senior Data Engineer to join our dynamic team. In this role, The role primarily focuses on MDM and associated ETL and real-time feeds monitoring and  support. This engineer will be part of the global L1/L2 production support team , which is split between Chubb Engineering Centers in India and Mexico. Key responsibilities will include monitoring ETL processes, handling automated issues, and ensuring compliance with security policies. A good understanding of MDM Informatica and Data Factory is preferred

The ideal candidate will have experience with Powercenter, MDM, Azure Data Factory, be able to identify and resolve data quality issues, proactively monitor production systems, performance bottlenecks, and other ETL-related problems.

Responsibilities:

• Monitor ETL jobs including Powercenter/IICS, kafka based near real-time updates, batch processes. 
• Troubleshoot production incidents 
• Understands data mapping and data modeling methodologies including normal form, star, and snowflake to reduce data redundancy and improve data integrity.
• Maintains knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assesses the impact, and collaborates with Scrum Team and Leadership to 

• At least 5+ years of Strong understanding of ETL development concepts and tools such as ETL development solutions (e.g. Powercenter and/or IICS, Informatica MDM, Azure Data Factory, Snowflake)
• Experience with Data Warehousing and Business Intelligence concepts and technologies
• Knowledge of SQL and advanced programming languages such as Python and Java
• Demonstrated critical thinking skills and the ability to identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems
• Experience with Agile methodologies and project-management skills
• Excellent communication and interpersonal skills
• 2+ years of experience in scheduling jobs using Autosys (or comparable distributed scheduler)
• 3+ years of experience writing Unix/Linux or Windows Scripts in tools such as PERL, Shell script, Python, etc.
• 3+ years of experience in creating complex technical specifications from business requirements/specifications