aijobs.net

Sign in

Oracle ODS Developer

Karachi, Sindh

USD 79K-178K (estimate) Mid-level Full Time

Apply Save

Found 1d ago

Tasks

Build and maintain data warehouse structures including fact tables dimension tables and staging areas
Collaborate with business analysts architects and application teams
Design and implement logical and physical data models
Design develop and maintain Oracle Operational Data Store ODS solutions
Design develop and support ETL processes using Oracle Data Integrator ODI
Develop and maintain reporting solutions using Oracle BI OBIEE and Oracle Analytics
Develop and optimize SQL and PL SQL procedures packages functions triggers and scripts
Optimize database performance using SQL tuning indexing partitioning and query optimization
Perform data validation, reconciliation, and quality assurance
Prepare technical documentation for database objects ETL workflows and deployments
Troubleshoot production issues and provide timely resolution

Perks/Benefits

N/A

Skills/Tech-stack

Backup & Recovery | Data Modeling | Data Warehousing | Database Backup | Database backup/recovery | Database performance | Database performance tuning | ETL | OBIEE | Oracle Analytics | Oracle BI | Oracle Data | Oracle Data Integrator | Oracle Data Integrator ODI | Oracle Database | PL/SQL | Performance Tuning | Query Optimization | Release Management | SQL | Snowflake Schema | Star Schema | Version control

Education

N/A

Roles

Developer | Oracle ODS Developer

Regions

Countries

States

Cities

Karachi, Sindh, PK

Apply Save

Language: en Views: 0

Clicks: 0

Saves: 0

Related jobs

Senior BI & Advanced Analytics Developer USD 100K-138K

DAX | Data Modeling | ETL | Power Query | PowerBI

Senior-level Full Time

Pakistan - Remote R

13d ago
Power BI Specialist EUR 9K-21K

Crystal Reports | DAX | Data Modeling | Data Warehousing | Dimensional Modeling

Health insurance | In-house lunch | Inclusive environment | International project exposure | Paid time off

Senior-level Full Time

Lahore, Punjab, PK

14d ago
Remote Backend Django Engineer – AI & Algorithmic Systems USD 162K-220K

Caching | Cloud platform | Database Modeling | Django | Django REST

Bonus after assessment | Remote work

Senior-level Full Time

Lahore, Pakistan R

1mo ago
PowerBI Developer USD 108K-134K

Azure DevOps | Calculation Groups | DAX | Data Warehousing | Dimensional Modeling

Health insurance | OPD | Paid time off | Work from home

Senior-level Full Time

Pakistan - Remote R

1mo ago