Required Skills

Dataware house Architect

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 13th Aug 2025

JOB DETAIL

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.

Company Information