— 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);
— Experience in UNIX scripting and job scheduling tools;
— Strong functional and analytical skills;
— Experience with TFS or GIT;
— Experience with SDLC/Waterfall/Agile methodologies and developing Project Artifacts.
— Good understanding and implementation experience in Data Governance, Data Quality, Data Modelling etc.;
— Experience in Snowflake;
— Experience with PySpark, Python programming.
— New office with areas for recreation, well-staffed kitchen facilities, shower, covered bike parking;
— Compensation of medical service;
— Sport compensation: gym-membership reimbursement, small gym on-site;
— Language school;
— Compensation of training: our employees can participate in the training given by external and internal experts;
— PE accounting and support;
— Free fruits and sweets.
— 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.
Avenga is a global IT and digital transformation champion. Together, we are more than 2500 professionals with over 20 years of experience. We deliver strategy, customer experience, solution engineering, managed services and software products. Our mission is to shake up the conventional IT market.
Now, we are looking for a Middle Strong/Senior ETL Informatica Engineer to join our team on a full-time basis. As a part of our team, you will be involved in development of new ETL processes, flows with various conditions. Migrate the existing flows from MuleSoft to Informatica CAI.