Vasu Vallabhuni

Senior Technical Lead and Data Engineering Architect with 14+ years of expertise in Data Warehousing, Business Intelligence, ETL Architecture, Informatica Administration, and Cloud Data Pipelines. Proven mastery across Informatica PowerCenter (8/9/10), Informatica Intelligent Cloud Services (IICS CDI/CAI), AWS Cloud Data Stack, Snowflake, Teradata, Oracle 21c, and Enterprise Job Orchestration (Autosys, Control-M). Demonstrated track record of leading large-scale legacy-to-cloud migrations (e.g., 1,300+ DataStage to Informatica/Snowflake jobs migrated), managing 1,500+ production ETL workflows with 99.9% uptime, and administering complex multi-node enterprise environments.

Adept at performance tuning (partitioning, pushdown optimization, SQL hints, explain plan), 24/7 high-availability production support, and aligning technical delivery with BRD/TRD requirements across Financial, Banking, Insurance, and Healthcare sectors.

Manager - Projects - Cognizant Technology Solutions

(2025-04)

• Developed and implemented complex Informatica PowerCenter mappings and workflows supporting Nationwide Insurance data integration requirements.
• Managed the end-to-end SDLC, including requirements analysis, solution design, development, testing, and implementation for the P&C – Auto Line of Business.
• Leveraged GitHub Copilot and AI agents to enhance existing functionality, automate development activities, and improve engineering productivity.
• Designed and optimized dimensional data warehouse tables, performed performance tuning of complex SQL queries, and resolved production defects to ensure data quality and system stability.
• Implemented and validated end-to-end data flows across Guidewire PolicyCenter → WMB → IA → ETL, including downstream validation for PAL, FNOL, and PL Analytics.

Senior Technical Lead - HCL Technologies

(2021-03 - 2025-03)

• Led client deliverables and offshore/onsite teams for large-scale enterprise data platform modernizations.
• Architected end-to-end cloud ETL integrations using Informatica IICS (CDI/CAI) and AWS Redshift/Snowflake.
• Managed team sprint planning, architectural reviews, client stakeholder alignments, and production deployments.

Technology Analyst - Infosys Ltd

(2015-04 - 2021-03)

• Delivered critical data warehousing and migration initiatives for Fortune 500 financial and reinsurance clients.
• Successfully spearheaded 1,300+ ETL job migrations from IBM DataStage to Informatica PowerCenter & AWS.
• Automated deployment JIL scripts, Shell scripts, and Autosys job creation for seamless CI/CD releases.

Programmer Analyst - Cognizant Technology Solutions

(2010-11 - 2015-03)

• Developed complex Informatica PowerCenter mappings and workflows for major global banking institutions.
• Designed dimensional data warehouse tables and executed performance tuning on complex SQL queries.
• Managed data privacy compliance monitoring via Informatica DPM and conducted POCs on AWS EC2 & S3.

Bachelor of Technology - Computer Science & Engineering - Lakkireddy Bali Reddy Engineering College (JNTU Kakinada) (2006 - 2010)