Title : OBIA / ODI Developer (SQL Expertise)
Experience : 4+ Years
Location : Remote (India)
Employment Type : Full-time
About the Role :
We are seeking a highly skilled OBIA + ODI Developer with strong SQL expertise to join our remote team. The ideal candidate will be responsible for developing, enhancing, and maintaining Oracle Business Intelligence Applications (OBIA) and Oracle Data Integrator (ODI) solutions to support enterprise reporting and analytics initiatives.
Key Responsibilities :
- Design, develop, and maintain OBIA ETL processes using ODI to support business intelligence and reporting needs.
- Customize and configure OBIA modules based on business requirements.
- Develop, optimize, and troubleshoot SQL queries, PL / SQL procedures, and views for data integration and reporting.
- Perform data mapping, data validation, and reconciliation between source systems and OBIA warehouse.
- Collaborate with functional teams to understand reporting needs and translate them into technical solutions.
- Monitor and improve ETL job performance, ensuring efficient data loads and accuracy.
- Support deployment activities, defect fixes, and enhancements in production environments.
- Prepare and maintain technical documentation, design specs, and ETL workflows.
Required Skills & Experience :
4+ years of experience in OBIA, ODI, and SQL development.Strong expertise in Oracle Data Integrator (ODI) including mappings, interfaces, packages, and scenarios.Hands-on experience with OBIA modules (Finance, HR, Procurement, or Supply Chain preferred).Solid SQL / PL-SQL skills for data extraction, transformation, and troubleshooting.Good understanding of data warehousing concepts, ETL design patterns, and performance tuning.Experience in production support and working in SLA-driven environments.Strong problem-solving and communication skills.Nice to Have :
Experience with Oracle BI Publisher (BIP) or OBIEE reporting.Knowledge of cloud migration (Oracle Cloud Analytics, OCI, or Azure / AWS GCP).Familiarity with Agile / Scrum methodologies.Perks & Benefits :
100% remote work flexibility.Exposure to enterprise-level data warehousing and BI projects.Opportunity to work with global stakeholders and cross-functional teams.Learning & upskilling opportunities in cloud analytics and advanced BI tools.(ref : hirist.tech)