About CloudLabs :

CloudLabs Inc was founded in 2014 with the mission to provide exceptional IT & Business consulting services at a competitive price, to help clients realize the best value from their investments.

Within a short span, CloudLabs evolved from pure-play consulting into a transformative partner for Business Acceleration Advisory, Transformative Application Development & Managed Services enabling digital transformations, M&A transitions, Automation & Process-driven optimizations & complex Integration initiatives for enterprises across the globe.

As a Strategic Planning & Implementation Partner for global companies, CloudLabs has seen a 200% uptake in winning high-value, high-impact and high-risk projects that are critical for the business.

With offices in the US, Canada, Australia & India and with the team of 150+ experienced specialists, CloudLabs is now at an inflection point and ready for its next curve of progress.

What we offer :

We welcome candidates rejoining the workforce after career break/parental leave and support their journey to reacclimatize too corporate.

- Flexible remote work.

- Competitive pay package.

- Attractive policy, medical insurance benefits, industry leading trainings.

- Opportunity to work remotely is available.

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

Job Location : India.

Job Type : Remote.

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.