ODI Developer - ETL & Data Warehousing Expert

–

AISWARYA AM

O D I D E V E L O P E R

PROFILE SUMMARY

Oracle Data Integrator (ODI) Developer with 3 years of end-to-end data warehouse and ETL implementation experience. Strong background in ODI 12c, Oracle SQL/PLSQL, data integration, error handling, parameterization, and performance tuning. Hands-on with ODI Master/Work repositories, KMs, Load Plans, Agents, and Topology. Adept at translating business requirements into technical specifications, and building reliable, scalable data pipelines. WORK EXPERIENCE

3I-Infotech 2023- PRESENT

ODI Developer – US-RUN-BI Teachers ADW Project

Developed and optimized complex ODI mappings for large-scale data warehousing applications.

Configured ODI Topology, created Master and Work Repositories, and deployed Agents for workflow automation.

Designed and implemented parameterized ETL components, reusable KMs, and error logging systems.

Performed SQL performance tuning using Explain Plan and Trace Files.

Delivered data quality frameworks, auditing, and reconciliation logic within ODI.

Created Load Plans, scheduled jobs, and maintained execution monitoring in ODI Operator.

Supported ODI object migration across environments using Smart Export/Import.

3I-Infotech

Associate Consultant

Built ETL control tables and load workflows to manage large datasets in Oracle Autonomous Data Warehouse (ADW). Integrated data from multiple sources into Oracle using ODI and SQL Loader. Developed custom SQL Scripts and exception-handling routines. Collaborated with business users and analysts to transform highlevel requirements into ETL design specifications.

Conducted unit testing, error handling, data validation, and reconciliation reporting.

CERTIFICATIONS

Oracle Data Integrator (ODI) 12c Developer Course

Contact this candidate