Software Engineer | Combined, a Chubb Company | Telangana, India

Position: Software Engineer

Location: Telangana, India

Job Description

Qualification and Skills

• 6 to 10 years of strong informatica experience.
• ETL/ELT development using IICS-CDI (Cloud Data Integration), including experience with IICS Cloud Console and PowerCenter Designer
• 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
• 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.
• Experience with scripting languages such as Python or Shell scripting
• Excellent analytical and problem-solving skills, with a keen attention to detail
• Strong communication and interpersonal skills
• Familiarity with Agile development methodologies
• Preferred Certifications: Informatica Cloud Data and Application Integration R38, Professional Certification

Responsibilities

• Monitor ETL jobs to ensure successful completion, identify and resolve errors and performance issues. Troubleshoot and resolve issues with existing ETL processes.
• Design, develop and implement ETL solutions using IICS -CDI to extract, transform and load data from various sources into data warehouse
• Ability to work independently and Support Team members in a team-oriented, collaborative environment

Apply: Click here to Apply