| Urgent Need of Data Warehouse Architect -- Remote -- Any visa at Remote, Remote, USA |
| Email: [email protected] |
|
Job Description: Data Warehouse Architect Location: Remote Visa: H1b/GC/USC Position Overview: 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. Required Qualifications: Technical Skills: Good understanding of ERP processes in key modules like Financials, Supply Chain, Service, Sales and HRMS. Proficiency with ETL tools such as Oracle Data Integrator (ODI), Informatica, or Talend. Experience in data modeling, warehousing techniques, and database design. Familiarity with reporting and BI tools (e.g., Oracle BI Publisher, Tableau, Power BI). General Skills: Solid understanding of data warehousing principles and best practices. Knowledge of cloud platforms such as Oracle Cloud, AWS, or Azure is a plus. Strong analytical, problem-solving, and communication skills. Experience with Agile development methodologies is desirable. Education and Experience: Bachelors or Masters degree in Computer Science, Information Systems, or a related field. 10+ years of experience in data warehousing Hands on experience in strategy, design and implementation of data warehouse, reporting, data analytics projects for manufacturing customers. Thanks & Regards, Saurabh Singh E: saurabh.singh @sanmanaglobal.com | www.sanmanaglobal.com 2338 RAY HUBBARD WAY, WYLIE | TEXAS, 75098 -- Keywords: business intelligence information technology green card Urgent Need of Data Warehouse Architect -- Remote -- Any visa [email protected] |
| [email protected] View All |
| 06:28 PM 11-Dec-24 |