OCI Data Integration Developer

This role is for one of the Weekday's clients Salary range: Rs 500000 - Rs 1600000 (ie INR 5-16 LPA) Min Experience: 6 years Location: Remote (India), Bengaluru, Karnataka, NCR, Pune, Mumbai JobType: full-time We are seeking an experienced OCI Data Integration Developer to support a next-generation finance transformation initiative by designing and implementing scalable, automated data pipelines within Oracle Cloud Infrastructure.
This role focuses on enabling robust Finance and Order-to-Cash (O2C) data integration, ensuring accurate, reliable, and timely data delivery for reporting, analytics, and operational decision-making.
You will work in a cloud-native environment, leveraging OCI services to build ETL/ELT workflows, unify data from ERP and legacy systems, and create high-performance data models aligned with finance business needs.
As a key contributor, you will collaborate closely with finance stakeholders, architects, and analysts while ensuring governance, security, and performance best practices across the data ecosystem.
Key Responsibilities Design, develop, and manage end-to-end data integration pipelines using OCI Data Integration for ingestion, transformation, and delivery of Finance and O2C data.
Build and orchestrate ETL and ELT workflows leveraging OCI services such as Object Storage, Data Flow (Spark), Data Catalog, Autonomous Data Warehouse (ADW), and Data Lakehouse.
Integrate data from Oracle Cloud ERP, legacy platforms, and third-party systems into unified, analytics-ready data models.
Implement data transformations, validation checks, reconciliation logic, and quality controls aligned with finance requirements.
Optimize SQL and PL/SQL queries for performance tuning within ADW and Oracle databases.
Monitor, troubleshoot, and enhance pipeline reliability, scalability, and performance.
Develop reusable integration templates, mappings, and workflow orchestration scripts.
Apply security best practices including encryption, masking, and access control within OCI environments.
Maintain comprehensive documentation covering data flows, configurations, and operational procedures.
Collaborate with cross-functional stakeholders to ensure accurate, governed, and timely data delivery.
What Makes You a Great Fit 6–8 years of experience in ETL/ELT and data integration development, including at least 3 years of hands-on OCI experience.
Strong expertise in OCI Data Integration, including pipeline design, mappings, and orchestration.
Proficiency in SQL and PL/SQL for complex data transformations and performance optimization.
Experience with OCI services such as Object Storage, Data Flow (Spark), Data Catalog, and Autonomous Data Warehouse.
Solid understanding of Finance and Order-to-Cash processes and related data structures.
Knowledge of data modeling, lineage, governance, and data quality frameworks.
Familiarity with CI/CD pipelines and DevOps-based deployment practices.
Experience integrating Oracle Cloud ERP with OCI data services (preferred).
Exposure to Python or PySpark for advanced transformations (nice to have).
Strong analytical thinking, problem-solving abilities, and collaborative communication skills.