Code : CL-307

Location : (India & Remote)

Experience Required : Minimum 6 years of relevant experience in Development & migration in IICS.

Job Description

• We are seeking an experienced ETL Developer with 6+ years of experience to join us in India.
• Opportunity to work remotely is available.
• 6+ years IT and ETL experience.
• Mastery in ETL tool Informatica Intelligent Cloud Services (IICS).
• More than 5 years of hands-on experience with ETL tool Informatica Intelligent Cloud Services

(IICS), as well as proficiency in Oracle 11g functions, procedures, and materialized views.

• Proven track record in delivering end-to-end projects encompassing source data quality checks,

job validations, mapping development, staging data, transformations, and slowly changing
dimensions (SCD) types.

• Advanced proficiency in Oracle SQL, PL/SQL, SQL Plus, with expertise in developing stored

procedures, triggers, and PL-SQL/TSQL packages.

• Skilled in optimizing SQL queries to seamlessly integrate with applications.
• Design, develop, test, and deploy workflows and transformations using Informatica PowerCenter

and IICS.

• Migrate workflows from Informatica PowerCenter to IICS.
• Proficiency in optimizing and tuning database schemas, stored procedures, triggers, and dynamic

queries.

• Advantageous experience in integrating with enterprise systems like MDM and SFDC.
• Solid understanding of data warehousing concepts and ETL processes.
• Proficient in written, verbal, and presentation skills, demonstrating strong collaboration abilities

within team environments.

• Exceptional problem-solving and analytical skills.