Oracle Data Integrator

As a Data Warehouse Developer, you will play a crucial role in designing, building, and enhancing our client's online platform. Your responsibilities will include researching, suggesting, and implementing new technology solutions in line with best practices and standards. You will also be accountable for ensuring the resiliency and availability of various products while actively contributing to the team's productivity. Your expertise should encompass over 7 years of practical experience in designing and constructing functions and stored procedures using Oracle Data Integrator (ODI). You will be tasked with creating data warehouse schemas, including fact and dimension tables, and documenting them comprehensively. Collaborating with DBAs, you will develop and execute table creation scripts, analyze diverse data sources to establish data relationships as per Business Requirements Documents (BRDs), and possess a deep understanding of data quality, ETL/ELT processes, and common transformation patterns. Furthermore, your role will involve designing and implementing ELT workflows to load data from source systems into staging environments, and subsequently into target models leveraging ODI. Conducting data validation using advanced SQL queries and data profiling techniques will be a key aspect of your responsibilities. Demonstrating a solid grasp of data governance concepts, tools, and best practices, you will be adept at data quality analysis, including assessing accuracy, completeness, and consistency through query composition. Your skill set should encompass strong analytical capabilities, effective research skills, and adept problem-solving abilities. Excellent written and verbal communication skills are essential, along with the flexibility to work in rotational shifts. In return, you can look forward to working in a challenging and innovative environment that offers ample opportunities for learning and growth as needed.,