Position: Middle Strong/Senior ETL Informatica Engineer
Company: Avenga
Category: Other
Experience required: 5y
English level: upper

Skills and Qualifications:
At least 5 years of experience in ETL/DWH/BI development;
At least 2 years of experience with manipulating and transforming large and complicated datasets;
Solid experience in Informatica/ETL methods and technologies;
Experience with Informatica CAI;
Strong knowledge in advanced Informatica/ETL data movement, API;
Exemplary data extraction skills;
Ability to analyze and understand existing SQL scripts and ETL processes;
Experience with sourcing data across multiple platforms (Mainframe, FTP, Data Warehouse, ESB);
English – Upper Intermediate (Excellent verbal and written communication skills);
Strong functional and analytical skills;
Experience in UNIX scripting and job scheduling tools;
Experience with TFS or GIT;
Experience with SDLC/Waterfall/Agile methodologies and developing Project Artifacts.

Responsibilities:
Implement new ETL processes, flows with various conditions;
Synchronization between a various sources (Salesforce, Oracle, MySQL, APIs etc.);
Migrate the existing flows from MuleSoft to Informatica CAI;
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica CAI, and prepare corresponding documentation;
Works with JSON, XML, XML parser, Java and HTTP transformation within Informatica;
Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.