| Data Warehouse Architect ||| Remote ||| USC, GC Only at Remote, Remote, USA |
| Email: [email protected] |
|
From: mayank, winorbit technology [email protected] Reply to: [email protected] Dear Partners, Hope you are doing great. Please find below job requirement and share the details and resumes if you have any matching resources. Job Title: Data Warehouse Architect Location: Remote Visa: GC/USC LinkedIn is must 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 and regards, Mayank Bijlwan Technical Recruiter + 1 813 412 5257 Winorbit Technology LLC 10834 Breaking Rocks Dr Tampa, FL 33647 Keywords: business intelligence green card Florida Data Warehouse Architect ||| Remote ||| USC, GC Only [email protected] |
| [email protected] View All |
| 10:03 PM 10-Dec-24 |