Senior ETL Developer

Job Type- Contract(12 months)

Job Summary

The Senior ETL Developer works on defining system solutions to acquire and share data and develop information and analyses to CIHI’s clients and stakeholders.

The Senior Developer operates, maintains and develops system solutions in current technologies as well as supporting and enabling initiatives on new platforms, technologies and services.

Duties and Responsibilities

• Develops information systems, which may include the full range of requirements and feasibility analysis, design, coding, testing, quality assurance, implementation and documentation, as well as day-to-day application operation and end-user support, as part of a technical team.
• Develops business processes knowledge and maintain ongoing contact, to ensure satisfaction by meeting business partner needs through information systems development, enhancements and integrations.
• Executes the operational tasks related to incident troubleshooting and correction and scheduled product releases and works on optimizing and automating these tasks to reduce operational effort, on a rotation basis.
• Analyses software deficiencies / problems and change requests, implements the changes within the production systems and may be required to oversee and ensure timely implementation of the changes for the technical team.
• Develops, modifies and executes test plans, using automation to improve testing coverage and reduce effort.
• Ensures the correct testing and sign-off procedures as part of CIHI’s quality assurance review.
• Ensures the promotion and implementation of applications in accordance with departmental change management processes.
• Participates in the planning, development and delivery of end user training.

Knowledge and Experience

• University Degree or equivalent education / experience in Computer Science, Mathematics or related discipline.
• Three (3) + years experience as an ETL developer , developing technical solutions for a web / Cloud based environment utilizing the below technologies.
• Three (3) + years proven experience with ETL tools (Informatica DEI / BDM) , PySpark, Oracle DB, PL / SQL, Git, Airflow, Python.
• Knowledge and experience with Cloud AWS environment, tools and services is an asset.
• Proficient knowledge and experience in shell scripting in Linux / Unix environment
• Experience in creating and maintaining documentation of project ETL design, technical artifacts and ETL environment.
• Experience with AWS EMR platform is an asset.
• Experience with the following is an asset : Scrum / Kanban Agile framework, Data warehousing platforms (AWS RDS, Redshift), Data analytics (Python, R, SAS), BI Tools (MicroStrategy, Qlik).
• Knowledge and experience with automated testing and DevOps is an asset.
• Ability to understand and prioritize user and business requirements, and to conceptualize information processing solutions in response to them.
• Ability to plan and coordinate workload effectively, including managing and prioritizing multiple tasks.
• Strong team player with a client / user orientation
• Fluency in English is required, bilingualism, in both official languages is an asset.
Il y a 29 jours