Location: Offshore - Remote
Job Summary
We are seeking an experienced ODS (Operational Data Store) Developer with strong expertise in ETL Development, Oracle PL/SQL, and Data Engineering to join our team in Riyadh. The ideal candidate will have experience designing, developing, and supporting enterprise-scale ODS and ETL solutions for high-volume data processing in banking, telecom, or other enterprise environments.
Key Responsibilities
- Design, develop, and maintain Operational Data Store (ODS) solutions.
- Develop, enhance, and support ETL workflows using enterprise ETL tools.
- Build and optimize Oracle PL/SQL packages, procedures, functions, triggers, and complex SQL queries.
- Design and maintain batch and real-time data integration pipelines.
- Integrate data from multiple enterprise source systems into ODS platforms.
- Perform data validation, reconciliation, and exception handling.
- Monitor ETL jobs and resolve production issues while meeting SLA requirements.
- Perform root cause analysis and implement permanent fixes for production incidents.
- Optimize ETL jobs, SQL queries, and database performance.
- Participate in production deployments, environment setup, and release activities.
- Collaborate with business stakeholders to understand data requirements and deliver scalable data solutions.
- Prepare technical documentation, ETL design documents, and operational runbooks.
Required SkillsCore Skills
- Operational Data Store (ODS) Development
- ETL Design & Development
- Oracle Database
- Oracle PL/SQL
- SQL Performance Tuning
- Query Optimization
- Data Integration
- Data Warehousing
- Data Modeling
- Production Support (L2/L3)
Technical Skills
- Hands-on experience with any enterprise ETL tool (such as Ab Initio, Informatica, IBM DataStage, Talend, ODI, SSIS, Pentaho, or equivalent)
- Kafka or other messaging/streaming platforms (preferred)
- Unix/Linux
- Shell Scripting
- Git or other Version Control systems
- Batch and Real-Time Data Processing
- Incident Management and Root Cause Analysis
Preferred Qualifications
- Banking or Financial Services domain experience.
- Telecom domain experience.
- Experience working on enterprise-scale ODS or Data Warehouse platforms.
- Exposure to Agile/Scrum methodologies.
- Experience with high-volume, mission-critical production environments.
Education
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
Pay: ₹366,071.69 - ₹1,507,197.94 per year
Work Location: In person
