Data Engineer

About Chubb

Chubb is a world leader in insurance. With operations in 54 countries and territories, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients. The company is defined by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength and local operations globally. Parent company Chubb Limited is listed on the New York Stock Exchange (NYSE: CB) and is a component of the S&P 500 index. Chubb employs approximately 40,000 people worldwide. Additional information can be found at: www.chubb.com.

About Chubb India

At Chubb India, we are on an exciting journey of digital transformation driven by a commitment to engineering excellence and analytics. We are proud to share that we have been officially certified as a Great Place to Work® for the third consecutive year, a reflection of the culture at Chubb where we believe in fostering an environment where everyone can thrive, innovate, and grow

With a team of over 2500 talented professionals, we encourage a start-up mindset that promotes collaboration, diverse perspectives, and a solution-driven attitude. We are dedicated to building expertise in engineering, analytics, and automation, empowering our teams to excel in a dynamic digital landscape.

We offer an environment where you will be part of an organization that is dedicated to solving real-world challenges in the insurance industry. Together, we will work to shape the future through innovation and continuous learning.

Position Details

• Job Title: Software Engineer
• Function/Department: Technology
• Location: Hyderabad
• Employment Type: Full Time
• Reports To: NA
• Role Overview 

 Design, develop and implement ETL solutions using IICS -CDI to extract, transform and load data from various sources into data warehouse. Strong understanding of data warehousing concepts, ETL/ELT frameworks, and best practices

 

Key Responsibilities

• Minimum of 6 years of experience in ETL/ELT development using IICS-CDI (Cloud Data Integration), including experience with IICS Cloud Console and PowerCenter Designer
• Design, develop and implement ETL solutions using IICS -CDI to extract, transform and load data from various sources into data warehouse
• Strong understanding of data warehousing concepts, ETL/ELT frameworks, and best practices
• Solid experience with SQL and database technologies such as SQL Server, Oracle etc. (Preferably Azure Synapse) and distributed file systems: HDFS , ADLS etc.
• Develop and maintain ETL mappings, workflows, and schedules using IICS – CDI (Cloud Data Integration) & other orchestration Tools.
• Ensure data quality, integrity, and consistency by performing data validation, cleansing, and enrichment activities
• Monitor ETL jobs to ensure successful completion, identify and resolve errors and performance issues. Troubleshoot and resolve issues with existing ETL processes.
• Create and maintain SQL-based database objects, including tables, views, indexes, and triggers. & Write optimized queries and ensuring that the database performs efficiently
• Troubleshoot database performance issues and identifying solutions to improve performance
• Should be Familiar with data modeling and data integration techniques
• Be able to Work with cross-functional teams to understand business requirements and translate them into technical specifications for ETL development
• Good understanding of Informatica Cloud Secure Agents  
• Experience with version control tools such as Git and follow CICD practice. 
• Familiarity with cloud technologies such as Azure, AWS or Google Cloud Platform
• Experience with scripting languages such as Python or Shell scripting
• Excellent analytical and problem-solving skills, with a keen attention to detail
• Ability to work independently and Support Team members in a team-oriented, collaborative environment
• Strong communication and interpersonal skills
• Familiarity with Agile development methodologies
• Preferred Certifications:
  • Informatica Cloud Data and Application Integration R38, Professional Certification
  • AZ-900: Microsoft Azure Fundamentals
  • DP-900: Microsoft Azure Data Fundamentals
  • DP-203: Data Engineering on Microsoft Azure

 

Skills and Qualifications

• Bachelor’s degree in Computer Science, Information Techno