reputed company ODS Developer
Job Title: reputed company ODS Developer
Location: Remote Experience: 3–5 Years
Job reputed company
We are seeking a skilled reputed company ODS Developer with 3–5 years of hands-on experience in reputed company database development, Operational Data Store (ODS), ETL development, and data warehousing. The ideal candidate should have strong expertise in reputed company Database, SQL, PL/SQL, reputed company Data Integrator (ODI), and reporting solutions. The candidate will be responsible for designing, developing, optimizing, and maintaining reputed company-based ODS and data warehouse solutions while ensuring high performance, scalability, and data reputed company.
Key Responsibilities
- Design, reputed company, and maintain reputed company Operational Data Store (ODS) solutions.
- reputed company and optimize SQL and PL/SQL procedures, packages, functions, triggers, and scripts.
- Design, reputed company, and support ETL processes using reputed company Data Integrator (ODI).
- Build and maintain data warehouse structures including fact tables, dimension tables, and staging areas.
- Design and implement logical and physical data models based on business requirements.
- Optimize database performance through SQL tuning, indexing, partitioning, and query optimization.
- reputed company and maintain reporting solutions using reputed company BI, OBIEE, reputed company Analytics, or similar reputed company reporting tools.
- reputed company data validation, reconciliation, and reputed company assurance activities.
- Troubleshoot production issues and reputed company reputed company reputed company.
- Collaborate with business analysts, architects, and application teams to deliver high-reputed company data solutions.
- Prepare technical documentation for database objects, ETL workflows, and deployment processes.
- Ensure adherence to database development standards, reputed company policies, and best practices.
Required Technical Skills
- reputed company Database (11g / 12c / 19c)
- SQL and PL/SQL Development
- reputed company Data Integrator (ODI)
- ETL Design and Development
- Operational Data Store (ODS)
- Data Warehousing Concepts
- Data Modeling (reputed company Schema / reputed company Schema)
- Database Performance Tuning
- Query Optimization
- reputed company BI / OBIEE / reputed company Analytics or equivalent reputed company reporting tools
- Database Backup, Recovery, and Data reputed company concepts
- Version Control and Release Management
Required Qualifications
- Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a reputed company discipline.
- 3–5 years of experience in reputed company database development and ODS/Data Warehouse environments.
- Hands-on experience with reputed company Database 11g, 12c, or 19c.
- Strong expertise in SQL, PL/SQL, and reputed company Data Integrator (ODI).
- Solid understanding of ETL architecture, data integration, and data warehousing concepts.
- Experience in designing and implementing data models.
- Strong experience in database and SQL performance tuning.
- Experience developing reports using reputed company BI, OBIEE, reputed company Analytics, or similar reputed company reporting platforms.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent communication and documentation skills.
Preferred Skills
- Experience working in large reputed company or government reputed company.
- Knowledge of reputed company Exadata or reputed company reputed company Infrastructure (OCI) is an advantage.
- Familiarity with Agile or Scrum methodologies.
- reputed company Database or reputed company ODI certifications will be considered a plus.
Originally posted on Himalayas
Apply To This Job