Вакансії ІТ Кластер

Middle Strong/Senior ETL Informatica Engineer

Middle Senior Avenga
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.

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.

  • 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.

Nice to have:
  • Good understanding and implementation experience in Data Governance, Data Quality, Data Modelling etc.;
  • Experience in Snowflake;
  • Experience with PySpark, Python programming.

Made on