Sriharibabu Tumpati

Data Engineer @Truist

Irving, TX, US

Designed and developed a reusable AWS Glue ELT framework to extract and ingest large datasets from diverse sources—including relational databases, mainframes, and flat files—into Snowflake. Implemented both full snapshot and incremental data loading strategies in Glue to Snowflake, improving data accuracy by 98% and enabling real-time reporting for 50+ business users. Executed the data extraction process using Glue jobs with raw file ingestion, followed by standardization and tokenization to ensure high data quality and compliance with governance standards. Designed and implemented Talend Data Mappers to transform complex JSON documents into structured tabular formats, enabling seamless ingestion into the Snowflake Silver layer. Developed Talend Data Mapper jobs to parse XML files using XSD schemas, converting them into CSV format for accurate validation and ingestion. Hands-on experience in tuning Talend jobs for optimized performance and minimal runtime. Performed advanced data transformations using Talend and SQL to integrate multi-source data into centralized repositories supporting enterprise analytics and BI reporting. Processed large volumes of structured data using Talend and SQL, significantly improving the analytical capabilities of business teams. Hands-on experience in tuning AWS Glue jobs and optimizing Spark configurations for high performance and minimal runtime. Developed structured data interfaces via Glue Catalog for downstream analytics, reporting, and business intelligence platforms.