Tagcor

Required Skills

Data Warehouse 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

The Data Warehouse Architect is responsible for designing, implementing, and managing data warehouse solutions tailored to integrate with Oracle E-Business Suite (EBS), Oracle Sales/CPQ Cloud, Oracle Field Service Cloud, Oracle EPM Cloud. This role ensures seamless data extraction, transformation, and analysis to support business intelligence (BI) and reporting initiatives. The ideal candidate combines deep knowledge of Oracle EBS modules with data warehousing best practices to deliver scalable and high-performance solutions.

Key Responsibilities:

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.