24 Aug
|
CloudLabs
|
India
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 energetic
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.
📌 IICS ETL Developer (India)
🏢 CloudLabs
📍 India