Uday Chettepu

Background

About Uday Chettepu

4+ Years of experience in ETL, Data warehousing, SQL, AWS, Snowflake, IICS & Informatica PowerCenter. •Developed ETL mappings that perform Extraction, Transformation and Load of source data into target using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Joiner, Expression, Normalizer and Update strategy to meet business logic in the mappings. •Having experience in Development, Implementation, Testing Support of Data Warehousing and Data Integration Solutions using IICS and Informatica PowerCenter. •Good Knowledge on Data warehousing and Business Intelligence Concepts. •Worked on complete Software Development Life Cycle from Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation and Post Implementation Support. •Implemented Type 1/2 slowly changing dimensions to maintain current information and history. •Strong skills in Data Analysis, Data Requirement and Data Mapping for ETL Process. •Having good knowledge in SQL, worked in relational databases like Oracle, Snowflake & PostgreSQL and Worked with different non-relational Databases such as Flat files, XML files, Mainframe Files. •Handled end-to-end ETL flow of Development & complete testing up to production by taking into consideration business cases, objectives, optimization and requirements. •Interacted with Business partners to identify/understand requirements & design specifications. •Identify ETL specifications based on business requirements and will ensure that all solutions and processes are aligned to architectural/requirement specifications and creating ETL MDD & WDD Documents for same. •Experience on UNIX commands and Shell Scripting. •Hands-on exposure with AWS and Snowflake technologies. •Experience on TWS Schedulers •Involved into source code review for the mappings created by my team members and assisted the other ETL developers in solving complex scenarios and coordinated with business owners. •Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills and ability to meet tight deadlines under high pressure. •Initially worked in RTB as Application owner for ETL Applications (ADAM,APS,EPDI,Asist & SSQ).Having support knowledge, worked on high priority tasks like P2,P3 & P4 and resolved within SLA. •Resolving production ETL failures. Root cause analysis of business-driven issues.