Extract, Transform, Load Engineer Vayuz Technologies
Vayuz Technologies
Office Location
Full Time
Experience: 5 - 5 years required
Pay:
Salary Information not included
Type: Full Time
Location: All India
Skills: data warehouse design, SQL, Oracle Data Integrator, data governance, Data Analysis, ODI tool, ETL processes, ELT Process
About Vayuz Technologies
Job Description
Requirements 1. 5 + years experience in building function & store procedure using ODI tool. 2. Design Data warehouse table and applicable documentation. 3. Develop table creation scripts and execute the scripts for the Database Administrator (DBA). 4. Analyze data sources and determine data relationships to pair with the business requirements documentation (BRD). 5. Familiarity with data quality issues and Exact, Transform, Load (ETL) processes 6. 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). 7. Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. 8. Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques. 9. Proven skills in data analysis including queries to calculate data quality. 10. Solid written, verbal, and analytical skills. 11. Strong research and problem determination and solution skills.,