Sai Kumar

About Sai Kumar

ETL / Data Integration Professional | 3.9 Years of Experience • 3.9 years of hands-on experience in designing and developing high-performance ETL solutions using Informatica Intelligent Cloud Services (IICS / IDMC). • Strong expertise in writing and optimizing complex SQL queries for data extraction, transformation, reconciliation, and validation across Oracle, SQL Server, and Snowflake databases. • Proven experience in migrating Informatica PowerCenter mappings to IICS, including resolving cloud compatibility challenges, performance bottlenecks, and optimization issues during modernization initiatives. • Extensive experience in implementing Slowly Changing Dimensions (SCD Type 1 & Type 2), incremental data loads, and CDC (Change Data Capture) frameworks for enterprise data warehouses. • Proficient in performance tuning and troubleshooting using Session Logs, Pushdown Optimization, Partitioning strategies, and SQL tuning techniques. • Hands-on experience with Pre-SQL and Post-SQL scripting, error handling, restartability, and control flow orchestration using Mapping Tasks and Taskflows in IDMC. • Strong command of core Informatica transformations including Expression, Lookup (Connected/Unconnected), Update Strategy, Aggregator, Joiner, Router, and Sequence Generator to build reliable ETL pipelines. • Adept at collaborating with business analysts, data architects, and QA teams to deliver accurate, timely, and scalable data integration solutions. • Passionate about data accuracy, automation, and scalable cloud solutions.

Experience

1. System Engineer

   Infosys

   Oct 2025 — Present · Hyderabad, IN

   Designed, developed, and optimized ETL solutions using Informatica Intelligent Cloud Services (IICS) • Created and implemented complex mappings and transformations to ensure high data quality, consistency, and integrity.• Optimized IICS mappings by applying Query Override techniques, enabling complex SQL joins and filters directly at the source, resulting in faster execution and reduced ETL processing time.•Deployed data pipelines enabling seamless, secure, and efficient data movement between systems.•Monitored, troubleshot, and resolved Task Flow issues, improving performance and minimizing downtime.•Performed data validation and quality checks using SQL to ensure data accuracy and completeness.•Collaborated with business analysts, stakeholders, to translate business requirements into scalable technical solutions.•Produced clear, concise technical documentation to streamline knowledge transfer and future enhancements.

Education

• Osmania University

  Bachelor's degree, Computer Science