ETL Lead, ODI Developer

Job not on LinkedIn

November 4

Apply Now

Receive Emails with Similar Jobs

Jay Analytix Inc

WebsiteLinkedInAll Job Openings

Artificial Intelligence • B2B • Recruitment

Jay Analytix Inc is a B2B IT consulting firm that provides data solutions, performance engineering, AI/machine learning services, and IT staffing to enterprises across industries. The company offers end-to-end data analytics, dashboards, performance monitoring and optimization, and bespoke AI/ML integrations, alongside global IT recruitment and staffing support. Based in Windsor, Canada, Jay Analytix emphasizes customizable, scalable solutions, transparent communication, and cost-effective engagement for clients in sectors such as healthcare, fintech, energy, entertainment, and insurance.

11 - 50 employees

🤖 Artificial Intelligence

🤝 B2B

🎯 Recruiter

📋 Description

• Design Data warehouse table and applicable documentation. • Develop table creation scripts and execute the scripts for Database Administrator (DBA). • Analyse data sources and determine data relationships to pair with business requirements documentation (BRD). • 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. • Proven skills in data analysis - including queries to calculate data quality.

🎯 Requirements

• 7 + years' experience in building function & store procedure using ODI tool. • Familiarity with data quality issues and Exact, Transform, Load (ETL) processes. • Solid written, verbal, and analytical skills • Strong research and problem determination and solution skills • Flexible to work in Shifts (Rotational) • Knowledge and understanding of applicable tools and practices used in data governance including query and data profiling techniques.