Umesh Karennavar

Data Engineer with 2+ years of experience designing and optimizing large-scale ETL pipelines using Informatica PowerCenter, SQL, and AWS. Proven track record of improving pipeline performance by 35% and ensuring 80% data integrity across Oracle and Redshift environments. Experienced in Power BI dashboarding, Unix shell scripting, and cross-functional collaboration with business stakeholders. Seeking to leverage cloud data engineering expertise in a high-growth product or technology company.

Data Engineer (Informatica Developer) - Tata Consultancy Services (TCS) - Client: Tata Play

(2024-05 - 2026-07)

• ETL Development & Optimization: Architected and engineered complex ETL workflows using Informatica PowerCenter to extract data from Oracle source systems, transform it per business rules, and load into Sybase and central database environments. Migrated data from SQL Server and flat files, processing over 5TB of data daily.
• Performance Tuning: Enhanced the performance of critical ETL jobs by 35% and reduced nightly batch windows by 3 hours through strategic optimization of mappings, session configurations, and underlying SQL code.
• Database & Scripting Expertise: Engineered high-performance SQL procedures, functions, and packages for complex business logic. Developed and maintained Unix shell scripts to automate file processing, error handling, job scheduling, and email alerts providing critical session status and row count metrics.
• Production Support & Data Integrity: Monitored and troubleshot ETL workflows in production; identified and resolved incidents ensuring 99.9% data integrity and availability for business reporting.
• Stakeholder Collaboration & Leadership: Partnered with business analysts to translate complex requirements into technical specifications. Led code reviews for a team of 3 junior developers, enforcing best practices and mentoring on advanced ETL techniques.
• Data Visualization & Governance: Supported end-to-end analytics by standardizing, validating, and transforming data within Power BI and creating dashboards, ensuring seamless flow from ETL pipelines to business intelligence.
• Data Quality & Testing: Performed unit testing and data validation to ensure accuracy and integrity of loads, resolving bottlenecks in close collaboration with senior engineers.

Bachelor of Engineering - Mechanical Engineering - Basaveshwara Engineering College (2019-07 - 2023-07)