Senior ODI Developer

Aaura Softwares; Canada; Remote; CAD 80,000 - 100,000; Full time

Job summary

Join a dynamic and innovative software development firm as a Senior ETL ODI Developer! In this remote contract role, you'll leverage your extensive experience in data integration and analysis to design and develop efficient ETL processes using Oracle Data Integrator. You'll play a crucial role in ensuring data quality and supporting the business's unique needs. This opportunity is perfect for those who thrive in a collaborative environment and are eager to tackle complex data challenges. If you're passionate about technology and ready to make an impact, this role is for you!

Qualifications

• 7+ years of experience with ODI tool for data functions and procedures.
• Strong skills in data analysis and SQL for data quality checks.

Responsibilities

• Design and develop ELT processes using Oracle Data Integrator.
• Validate data and ensure smooth project functioning.

Skills

ODI Tool

Data Analysis

SQL

ETL Processes

Object-Oriented Programming

Analytical Skills

Problem-Solving

Job description

Aaura Softwares is a dynamic and forward-thinking software development and staff augmentation firm committed to delivering innovative solutions tailored to clients' unique needs. The company is passionate about leveraging technology and talent to drive businesses forward, whether for specific projects or ongoing support.

Role Description

This is a remote contract role for a Senior ETL ODI Developer. The Senior ETL ODI Developer will be responsible for back-end web development, software development, programming, and object-oriented programming. They will work on day-to-day tasks to ensure the smooth functioning of projects.

Job Description:

• 7+ years’ experience in building functions & stored procedures using ODI tool.
• Design Data Warehouse tables 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).

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Engineering and Information Technology

Industries

• IT Services and IT Consulting