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.
Nice to have :
Good understanding and implementation experience in Data Governance, Data Quality, Data Modelling etc.; Experience in Snowflake;
Experience with PySpark, Python programming.