Deepthi Yelamanchi
Hyderabad
Summary
Data Engineering Consultant with extensive Snowflake expertise and 12 years of experience in Data Warehousing, ETL, SQL, and Cloud Technologies. Skilled in designing, implementing, and optimizing scalable data solutions while ensuring data integrity and governance. Adept at translating business requirements into efficient technical solutions and driving strategic data management. Proficient in ETL development, performance tuning, and cloud data engineering. A strong collaborator with excellent communication skills and a proven ability to mentor teams and drive business outcomes.
Overview
13
13
years of professional experience
Work History
Snowflake Developer
United Health Group
Hyderabad
01.2021 - Current
- Engineered and deployed customized snowflake data warehouses, aligning with specific business requirements
- Executed ETL processes leveraging Snowflake's native features to seamlessly transfer data from source systems into the Snowflake data warehouse
- Proficient in designing and implementing manual and automated data ingestion pipelines using Snowpipe
- Proficient in bulk loading data from external and internal stages to Snowflake using the COPY command, seamlessly integrating data from Azure and optimizing data workflows
- Developed and maintained database objects, including views and stored procedures, to optimize data access and enhance system performance
- Created sophisticated SQL queries within the Snowflake data warehouse to facilitate business analysis and reporting
- Designed and implemented Snowflake procedures and tasks to automate critical processes, enhancing efficiency and reliability
- Utilized zero-copy cloning, time-travel, streams, tasks features in Snowflake to efficiently create clone objects for Production data, facilitating code modifications and testing while ensuring data integrity
- Conducted comprehensive data validations by querying information_schema in Snowflake, ensuring data accuracy, consistency, and compliance with business requirements
- Conducted in-depth analysis to identify and resolve critical issues promptly
- Collaborated with cross-functional teams to ensure seamless operations
ETL Migration Projects
United Health Group
Hyderabad
02.2019 - 12.2020
- Successfully managed end-to-end ETL migration projects, including planning, execution, and post-migration support, ensuring a seamless transition of data processes from legacy systems to modern platforms.
- Collaborated with stakeholders to define migration requirements, including data mapping, transformation logic, and target system configurations.
- Developed and executed migration plans, including data extraction, transformation, and loading strategies, to ensure data consistency and integrity.
- Implemented data validation and reconciliation procedures to verify the accuracy and completeness of migrated data.
- Conducted performance testing to validate the scalability and efficiency of the new ETL processes, post-migration.
- Provided training and support to end users and stakeholders to facilitate the adoption of the new data integration platform.
ETL Developer
United Health Group
Hyderabad
07.2015 - 02.2018
- Designed and implemented ETL solutions using IBM InfoSphere DataStage, ensuring seamless data extraction, transformation, and loading processes
- Worked closely with stakeholders, including business analysts and data architects, to gather requirements, design ETL solutions, and ensure alignment with business objectives
- Developed and managed automated schedules for DataStage jobs, ensuring timely data updates for reporting and analytics
- Worked with cross-functional teams to gather ETL requirements, design solutions, and deliver projects aligned with business needs
- Developed comprehensive documentation for DataStage ETL processes, including job designs, mappings, and transformations, facilitating ongoing maintenance and knowledge transfer
Software Engineer
Tech Mahindra
Hyderabad
08.2012 - 06.2015
- Created comprehensive test plans and test cases for ETL processes, ensuring data accuracy, completeness, and integrity across multiple systems
- Executed ETL testing using the DataStage ETL tool to verify the successful extraction, transformation, and loading of data, adhering to business requirements
- Performed rigorous data validation and verification tests to detect discrepancies and anomalies in ETL workflows, enhancing data quality and reliability
- Worked closely with ETL developers and business analysts to understand requirements and validate data mappings and transformations
- Extracted and analyzed data from source and target systems for testing purposes using SQL queries, ensuring data correctness and consistency
- Validated the impact of changes on existing ETL processes and data quality through regression testing, maintaining system stability
- Identified and reported defects using HP ALM, and collaborated with development teams to resolve issues promptly, ensuring minimal disruption to project timelines
- Documented test results, issues, and resolutions comprehensively for reference and audit purposes, facilitating transparency and traceability
- Engaged in Agile ceremonies such as sprint planning, daily stand-ups, and retrospectives, aligning project tasks with timelines and deliverables
Education
Bachelor of Technology - Information Technology
Jawaharlal Nehru Technological University Hyderabad
06.2011
Skills
- Snowflake
- SnowSql
- Azure Storage
- AWS S3
- SQL
- Oracle
- PL/SQL
- Data Stage
- GIT Hub
- Rally
- Python (Basic)
Timeline
Snowflake Developer
United Health Group
01.2021 - Current
ETL Migration Projects
United Health Group
02.2019 - 12.2020
ETL Developer
United Health Group
07.2015 - 02.2018
Software Engineer
Tech Mahindra
08.2012 - 06.2015
Bachelor of Technology - Information Technology
Jawaharlal Nehru Technological University Hyderabad
Similar Profiles
Erica LawsonErica Lawson
Customer Service Representative at United Health GroupCustomer Service Representative at United Health Group
Nipun AggarwalNipun Aggarwal
Senior Software Engineer at United Health GroupSenior Software Engineer at United Health Group
Ieisha Washington-BradfordIeisha Washington-Bradford
Clinical Care Navigator at United Health GroupClinical Care Navigator at United Health Group