Overview:
The ELT Database Developer plays a critical role in designing implementing and maintaining the organizations Extract Load Transform (ELT) processes. This pivotal position is essential for ensuring the accuracy efficiency and scalability of data movement and transformation within the organizations databases.
Contract
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
database,sql,etl,agile,jira