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 problemsolving skills to determine and implement effective solutions.
- Flexible to work in rotational shifts as required.