Responsibilities:
· Design, develop, and maintain data warehouse solutions using Oracle Cloud platform with Oracle Analytics Cloud and ODI Marketplace.
· Collaborate with cross-functional teams to gather and analyze business requirements for analytical models and reporting solutions.
· Develop, implement and support data integration processes to extract, transform, and load (ETL) data from various sources into the data warehouse.
· Design and optimize data models to support business analytics and reporting requirements.
· Develop and deploy analytical models using Oracle Analytics Cloud (OAC) to provide insights and drive decision making.
· Perform data analysis and troubleshooting to identify root causes of issues and implement solutions.
· Develop and maintain documentation of data warehouse architecture, processes, and procedures.
· Stay up-to-date on industry trends and best practices in data warehousing, analytics, and cloud technologies.
Requirements:
· Bachelor's Degree in Computer Science / Information Systems, or related field.
· Minimum of 8 years of experience working with Oracle Analytics Cloud (OAC/OBIA/OBIEE) or similar cloud-based analytics platforms.
· Minimum 8 years of experience working with OBIEE/RPD modeling
· Minimum of 8 years of ETL experience ODI/Informatica - ODI Preferred
· Minimum of 4 years of experience building Analytics Visualization using tools like OAC, Power BI, OBIEE, Tableau
· Strong proficiency in Oracle (SQL/PLSQL) and experience with data modeling and database design principles.
· Experience with data integration tools and techniques
· Experience in designing end-to-end implementation involving Data Analysis, Data Cleansing and Data Modelling
· Experience in collaborating Design reviews with the business analysts and business users to create a proof of concept for the reports.
· Experience in handling Finance and SCM data and the related data pipelines.
· Knowledge in Oracle EBS COA, OU, MOAC , multi-currency configurations.
· Knowledge of data warehousing concepts and methodologies, including star schema, snowflake schema, and dimensional modeling.
· Experience developing and deploying analytical models using Oracle Analytics Cloud (OAC) or similar tools.
· Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
· Strong problem-solving skills and attention to detail.
· Oracle certifications in Analytics Cloud or related areas (preferred).
· Experience in Python to develop machine learning models and AI-driven solutions for predictive analytics and process optimization is a plus