Deepthirekha Pusapati
Snowflake Developer
Hyderabad
Summary
A highly skilled Data Engineer and ETL Developer with around 12+years of experience in IT, specializing in data analytics and integration. Proven ability to design, develop, and optimize data warehouse solutions and robust ETL processes across on-premise and cloud environments, particularly Snowflake. Expertise in SQL query optimization, SSIS, Qlik Compose, and DevOps. Demonstrated success in improving operational efficiency within banking and manufacturing sectors. Seeking a challenging role to leverage expertise and drive impactful data solutions.
Overview
14
14
years of professional experience
3
3
Languages
Work History
Snowflake & ETL Developer/ Dataengineer
TCS-ABB
03.2022 - Current
- Developed and implemented ETL pipelines using SSIS and Qlik Compose to integrate data from various sources into a Snowflake data warehouse, collaborating with business analysts and technical architects to meet requirements.
- Optimized Snowflake views for performance, resulting in a 20% improvement in query execution time.
- Validated data accuracy in Power BI reports, ensuring data integrity for business decision-making.
- Developed and executed unit test cases for ETL processes, achieving 100% test coverage and ensuring high-quality deliverables.
- Implemented CI/CD pipelines using Azure DevOps, increasing deployment efficiency by 40%.
- Utilized Agile methodologies and Azure DevOps for project planning and tracking, ensuring on-time and within-budget project delivery.
Data Quality Analyst
TCS-Bank Of America
01.2016 - 12.2021
- Monitored SQL Server and SSIS jobs, performed root cause analysis of failures, and collaborated with support teams to resolve issues, minimizing downtime and ensuring data availability.
- Developed ad-hoc SQL reports in Excel to address specific user requirements, providing timely and accurate data insights.
- Conducted QA reviews of Excel and Tableau reports, ensuring data quality and accuracy for reporting and analysis.
- Performed code reviews and documented best practices for code optimization, contributing to improved code maintainability and performance.
SQL /SSIS Developer
TCS-Bank of America
12.2011 - 12.2014
- Extracted data from diverse sources (SQL Server, Oracle, CSV, Excel, Text files) using SSIS, enabling data integration for downstream processes.
- Created comprehensive documentation for all ETL jobs and SSIS packages, establishing a company standard for data management practices.
- Monitored and supported scheduled ETL jobs (full, incremental, daily) for batch processing, ensuring timely and accurate data loading.
- Performed daily validation of dashboards and resolved database and ETL process issues, ensuring data accuracy and availability for business users.
Education
Mtech - Biotechnology
12.2011
- Graduation with Distinction
- GPA: 83
Btech - Biotechnology
04.2009
GPA: 78
Skills
Structured query language SQL
Accomplishments
- Streamlined the process of taking the requests for code review through mails and as a team created a sharepoint site to track the requests which reduced the manual intervention.
- Worked in close collaboration with team in migration of code from one architecture to other, being a fast learner helped move the changes within the SLA
- Developed and maintained strong relationships with clients, ensuring high levels of customer satisfaction and fostering long-term partnerships.
Extra Curricular
Reading books Playing chess and solving puzzle games
Awards
Service & Commitment Award (September 2017): Recognized for outstanding service and dedication., Special Initiative Award (July 2018): Awarded for exceeding performance expectations and demonstrating initiative., On the Spot Award (December 2018): Recognized for excellence in performance., Special Achievement Award (September 2020): Awarded for outstanding achievements and contributions., Learning Achievement Award (February 2021): Recognized for achieving significant learning milestones.
Timeline
Snowflake & ETL Developer/ Dataengineer - TCS-ABB
03.2022 - Current
Data Quality Analyst - TCS-Bank Of America
01.2016 - 12.2021
SQL /SSIS Developer - TCS-Bank of America
12.2011 - 12.2014
Gitam, Andhra University - Btech, Biotechnology
JNTUH, JNTU - Mtech, Biotechnology