• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 18th Mar 2025

1. Analyze Current Environment A thorough assessment of the existing Oracle Data Integrator, Oracle Database, and OBIEE Rapid File Database (RPD) environment will be conducted, including:

• Detailed plan with conversion steps, dependencies, and validation strategy.
• OBIEE RPD Assessment – Identifying subject areas, data source mappings, and conversion complexity.
• Data Models – Analyzing table relationships, fact/dimension models.
• Security & Access – Identifying existing security roles, policies, and groups.
• Performance Metrics – Evaluating pipeline execution efficiency and bottlenecks.
• ETL/ELT Pipelines – Identifying dependencies and process flow.
• Data Sources & Integrations – Documenting relational/non-relational databases.

2. Migrate data from Oracle to cloud data warehouse

Data Migration Process:

• Extract historical and incremental data from Oracle.
• Transform data using Azure Data Factory (ADF) or equivalent orchestration tools.
• Load data into cloud data warehouse using bulk data movement strategies.
• Validate migrated data against Oracle to ensure accuracy and completeness.
• Optimize partitioning, indexing, and clustering in the target data warehouse.

Data Warehouse Design:

• Implement staging, raw, and transformed layers for optimized data storage.
• Design and transition of Oracle schemas and tables to cloud data warehouse

3. Convert PL/SQL transformation logic to cloud data warehouse and leverage built-in streaming and automation capabilities.

4. Migration from ODI to Azure Data Factory (ADF)

• Topology – document Physical Architecture, Contexts and Logical Architecture etc.
• Convert ODI workflows to ADF Pipelines with equivalent or enhanced functionality.
• Rebuild parameterized pipelines to accommodate reusable ETL logic.
• Configure linked services to integrate data sources/destinations cloud data warehouse
• Develop logging, error handling, and monitoring mechanisms using Azure Monitor and Log Analytics.
• Optimize workflows for scalability and cost-efficiency (parallelism, trigger scheduling).
• Implement Change Data Capture (CDC) for incremental loads where applicable.

5. OBIEE RPD to Power BI Data Model Migration

• Extract and document RPD metadata; including logical models, subject areas, and presentation layers.
• Map OBIEE RPD relationships to Power BI datasets and dataflows.
• Convert logical models to physical models where applicable for optimized performance.
• Ensure role-based access security mappings are transitioned correctly.
• Validate Power BI data models against OBIEE reports for accuracy.

6. OBIEE Dashboards to Power BI Dashboards Migration

• Recreate OBIEE dashboards and reports in Power BI with modern interactive capabilities.
• Implement row-level security (RLS) and access control policies in Power BI.
• Enhance report performance using Power BI Direct Query and Import modes.
• Optimize layouts, interactivity, and navigation for a seamless end-user experience.
• Train business users on self-service analytics and report customization.

7. Knowledge Transfer

Deliver Comprehensive Knowledge Transfer sessions on:

• Developing Power BI dashboards and reports.
• Managing and maintaining the new post-deployment system.
• Post-implementation support for issue resolution and system enhancements.