Oracle ODS Developer
Tasks
- Build and maintain data warehouse structures fact tables dimension tables and staging areas
- Collaborate with analysts architects and application teams to deliver data solutions
- 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 Oracle Analytics
- Develop and optimize SQL and PL SQL procedures packages functions triggers and scripts
- Ensure adherence to database standards security policies and best practices
- 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 resolve issues
Perks/Benefits
Skills/Tech-stack
Agile | Cloud infrastructure (OCI | Data Integrity | Data Modeling | Data Warehousing | Database Backup | Database performance | Database performance tuning | Database recovery | ETL | OBIEE | Operational Data Store ODS | Operational data | Operational data store | Oracle Analytics | Oracle BI | Oracle Cloud | Oracle Cloud Infrastructure | Oracle Cloud Infrastructure OCI | Oracle Data | Oracle Data Integrator | Oracle Data Integrator ODI | Oracle Database | Oracle Exadata | PL/SQL | Performance Tuning | Query Optimization | Release Management | SQL | Scrum | Snowflake Schema | Star Schema | Version control
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