Match score not available

ETL ODI TPM

Remote: 
Full Remote
Contract: 
Experience: 
Mid-level (2-5 years)
Work from: 

Offer summary

Qualifications:

7+ years experience in ODI, Project Management for 3+ years.

Key responsabilities:

  • Design Data warehouse table and documentation
  • Develop and execute table creation scripts
  • Analyze data sources and define data relationships
  • Design ELT process to load data using ODI
  • Validate data loaded in tables with SQL
CodersBrain logo
CodersBrain SME https://www.codersbrain.com/
201 - 500 Employees
See more CodersBrain offers

Job description

Job Role: ETL ODI TPM
Experience: 8+ years
Location: Remote

Job Description:
7+ years’ experience in building function & store procedure using ODI too and 3+ Years in Project Management
Strong in Agile, JIRA
Design Data warehouse table and applicable documentation.
Develop table creation scripts and execute the scripts for the Database Administrator (DBA).
Analyze 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 skill

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Industry :
Management Consulting
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Verbal Communication Skills
  • Analytical Thinking
  • Analytical Skills

ETL Developer Related jobs