Job description

Job Title: ETL ODI Developer
Location: Chennai & Remote
Employment Type: Full Time
Experience Required: 5+ Years
Notice Period: Immediate or Less than 30 Days

Key Responsibilities

Over 5 years of experience in developing functions and stored procedures using the ODI tool.
Design data warehouse tables and prepare relevant documentation.
Create and execute table creation scripts in collaboration with the Database Administrator (DBA).
Analyze data sources, identify relationships, and align them with Business Requirements Documentation (BRD).
Address data quality issues and manage Extract, Transform, Load (ETL) processes effectively.
Design and develop ELT processes to load data from source tables into staging, and subsequently into target fact and dimension tables using Oracle Data Integrator (ODI).
Validate loaded data in various tables using SQL and other analytical techniques.
Demonstrate a strong understanding of data governance tools and practices, including query and data profiling techniques.
Perform data analysis tasks, including queries to assess data quality.
Exhibit excellent written, verbal, and analytical communication skills.
Conduct thorough research and demonstrate problem-solving skills to determine and implement effective solutions.
Flexible to work in rotational shifts as required.