Vamsi Kavadana

Informatica ETL Developer & Administrator with 2+ years of experience in enterprise data integration using IICS and PowerCenter. Skilled in designing high-performance mappings, taskflows, and workflows across cloud and on-premises environments, with strong exposure to data warehousing, ETL optimization, and production support. Experienced in Informatica administration — repository/integration services, security agent management, deployments, security, and environment monitoring across Dev/QA/Prod.

Proficient in SQL, Unix/Linux with additional experience in SAP BO administration.

Informatica ETL Developer & Administrator at Tata Consultancy Services (TCS) (2023-11 – Present)

ETL Development (IICS & PowerCenter) and Informatica Administration (PowerCenter & IICS)

• Designed and developed end-to-end ETL solutions using IICS and PowerCenter 9.x/10.x, building reusable mappings, taskflows, and workflows to integrate source systems with cloud and relational targets — incorporating SCD Type 1 and Type 2 logic to maintain accurate current-state and historical dimension data.
• Translated business requirements into technical ETL specifications and source-to-target mapping documents
• Applied data transformation, cleansing, validation and reconciliation logic, and executed unit, integration and post-release testing to ensure data accuracy and solution quality.
• Optimized ETL performance through partitioning, cache tuning, reducing batch run times and enabling scalable enterprise data warehouse processing.
• Deployed and migrated objects across DEV, QA and Production using deployment groups and XML import/export, ensuring configuration consistency and validated source-to-target reconciliation after every release.
• Provided 24x7 production and on-call support for critical ETL batches, performing root cause analysis on failures and delivering permanent fixes to prevent recurrence.
• Administered 30+ PowerCenter domains and repositories across Dev/QA/Prod, managing user provisioning, roles, and permissions.
• Installed, configured, and managed Secure Agents, and built 100+ relational and application connections across PowerCenter and IICS — enabling secure, reliable access to Oracle, Snowflake, and Redshift with 99%+ connection uptime
• Performed version upgrades, backup and recovery, and DR drills, and supported outage handling and application retirement activities — coordinating with infrastructure, database, and application teams to ensure smooth execution with zero business disruption.
• Monitored and troubleshot scheduled jobs, identifying root causes and resolving 50+ production incidents to minimize recurring failures and downtime.
• Closed 1000+ incidents and change records in ServiceNow/Service Manager under ITIL governance, maintaining 95%+ SLA compliance.
• Managed Unix/Linux servers hosting PowerCenter services and IICS Secure Agents, handling directory structures, mount points, file permissions and log rotation, and coordinating with infrastructure teams on disk space and OS patching.
• Wrote shell scripts to automate recurring administration and ETL support tasks, including file handling and archiving, log and disk-space cleanup, service health checks, and pre/post-session command execution.
• Diagnosed and resolved Informatica service and Secure Agent startup, shutdown and connectivity issues from the Linux command line, monitoring log files and disk utilization to keep ETL operations uninterrupted.
• Configured and maintained ODBC/JDBC drivers on Unix/Linux servers to support Informatica connectivity to heterogeneous data sources.
• Monitored SAP BusinessObjects services, managed user access and role assignments, resolved business-reported reporting issues, and coordinated with the BO team on escalations and environment health maintenance.

Bachelor of Technology in B. Tech – Rajiv Gandhi University of Knowledge Technologies (RGUKT) (2019 – 2023)