Saikumar K

Experience

1. Data Engineer

   Truist

   Mar 2024 — Present · Charlotte, NC, US

   Designed, developed, and optimized complex Teradata SQL queries, storedprocedures, and macros, significantly improving query execution performanceby 45% through advanced indexing strategies, partitioning techniques, andstatistics collection. Ensured high availability, scalability, and dataaccuracy across enterprise-wide applications.Developed and maintained high-performance ETL pipelines usingInformatica PowerCenter, Teradata BTEQ scripts, and AWS Glue,ensuring seamless data ingestion, transformation, and data integrationfrom multiple heterogeneous sources (Oracle, SQL Server, Cloud Storage,and Flat Files) into Teradata-based enterprise data warehouses.Implemented and fine-tuned Teradata utilities, including FastLoad,MultiLoad, FastExport, TPT, and BTEQ scripting, handling large-scaledata migrations, bulk data loads, and high-speed data extraction processes,reducing load times by 35% and optimizing system throughput.Automated job scheduling and workflow orchestration using Control-M andAutosys, streamlining ETL execution, dependency management, andfailure handling mechanisms. Reduced manual intervention by 50%,improving batch job success rates by 30% and ensuring on-time dataavailability for reporting and analytics.Designed and implemented advanced data models and schema designsusing Erwin Data Modeler, collaborating with data architects and businessanalysts to ensure optimized data structures that align with businessrequirements and reporting needs. Developed star and snowflake schemas,ensuring efficient data retrieval, minimized redundancy, and enhancedperformance for business intelligence solutions.

Education

• University of North Carolina at Charlotte

  Master of Science - MS