Thirupathi Gurnatham

Talend Developer with 6+ years of expertise in ETL processes and data warehousing solutions. Proficient in utilizing Talend and various database systems, including Oracle, SQL Server, Redshift, and Snowflake. Skilled in optimizing ETL mappings and developing reusable frameworks to enhance data extraction, transformation, and loading efficiency. Experienced in integrating diverse source systems, including APIs, Salesforce, Snowflake, XML, and JSON, to meet complex business requirements.

Developed and maintained ETL processes for extracting data from various sources, transforming it according to business requirements, and loading it into the data lake, collaborated with business stakeholders to gather requirements and translate business needs into technical specifications for ETL workflows, implemented data quality checks and error handling mechanisms to ensure data accuracy and integrity throughout the ETL process, conducted performance tuning and troubleshooting of ETL jobs to address bottlenecks and enhance overall system performance, designed and implemented data integration workflows using Talend Open Studio, optimized ETL workflows using the Talend tool to improve performance, reliability, and scalability, resulting in a 75% reduction in processing time, integrated Talend jobs with scheduling tools (Autosys) to automate data processing workflows, conducted performance tuning and optimization of Talend jobs to improve data processing throughput and reduce latency, worked with cross-functional teams including business analysts, data architects, and QA testers to understand data requirements and ensure accurate and efficient data integration, developed, maintained, and optimized complex SQL queries to support business applications, and hands-on experience in SQL, Amazon S3, Glue, Redshift, and Athena, with basic knowledge of Linux

Used ETL tools in the areas of analysis, design, development, and administration with a focus on Talend data integration in real time with different databases, proficient in planning, scheduling, and implementing ETL application changes while ensuring no impact to users, including data migration across different OS versions, built Talend 6.x and Talend 7.x environments for high availability for DEV, QA, and production environments including installation, upgrade, migration, user management, backup/restore, code promotion, and OS profiling in Windows instances, dimensional tables and fact tables, and a strong understanding of star schema modeling, snowflake modeling, excellent interpersonal and strong analytical skills, documentation, and problem-solving skills with a customer service-oriented attitude, a very good team player, self-motivated, dedicated in all work environments, possesses organizational development, team facilitation, group process, leadership development, and the ability to analyze situations and offer cost-effective, innovative solutions