Technical lead

Job Description

We are looking for an experienced and motivated Senior Data Engineer to join our dynamic team. This role primarily focuses on MDM (Master Data Management) and associated ETL (Extract, Transform, Load) and real-time feeds monitoring and support. The 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, and batch processes.
• Troubleshoot production incidents to ensure smooth operations.
• Understand data mapping and data modeling methodologies (normal form, star, and snowflake) to reduce data redundancy and improve data integrity.
• Maintain knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assess the impact, and collaborate with Scrum Teams and Leadership to drive improvements.

Qualifications

• 4-year/bachelor's degree or equivalent work experience (4 years of experience in lieu of a Bachelor's).
• 5+ years of strong understanding of ETL development concepts and tools such as Powercenter, IICS, Informatica MDM, Azure Data Factory, and 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.