Senior ETL Developer – IICS (Cloud Data Integration)
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
