Informatica Intelligent Cloud Services Developer - ETL

<p><p><b>About CloudLabs :</b><br/></p><p><br/></p><p>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 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.<br/></p><p><br/></p><p>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.<br/></p><p><br/></p><p>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.<br/></p><p><br/></p><p>Please write & follow us here :<br/></p><p><br/></p><p>Website : : CloudLabs Inc.<br/><br/></p><p><b>What we offer :</b><br/></p><p><br/></p><p>We welcome candidates rejoining the workforce after career break/parental leave and support their journey to reacclimatize too corporate.<br/></p><p><br/></p><p>- Flexible remote work.<br/></p><p><br/></p><p>- Competitive pay package.<br/></p><p><br/></p><p>- Attractive policy, medical insurance benefits, industry leading trainings.<br/></p><p><br/></p><p>- Opportunity to work remotely is Required :</b> Minimum 6 years of relevant experience.</p><p><br/></p><p><b>Job Location :</b> India.</p><p><br/></p><p><b>Job Type :</b> Remote.</p><p><br/></p><p><b>Job description :</b></p><p><br/>We are seeking an experienced ETL Developer with 6+ years of experience to join us in to work remotely is available.<br/></p><p><br/></p><p>- 6+ years IT and ETL experience.<br/></p><p><br/></p><p>- Mastery in ETL tool Informatica Intelligent Cloud Services (IICS).<br/></p><p><br/></p><p>- 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.<br/></p><p><br/></p><p>- 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.<br/></p><p><br/></p><p>- Advanced proficiency in Oracle SQL, PL/SQL, SQL Plus, with expertise in developing stored procedures, triggers, and PL-SQL/TSQL packages.<br/></p><p><br/></p><p>- Skilled in optimizing SQL queries to seamlessly integrate with applications.<br/></p><p><br/></p><p>- Design, develop, test, and deploy workflows and transformations using Informatica PowerCenter and IICS.<br/></p><p><br/></p><p>- Migrate workflows from Informatica PowerCenter to IICS.<br/></p><p><br/></p><p>- Proficiency in optimizing and tuning database schemas, stored procedures, triggers, and dynamic queries.<br/></p><p><br/></p><p>- Advantageous experience in integrating with enterprise systems like MDM and SFDC.<br/></p><p><br/></p><p>- Solid understanding of data warehousing concepts and ETL processes.<br/></p><p><br/></p><p>- Proficient in written, verbal, and presentation skills, demonstrating strong collaboration abilities within team environments.<br/></p><p><br/></p><p>- Exceptional problem-solving and analytical skills.</p><br/></p> (ref:hirist.tech)