Job Title Oracle DW
Company TCS (MEA)
Location Riyadh, Saudi Arabia
Job type Full time
About Us :
Tata Consultancy Services (TCS) is an IT services, consulting and business solutions organization that has been partnering with many of the world's largest businesses in their transformation journeys for over 50 years. TCS offers a consulting-led, cognitive powered, integrated portfolio of business, technology and engineering services and solutions. This is delivered through its unique Location Independent Agile delivery model, recognized as a benchmark of excellence in software development.
A part of the Tata group, India's largest multinational business group, TCS has over 616,171 of the world's best-trained consultants with 157 nationalities in 53 countries. For more information, visit www.tcs.com and follow TCS news at @TCS_News.
Job Description:
Business Requirements and Analysis:
- Collaborate with business stakeholders to gather and analyze reporting and analytical requirements for both EBS and DW.
- Translate business needs into technical specifications for DW and EBS integrations.
Data Warehousing and Integration:
- Design, develop, and maintain the Oracle data warehouse, including dimensional modeling and ETL (Extract, Transform, Load) processes.
- Develop and implement ETL procedures to load data from EBS and other sources into the data warehouse.
Reporting and Analytics:
- Design and develop reports, dashboards, and analytical tools using Oracle Business Intelligence (BI) tools like Oracle Analytics Cloud or OBIEE.
- Ensure data accuracy, integrity, and performance for all reports and dashboards.
EBS Expertise:
- Possess a strong understanding of Oracle EBS modules and data structures, particularly in areas like Financials, Supply Chain Management (SCM), and Order Management.
- Perform data extractions and data mapping from specific EBS tables for reporting purposes.
Technical Skills:
- Proficiency in SQL and PL/SQL for data manipulation and querying.
- Familiarity with ETL tools and technologies, such as Oracle Data Integrator (ODI).
Support and Maintenance:
- Provide ongoing support for the DW and EBS integrations, troubleshooting any issues that arise.
- Monitor the performance of the DW and BI solutions and implement optimizations as needed.
Application Deadline : 30 -Dec-2025
Privacy Note:
https://www.tcs.com/connect-with-tcs/privacy-policy
