Dileep J

15+ years of experience designing and developing ETL/ELT solutions across Retail, Banking, and Insurance domains. Deep expertise in Oracle Data Integrator (ODI 11g & 12c) and IBM Infosphere DataStage 9.1, with hands-on experience in installation, migration, and version upgrades. Proven track record of end-to-end ownership — from requirements gathering and design through development, performance tuning, testing, and production deployment.

Experienced in leading small-to-medium teams, onshore-offshore coordination, and mentoring junior developers. Strong background in data warehousing concepts including dimensional modelling, star/snowflake schemas, SCDs, and query optimization. Skilled in SQL, PL/SQL, shell scripting, and cloud integrations including Azure and GCP.

Recognized with multiple Best Employee and Extra Mile awards for delivering critical integrations and resolving high-impact production issues.

ODI Developer / Support - Capgemini Technology Services India Ltd - India

(2022-12)

Responsible for data integration across 450+ IKEA retail stores, managing cloud integrations with Azure and GCP, and handling store configurations, pricing, and article search issues.

• Developed multiple ODI 12c integrations fetching data from Oracle and flat files, loading into GCS Bucket, PostgreSQL, and Oracle targets.
• Built parameterized, reusable ODI integrations using Variables, Mappings, Procedures, Packages, Scenarios, and Load Plans.
• Performed performance tuning on ODI jobs and set up robust alerting mechanisms for production failures.
• Provided on-call production support, including monitoring, debugging, and incident resolution.
• Deployed code to higher environments and authored testing support documentation.

ETL/ELT Developer - Capgemini Technology Services India Ltd - India

(2018-08 - 2022-11)

Designed and developed end-to-end ODI solutions enabling integration of multiple systems with IKEA's CIF platform.

• Automated manual processes using ODI, improving operational efficiency.
• Shared best practices for building scalable, secure, and highly available enterprise data integration applications.
• Performed performance tuning and contributed to both development and production support activities.
• Redeveloped SOA flow in Oracle DB consuming data from Oracle AQ and publishing to GCP REST API — recognized with Extra Mile award.

ODI & Data Migration Specialist - Capgemini Technology Services India Ltd - India

(2014-11 - 2018-07)

Designed and developed end-to-end ODI migration solutions to migrate legacy loan data to a new platform without data loss.

• Migrated 600+ tables from MS SQL Server to Oracle Database using ODI Topologies, Mappings, Packages, Scenarios, and Load Plans.
• Managed source data changes and provided client recommendations for optimal data fit in the new system.

Consultant - Clover Infotech Pvt Ltd - India

(2012-12 - 2014-11)

Worked for Reliance Life Insurance project

IBM DataStage Developer - IBM India Pvt. Ltd. (via Future Focus IT) - India

(2011-06 - 2014-11)

Developed DataStage jobs to pull data from Mainframe, SQL Server, and Oracle into DB2, supporting portal implementation.

• Authored technical specification and job design documents; performed performance tuning on existing jobs.
• Automated backup of DataStage components and jobs; coordinated client UAT for change requests.
• Awarded Best Employee for resolving a critical VOC file corruption issue.

Master of Computer Applications - Computer Applications - Acharya Nagarjuna University (2008)