US Citizen
Green Card
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 13th Aug 2025
Data Warehouse Architecture
Design and implement data warehouse architectures to support Oracle EBS modules (e.g., Financials, SCM, HRMS, Planning), OFSC, Oracle Sales and CPQ Cloud.
Define data modeling strategies, including star and snowflake schemas, to support reporting and analytics.
Develop scalable ETL/ELT workflows for data extraction from Oracle EBS.
Integration and Data Management
Build and maintain integration pipelines between Oracle EBS and the data warehouse.
Ensure data consistency, accuracy, and integrity during migration and transformation processes.
Implement and manage metadata and master data management (MDM) strategies.
Performance Optimization
Optimize query performance through indexing, partitioning, and other database tuning techniques.
Monitor and improve the performance of ETL/ELT processes and data warehouse operations.
Data Governance and Security
Establish data governance frameworks to ensure compliance with organizational and regulatory requirements.
Implement robust security measures to safeguard sensitive data from Oracle EBS.
Collaboration and Support
Partner with business analysts, developers, and stakeholders to understand reporting needs.
Provide technical guidance to data engineering and BI teams.
Support reporting tools like Oracle BI, Tableau, or Power BI for data visualization.
Documentation and Maintenance
Maintain comprehensive documentation for data models, workflows, and system architecture.
Ensure timely updates and upgrades to accommodate Oracle EBS changes or new modules.