Summary
Overview
Work History
Education
Skills
Timeline
Generic

Prathyusha Thadakamalla

Ellicott City,MD

Summary

Information Technology professional with 8 years of comprehensive experience in ETL Data Warehouse Implementation/Development, Dashboards Design/Development. Proficient in utilizing tools such as Talend DI, SSIS, and Tableau to drive successful projects in Banking, Financial, and Retail domains. Expertise includes hands-on experience in the complete ETL process, data analysis, profiling, and data quality assessments. Skilled in managing Jobs, Plans, and schedules using TMC (Talend Management Console) and adept at working with API JSON data responses for hygiene data loading. Experienced in MongoDB data collection, SnowFlake database, and AWS services. Experience working in addressing Log4J Vulnerability issues and migrating to newer Talend versions. Strong problem-solving abilities in identifying and resolving ETL production root causes, coupled with proficiency in CI/CD processes using GitKraken, TeamCity, and Octopus. Demonstrated expertise in creating Talend mappings and dashboards with large data volumes from diverse sources. Proficient in SQL with a focus on tuning long-running queries in SQL Server. Agile practitioner with excellent communication and interpersonal skills, enabling effective collaboration with stakeholders at all levels.

Overview

9
9
years of professional experience

Work History

ETL Consultant

Pathward Financials (Meta Bank)
06.2023 - 02.2024
  • Led ETL development utilizing Talend DI and AWS data files as data sources.
  • Conducted data analysis and unit testing on Snowflake database.
  • Implemented CI/CD processes using GitKraken, TeamCity, and Octopus for efficient code deployment.
  • Managed job scheduling using Talend Management Console (TMC).
  • Proficient in Talend performance optimization and long-running job management.
  • Skilled at working independently and collaboratively in team environment.
  • Worked effectively in fast-paced environments.

Talend Developer

M&T Bank
11.2021 - 06.2023
  • Developed ETL processes using Talend to transfer data from heterogeneous sources.
  • Proficient in MongoDB data collections and JSON data loading.
  • Managed version control using GitLab and promoted Talend jobs across environments.
  • Provided production support and troubleshooting for Talend jobs and SQL Server databases.
  • Improved data processing efficiency by designing and developing Talend ETL jobs.
  • Collaborated with cross-functional teams to identify business requirements and translate them into technical specifications.
  • Established strong relationships with key stakeholders by effectively communicating technical concepts in understandable terms.

BI Developer

TD Ameritrade
03.2017 - 11.2021
  • Designed and implemented ETL processes using Talend for various projects.
  • Hands-on experience in AWS S3 and EC2 data loading to Redshift.
  • Proficient in Tableau dashboard design and development, including complex visualizations.
  • Collaborated with stakeholders to gather requirements and deliver actionable insights.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Enhanced data quality by implementing data validation and error handling in Talend.

SQL Server Developer

Walgreens
05.2015 - 02.2017
  • Developed SSIS packages for ETL workflows, ensuring data accuracy and efficiency.
  • Implemented error handling and performance tuning for SSIS packages.
  • Provided documentation and deployment support for SSIS packages.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Established strong relationships with key stakeholders by effectively communicating technical concepts in understandable terms.

Education

Bachelor's Degree -

JNTU University
05.2010

Skills

  • ETL Tools: Talend DI, SSIS
  • Data Visualization: Tableau
  • Databases: MongoDB, Snowflake, AWS Redshift, SQL Server, Netezza, Oracle, PostgreSQL
  • Programming Languages: SQL
  • CI/CD: GitKraken, TeamCity, Octopus
  • Agile Methodologies
  • Strong Communication and Interpersonal Skills

Timeline

ETL Consultant

Pathward Financials (Meta Bank)
06.2023 - 02.2024

Talend Developer

M&T Bank
11.2021 - 06.2023

BI Developer

TD Ameritrade
03.2017 - 11.2021

SQL Server Developer

Walgreens
05.2015 - 02.2017

Bachelor's Degree -

JNTU University
Prathyusha Thadakamalla