Oracle ODS Developer
Tasks
- Build and maintain data warehouse structures fact tables dimension tables staging areas
- Design develop and support ETL processes using Oracle Data Integrator ODI
- Design develop maintain Oracle Operational Data Store ODS solutions
- Design implement logical and physical data models
- Develop and maintain reporting solutions with Oracle BI OBIEE Oracle Analytics
- Develop optimize SQL and PL SQL procedures packages functions triggers scripts
- Ensure adherence to database development standards security policies and best practices
- Optimize database performance with SQL tuning indexing partitioning query optimization
- Perform data validation, reconciliation, and quality assurance
- Prepare technical documentation for database objects ETL workflows deployment processes
- Troubleshoot production issues and provide resolution
Perks/Benefits
Skills/Tech-stack
Agile | Backup & Recovery | Data Integrator | Data Modeling | Data Store | Data Warehousing | Database performance | Database performance tuning | ETL | Indexing | OBIEE | Operational data | Operational data store | Oracle Analytics | Oracle BI | Oracle Data | Oracle Data Integrator | Oracle Database | PL/SQL | Partitioning | Performance Tuning | Query Optimization | Release Management | SQL | Scrum | Snowflake Schema | Star Schema | Version control
Education
Bachelor of Engineering | Bachelor of Science | Bachelor of Technology
Related jobs
-
Robotic Process Automation (RPA) Professional INR 2500K-4000K.NET | AI Center | API Integration | Automation Cloud | Azure CopilotSenior-level Full TimePune - Maharashtra - India12h ago
-
Lead Assistant Manager INR 1500K-3000KAWS | Agile | Angular | Application Monitoring | Artificial IntelligenceMentoring | Team collaboration | Technical leadershipSenior-level Full TimePune, Maharashtra, India19h ago
-
Digital Data Engineer / Plant Specialist Level 2 INR 600K-600KAWS | Data Pipelines | Data Quality | ETL | LinuxInclusion and diversity initiatives | Learning and development | Multicultural environment | Training hoursEntry-level Full TimePUNE R&D,IN-MH,India19h ago
-
Senior-level Full TimeBengaluru, India22h ago
-
AWS | Amazon Web Services | Apache Airflow | Apache Hadoop | Apache SparkFlexibility programs | Inclusive benefits | MentorshipSenior-level Full TimeHyderabad - Salarpuria, India1d ago
-
Oracle SQL Developer – PL/SQL, ETL & Query Optimization INR 1000K-1700KAccess Control | Analytic Aggregations | Analytical Functions | Audit Logging | Bulk ProcessingMid-level Full TimePune - Hinjewadi (Ascendas), India1d ago
-
AWS | Agile | C# | CI/CD | D3.jsSenior-level Full TimeGurugram Downtown 4, India1d ago
-
AWS | Amazon Web Services | Apache Airflow | Apache Hadoop | Apache SparkSenior-level Full TimeHyderabad - Salarpuria, India1d ago
-
Senior-level Full TimePune, Gera Commerzone SEZ, India1d ago
-
Staff Software Engineer - Fullstack INR 2475K-3500KAccessibility | Dashboarding | Data Pipelines | Data Visualization | Distributed SystemsSenior-level Full TimeBengaluru, India1d ago
-
API Development | Agile | Authentication | Authorization | CI/CDMid-level Full TimeBengaluru - GTP, India2d ago
-
Python AI Developer – Machine Learning, Cloud & Agile Delivery INR 1200K-2100KAPI Development | Access Management | Agile | Artificial Intelligence | AuthenticationMid-level Full TimeBengaluru - GTP, India2d ago
-
Senior-level Full TimeHyderabad, India2d ago
-
Senior-level Full TimePune, Maharashtra, India2d ago
-
Senior-level Full TimePune, Maharashtra, India2d ago
-
Junior SQL/ETL Developer INR 400K-500KAWS | Azure | Data Modeling | Data Pipeline Monitoring | Data QualityEntry-level Full TimeMumbai, Maharashtra, India3d ago
-
Data Analyst - Power BI Job INR 1000K-2000KAzure Blob | Azure Blob Storage | Azure Data | Azure Data Factory | Azure SQLFlexible work arrangements | Training and knowledge-sharing sessionsMid-level Full TimeBangalore, KA, IN4d ago
-
Senior Applications Developer- Data Scientist INR 2040K-3000KCloud platform | Google Cloud | Google Cloud Platform | SQLSenior-level Full TimeIN - TDC 1 (IN110), India4d ago
-
Lead, Power BI INR 3000K-4000KAgile | Azure Data | Azure Data Factory | Azure Data Lake | Azure SQLEmployee resource groups | Learning and development opportunities | Paid Company Holidays | Paid vacation | Volunteer timeSenior-level Full TimeIN025 Embassy Manyata Business Park, India R4d ago
-
Lead, Power BI developer INR 3000K-4000KAgile | Azure | Azure Data | Azure Data Factory | Azure Data LakeEmployee resource groups | Learning and development | Paid Company Holidays | Paid vacation | Volunteer timeSenior-level Full TimeIN025 Embassy Manyata Business Park, India R4d ago
-
Python & Generative AI Technical Lead INR 2500K-4800KAPI Development | Access Management | Agile | Authentication | AuthorizationSenior-level Full TimeHyderabad Eco Park, India4d ago
-
Python AI Developer – Machine Learning, Cloud & Agile Delivery INR 1400K-2200KAPI Development | Access Management | Agile | Artificial Intelligence | AuthenticationMid-level Full TimeHyderabad Eco Park, India4d ago
-
ETL Informatica Developer-IT INR 1000K-2000KChange Data Capture | Data Capture | Data Lake | Data Modeling | Data PrivacyHealth insurance | Paid time off (PTO)Mid-level Full TimeChennai, India4d ago
-
Analytics Specialist Developer INR 600K-700KAcceptance Testing | Agile | Azara | Business Intelligence | Code reviewMid-level Full TimeIND-CORP Bengaluru-TDIM - PTT, India4d ago
-
Application Development Senior Analyst INR 2500K-3500KAgile | CD | CI | CI/CD | ETLTraining and learning opportunitiesSenior-level Full TimeIND Bengaluru, India4d ago