ETL Informatica Developer

ETL Informatica DeveloperAtlanta, GA || Full-timeOnsite 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 CloudSkilled 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.

Apply Now