Deepthi Yelamanchi

Sr Snowflake Developer (2020 -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 feature in Snowflake to efficiently create clone objects for Production data, facilitating code modifications and testing while ensuring data integrity.
• Parsed and transformed complex nested JSON structures using Snowflake’s native functions such as LATERAL FLATTEN, and ARRAY to extract meaningful insights and load structured data into dimensional models.
• 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 (2017-2020)

• Successfully managed end-to-end ETL migration projects, including planning, execution, and post-migration support, ensuring 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 (2015-2017)

• 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.

ETL Tester

• 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.