Data Engineer with experience delivering production data solutions across cloud, ML, and enterprise ETL environments. Worked on anomaly detection systems, inference pipelines, large-scale ODI implementations, and Oracle cloud migrations. Comfortable working across distributed data processing patterns, modern data platforms, and traditional enterprise stacks.
Contact & Location
- Location: Kolkata, India
- LinkedIn: linkedin.com/in/indranil—paul
- GitHub: github.com/indranil-paul-git
Technical Skill Matrix
| Category | Competencies |
|---|---|
| Languages | Python, SQL, Groovy |
| Data Engineering | Oracle AIDP, PySpark, Apache Spark, OCI Data Flow, OCI Catalog, ODI (Groovy Automation & SNP tables) |
| Databases | Oracle, Postgres, Oracle ADW |
| Cloud & Storage | Oracle Cloud Infrastructure (OCI), OCI Object Storage |
| Data Sources | Fusion BICC, BIP, Exadata, OCI Streaming, Oracle GTM, Oracle CPQ, Fusion UCM |
| DevOps Tools | Docker, Git, Linux |
Professional Experience
Staff Consultant | Oracle
Sep 2024 - Present | Kolkata, India
- Engineered an anomaly detection pipeline for a North American steel manufacturer, analyzing industrial IoT production-line stream data in AIDP to identify equipment and process irregularities.
- Developed ML inference data pipelines in AIDP for a US-based B2B supplier, supporting dealer churn and poaching prediction by incorporating seasonality and geographical factors.
- Supported architecture and development of a cloud-based data lake for an insurance provider, leveraging ODI DI, Data Flow, and Catalog.
- Designed and built a cross-platform analytics code review desktop tool, consolidating metadata and artifacts from OAC, ODI, and OCI-DI.
Associate Consultant | Oracle
Aug 2022 - Aug 2024 | Bangalore, India
- Developed and maintained 1,200+ data pipelines in ODI 12c for a B2B supplier in the semiconductor industry, integrating Fusion BICC, GTM and CPQ sources. Automated pipeline generation using Groovy scripting and enhanced data lineage tracking via custom SNP table scripts.
- Supported ETL migration from OWB 11g → ODI 12c (on-prem) for an Indian Bank, assisting in pipeline redevelopment and testing.
- Contributed to cloud migration for a European logistics operator, transitioning Oracle 11g → Oracle 19c (OCI) and OWB 11g → OCI Marketplace ODI 12c, achieving a 20% reduction in data load times.
Education
- B.Tech (Computer Science and Engineering) Jul 2018 - Jul 2022 | Heritage Institute of Technology
Certifications
- Oracle Data Integrator 12c Certified Implementation Specialist
- Oracle Cloud Infrastructure 2024 Generative AI Certified Professional