Redmond, Washington, United States
I’m a data professional with 11+ years of experience with first 6 years as a Teradata Mainframe ETL Developer and the last 5 years specializing as an AWS Data Engineer. I’ve worked across diverse environments, building scalable data pipelines, optimizing cloud data workflows, and enabling data-driven decisions. Core Skills & Tools: Databases: Teradata, Redshift, DynamoDB AWS Services: S3, Glue, Lambda, Redshift, DynamoDB, Step Functions ,Event Bridge , SNS Languages: Python (scripting), PySpark, SQL Schedulers: Autosys, CA7, Step Functions Tools: Endeavor, Viewpoint, BMC Remedy, Jira Data Modeling: ERD, Dimensional Modeling
Perform Data Engineering using Teradata , Informatica, Control M and Snowflake
Technically competent with extensive experience in handling large-scale and complex delivery assignments in various platforms & technologies - MAINFRAMES,TERADATA, SQL, PYTHON, UNIX,INFORMATICA TERADATA and its utilities such as BTEQ, FASTLOAD, MLOAD, TPUMP and FAST EXPORT,STORED PROCEDURES and tools such as AUTOSYS, PUTTY, QC, VIEWPOINT Extremely skilled in buidling efficient and optimized SQL queries to manipulate the data and buidling views/ creating files to provide data to the end users Extensive expertise in analysis, design, development,implementation,testing and support of DATAWAREHOUSE and DATA INTEGRATION solutions using INFORMATICA POWERCENTER. Extensive experience in Teradata Database management by creating Teradata Tables, performed Disaster Recovery exercises,added, space management and performance tuning activities including encryption of data Comprehensive experience in executing projects in global delivery model, thorough understanding of complete SDLC processes including Requirement Gathering, Architecture Design & Development, testing of software applications and integration, deployment, following Agile and waterfall methodology Solutions-oriented professional with excellent skills in collaborating with project teams, interfacing with clients and deploying technology to build successful solutions for Clients Proficient in managing widely divergent, simultaneously occurring projects within agreed cost/timelines, by using strong organizational skills, out-of-the-box thinking, and innovative problem-solving abilities
Designed and developed Data models, Data pipelines and Datamarts using Unix Shell script, Teradata by Analysis of the Business requirements, Functional requirements and Data requirements. • Tuning and Optimizing performance Data Warehouse application/processes in terms of indexing, partitioning, parallelism. • Extensively used various Performance tuning Techniques to improve the System performance (compression techniques).
Developed ETL pipelines, data marts and created fact and dimension tables and applied normalizations on the data schema for efficient results using Teradata, Unix, JCL • Designing HLD (High-Level Design) Document, and LLD (Low-Level Design Document) by analyzing the Business requirements, Functional requirements and Data requirements provided by the Onsite Team. • Involved in Unit Testing, System Integration Testing (SIT), and User Acceptance Testing (UAT) and Analyzed the test case results using Quality Control (QC).