ETL ODI Developer

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.