ETL Informatica Developer

ETL Informatica Developer

Atlanta, GA || Full-time

Onsite

Complete JD:

The client is looking for the following skill sets for this role:

• Cloud Data Integration (CDI)
• Cloud Application Integration (CAI)

Job Description for the new position:

• 10+ years of ETL experience using Informatica Cloud
• 1+ year of hands-on experience integrating/accessing Workday HCM as a developer
• Skilled and results-driven ETL Developer with around 13 years of experience in designing, Developing, and implementing data integration solutions using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).

• Experience working in SDLC and Agile/Scrum Projects.
• Work extensively with IDMC (CAI , CDI and Application Integration).
• Develop and work with REST/SOAP APIs, message queues, and cloud applications.

• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Aggregator, Sequence Generator and Sorter.

• Utilized IICS API integration capabilities to connect diverse applications, enabling real-time data exchange and event-driven actions.

• Strong experience in ETL Designing, Data Conversion, Data Warehouse, Data Mart Design, Star Schema and Snowflake Schema methodologies, Unit Testing and Source to Target Mapping Documentation.

• Extensive experience in loading high volume of data, implementing complex business rules by creating Mappings with reusable transformations and Mapplets also tuned them for Optimum performance.

• Extensively worked on Query tools like SQL Assistant, TOAD and PLSQL Developer.

• Hands on experience in Star/Snowflake schema design and De-normalization techniques.

• Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis.

• Experience in integrating cloud-based data sources and ensuring seamless data flow between on- premise and cloud systems.

• Experience in performance tuning and optimization of ETL processes.

• Participation in daily stand-ups, sprint planning, retrospectives, and backlog grooming.

• Highly proficient in processing tasks, version control, scheduling sessions, Import/export repositories, manage users, groups associated privileges and folders.

• Experience in documenting High level Design, Detailed Technical Design, Code review, Unit test plan, Unit test cases, Development, and support handover documents.

• Hands-on experience on ETL Production Support.
• Experience in fixing bug raised by QA team.