Experienced ODI 12c Developer with over 5 years of expertise in designing and implementing Extract, Load, and Transform (ELT) processes to integrate data from source systems into data warehouses. Proficient in designing data warehouse tables, creating table creation scripts, and executing them for the Database Administrator (DBA). Strong knowledge of data quality issues, query techniques, and data profiling. Skilled in working with cross-functional teams to translate business requirements into technical solutions and validate data through SQL queries. Ability to document processes and ensure data governance practices are followed.

Key Responsibilities:

• Design and develop ELT processes using Oracle Data Integrator (ODI) to load data from source tables into staging tables, then transform and load into target fact and dimension tables.
• Create and execute table creation scripts for the DBA, ensuring proper design and functionality of data warehouse tables.
• Validate data integrity and transformation results through SQL queries and other analysis techniques.
• Collaborate with business analysts to understand business requirements and translate them into technical specifications.
• Design data warehouse tables and maintain appropriate documentation for data models and scripts.
• Analyze data sources, define relationships, and ensure data quality by identifying and addressing any issues with the ETL/ELT processes.
• Familiarity with data governance practices, including query optimization and data profiling.
• Develop and maintain function and stored procedures using ODI to facilitate data processing and integration.
• Utilize research and problem-solving skills to diagnose and resolve issues related to data loading and transformations.

Must Haves:

• 5+ years of experience working with ODI, particularly ODI 12c.
• Proven experience in designing and implementing ELT processes, particularly in data warehousing environments.
• Expertise in creating and executing table creation scripts for data warehouse implementation.
• Proficiency in SQL for data validation and analysis.
• Strong documentation skills for data models, table structures, and ELT processes.
• Familiarity with data governance tools and practices, including data profiling and query optimization techniques.
• Solid problem-solving abilities and excellent communication skills, both written and verbal.
• Experience in developing and maintaining stored procedures and functions using ODI.