ETL Developer

ETL Developer
Contract
Markham ON Canada

Email: rohit.k@jconnectinc.com

Design develop and maintain ETL processes to extract transform and load data from various sources
Handson experience in upgrading of Informatica PowerCenter from a lower version to a higher version
Proven experience as an ETL Developer Informatica PowerCenter and Informatica BDM Experience in understanding the XML and JSON file and working on conversion using informatica power centerInformatica BDM is an asset
Develop and optimize complex SQL queries and stored procedures in PostgreSQL
Experience on automation tools like ControlM ASG ZENA Experience in writing Unix scripts
Experience in working on the VISIO
Experience in working on the SourceTree GITVersion Control
Experience on Performance Tuning Techniques in Postgres and Oracle and informatica
Experience on extracting and loading Flat Files both delimited and Fixed width using Informatica Power Center
Technical Secondary Skills
Informatica Certified Professional ICP andor Informatica Foundation Level Certifications IDMC CDCG MDM etc
Working knowledge on IDMC is an asset
Experience with database systems eg Oracle Postgres MySQL SQL Associate Certification an asset
Knowledge of data visualization tools eg Qlik Python Power BI SAP BO
Preferable experience in the insurance industry able to understand underwriting data terminology
Soft Skills
Excellent problemsolving skills and attention to detail
Experience in Agile methodology JIRA
Good communication and collaboration skills Strong ability to work with client stakeholders
Ability to work both independently and as part of a team

Skills
Mandatory Skills : ETL Concepts,Presto,Python,Treasure Data,ANSI-SQL,Dimensional Data Modeling