Gunaraja Vadapoo

• Leading P&C Data team (60+) to design and implement end-to-end data integration solutions for USAA client
• Migrated legacy ETL workloads from Informatica to AWS Cloud using DBT and Snowflake
• Defined ETL governance standards, version control, and CI/CD automation for data pipelines.
• Collaborated with business and analytics teams to enable the cloud data integration using AWS, DBT and Snowflake
• Mentored junior Data engineers and conducted regular technical reviews and performance audits of ETL jobs.
• Responsible for any technical challenges/Technical deliverables of entire offshore team in P&C data USAA team

• Established clear documentation practices for data mappings, transformations, and integrations to maintain consistency across projects.
• Improved data integration processes by implementing efficient ETL strategies and tools.
• Developed custom scripts to automate routine data integration tasks, increasing productivity and reducing manual effort.
• Collaborated with cross-functional teams to define requirements and design effective data integration solutions.
• Streamlined data migration tasks for seamless system transitions and minimized downtime.

• Designed and managed enterprise-scale ETL workflows using Informatica PowerCenter and IBM DataStage for financial and Automobile clients.
• Developed and implemented data integration frameworks supporting data ingestion from flat files, and multiple databases into cloud data platforms.
• Led data migration projects to netezza, ensuring data consistency, lineage, and reconciliation.
• Improved data load performance by 35% through partitioning, parallelism, and optimized SQL transformations.
• Coordinated with global stakeholders for project delivery, risk management, and change control processes.
• Collaborated with cross-functional teams to define requirements and design effective data integration solutions.
• Mentored junior team members on advanced concepts in the field of Data Integration, fostering professional growth within the team context.

• Wrote and optimized in-application SQL statements.
• Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
• Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
• Verified performance and reliability of development database transformation solutions via extensive simulation testing.

• Translated technical concepts and information into terms parties could easily comprehend.
• Designed and implemented scalable applications for data extraction and analysis.
• Verified performance and reliability of development database transformation solutions via extensive simulation testing.
• Inspected equipment, assessed functionality, and optimized controls.

• Troubleshot issues related to performance or system errors, quickly resolving them to minimize business impact.
• Collaborated with cross-functional teams to define requirements and deliver high-quality solutions.
• Implemented robust error handling techniques, resulting in fewer data discrepancies during the ETL process.
• Documented technical specifications, enabling seamless knowledge transfer among team members.

· Understanding the requirement of the client

· Analysis, UTC (Unit Test Case) preparation

· Run the jobs and validate using the test cases

• Improved software efficiency by troubleshooting and resolving coding issues.
• Saved time and resources by identifying and fixing bugs before product deployment.
• Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.