Job Title

Akkodis is currently searching for an ERP Technical Analyst - Informatica (ETL & Data Quality) on a contract basis for a Government of Canada Client. Job Summary:Analyze requirements for sourcing and transformation of data by Informatica.Design ETL Data Quality process and workflows using the Informatica Developer Client.Design, test, optimize and debug ETL Workflows using the Informatica Developer Client.Analyze Siebel CRM data data using SQL (Microsoft and Netezza) against supplied Functional Design Documents (FDDs).Program Python scripts for APIs and other programming work, debug processes in our three environments, work with Clients to implement API for Titanfile automation.Work with EDMAS data modelers, analysts, ETL team, data architects.Conduct performance tests to optimize Informatica processes.Document Informatica installation and configuration for ETL optimisation processes.Document all development processes.Metadata Manager lineage from Cognos and OBIEE.Provide technical guidance and knowledge transfer to the development team.The successful candidate must possess the following skills and experience:Hold active Level 2 Secret security clearance issued by federal Government of Canada7+ years experience providing services in a Data Warehouse and Business Intelligence environment with the Informatica products.10+ years of experience as an ERP Technical Analyst.7+ years experience upgrading and administering Informatica Power Centre, Metadata Manager and Data Quality.7+ years experience in performing data analysis and data profiling for the purpose of data integration, and data quality assessment in a Data Warehouse environment.7+ years experience in optimizing ETL (eg. using partial and full pushdown techniques) to support Data Integration from various sources.7+ years experience in in Database programming (e.g. Transact SQL to develop queries) to perform analysis and performance tuning against ETL processes.All candidates must hold a valid federal government security clearance at the Secret level. Akkodis Canada is an equal opportunity employer that is committed to diversity, equity and inclusion. All employment is decided on the basis of qualifications, merit and business needs. Akkodis would like to thank all candidates for submitting to this job opportunity, however, only those with the above qualifications clearly identified in their resumes will be contacted for further instruction and submission to the client.Were at the center of exceptional IT connections. Every day, Akkodis connects premier IT professionals to great opportunities at leading companies. Put our connections to work for you!