Umesh Chandra

Results-driven Senior ETL Developer with 4+ years of experience in Oracle Data Integrator (ODI 12c), SQL, and PL/SQL. Adept at designing and implementing high-performance ETL pipelines, data warehousing solutions, and automated data workflows for large-scale enterprise environments. Demonstrated expertise in data quality management, CDC implementation, SCD Type 1 & Type 2 design, XML and flat file integrations, and performance tuning within Agile delivery settings.

Recognized with the Beyond Excellence Award at TCS for outstanding project delivery. Seeking to contribute in product-based organizations and global MNCs where data engineering and ETL development drive business impact.

Senior Analyst – ODI Developer - Accenture

(2025-10)

Domain: Products

• Architect and implement scalable, high-performance ETL solutions using ODI 12c to support enterprise data warehousing and analytics platforms.
• Design and develop end-to-end data pipelines integrating XML-based feeds and flat file sources (delimited, fixed-width) into target Oracle data warehouse schemas.
• Implement Change Data Capture (CDC) mechanisms within ODI to enable near-real-time incremental data loads, reducing full-load dependency and improving pipeline efficiency.
• Develop and maintain SCD Type 1 (overwrite) and SCD Type 2 (historical tracking) mappings to accurately manage slowly changing dimension data across enterprise datasets.
• Lead data integration strategies across cross-functional teams, ensuring high data availability, consistency, and quality across business units.
• Optimize end-to-end data pipelines, significantly reducing processing latency and improving throughput for critical business reports.
• Collaborate with architects and business stakeholders to define data flow requirements and deliver technical design specifications aligned with product roadmaps.

ODI Developer - Tata Consultancy Services (TCS)

(2022-03 - 2025-10)

Domain: Insurance

• Developed and maintained robust ODI ETL workflows — including mappings, packages, load plans, and scenarios — enhancing data integration efficiency across insurance data platforms.
• Designed and implemented XML data loading pipelines, parsing structured XML feeds from upstream insurance systems into relational Oracle tables using ODI's built-in XML technology.
• Built flat file ingestion workflows handling CSV, pipe-delimited, and fixed-width formats from multiple source systems, ensuring data completeness and format validation.
• Implemented CDC-based incremental load strategies using ODI Journalizing to capture only changed records, reducing batch processing time and improving overall pipeline performance.
• Designed SCD Type 1 and SCD Type 2 mappings for dimension tables in the insurance data warehouse, enabling accurate historical reporting on policy, claims, and customer data.
• Engineered complex PL/SQL procedures, triggers, and functions to automate sophisticated data transformations and business rule enforcement across insurance modules.
• Processed large-scale datasets from heterogeneous sources (Oracle, Flat Files, XML) while maintaining 100% data integrity and accuracy.
• Conducted deep-dive SQL performance tuning, applying indexing strategies and query optimization to reduce execution times across high-volume ETL jobs.
• Collaborated with business analysts, QA teams, and project managers to deliver multiple development releases on schedule within Agile sprint cycles.

Bachelor of Technology - B.Tech - Jawaharlal Nehru Technological University (JNTU-A) (2021-06)