ETL Lead ODI Developer

Jay Analytix INC.; Canada; Remote; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a seasoned data analyst with over 7 years of experience in building functions and procedures using Oracle Data Integrator (ODI). This role involves designing data warehouse tables, developing scripts for database management, and validating data quality. The ideal candidate will have strong analytical skills and a solid understanding of ETL processes, ensuring data integrity and governance. If you are flexible with shifts and ready to make an impact in a dynamic environment, this opportunity is perfect for you.

Qualifications

• 7+ years of experience in data analysis and ETL processes.
• Proven skills in data quality assessment using SQL.

Responsibilities

• Design and develop ELT processes for data warehousing.
• Analyze data sources to meet business requirements.

Skills

Data Analysis

SQL

ETL Processes

Data Governance

Problem Solving

Communication Skills

Tools

Oracle Data Integrator (ODI)

Job description

7 + years' experience in building function & store procedure using ODI tool.
Design Data warehouse table and applicable documentation.
Develop table creation scripts and execute the scripts for the Database Administrator (DBA).
Analyse data sources and determine data relationships to pair with the business requirements documentation (BRD).
Familiarity with data quality issues and Exact, Transform, Load (ETL) processes.
Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI).
Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis.
Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques.
Proven skills in data analysis - including queries to calculate data quality.
Solid written, verbal, and analytical skills.
Strong research and problem determination and solution skills.
Flexible to work in Shifts (Rotational).

Note: looking for candidates those who are presently in Canada.