Gayatri Sirisha Kamapantula
Summary
Results-oriented software professional with strong technical skills seeking a challenging position to contribute towards achieving corporate objectives with honesty and performance. Resourceful Talend Developer highly productive in coding, debugging, and project management. Specialize in data integration, ETL processes, and performance tuning to efficiently complete tasks. Possess strong problem-solving skills, adaptability, and teamwork abilities to excel in fast-paced environments.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Talend Developer
Monsoon Accessorize
02.2023 - Current
- Utilized Talend Studio for creating and deploying ETL jobs that extracted data from multiple sources; specifically Oracle databases, MySQL servers, and flat files.
- Designed complex mappings for data transformation from source to target systems with Talend components like tMap, tJoin, tAggregate.
- Implemented error handling techniques in Talend jobs by configuring components like tDie, tWarn and tJavaFlex.
- Tuned Talend jobs for improved performance through optimization of queries, parallelization of tasks.
- Resolved system issues related to data quality problems like duplicates, invalid values or missing fields.
SQL Developer
CityLit
05.2024 - 05.2024
- Created database components such as stored procedures, functions, and triggers for seamless application functionality.
- Utilized customer data analysis to pinpoint opportunities for enhancing the migration process.
- Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
- Provided technical assistance in the form of SQL coding advice to other team members.
PostgreSQL Developer
Natwest
04.2024 - 04.2024
- Efficiently converted Sybase ASE tables, store procedures, views and functions for use in PostgreSQL.
- Developed effective techniques for error handling and logging in PostgreSQL through the conversion of Sybase's RAISEERROR to PostgreSQL's EXCEPTION mechanism
- Ensured efficient management of dependencies on Sybase-specific functionalities through the implementation of workarounds in PostgreSQL.
- Collaborated closely with team members to achieve project objectives and meet deadlines.
Developer
EDB
01.2024 - 01.2024
- Ensured successful conversion of Oracle-based store procedures, views, functions, packages, and tables to PostgreSQL utilizing the EDB Migration Portal.
- Demonstrated proficiency in utilizing EDB Postgres tools for effective handling of schema conversion and complex queries.
- Resolved migration issues related to partitioning, indexing, and performance optimization in PostgreSQL, ensuring efficient database operations post-migration.
Data Engineer
Boyd Gaming
07.2023 - 10.2023
- Designed and implemented ETL pipelines utilizing DBT for transforming and loading SQL Server data into Snowflake.
- Developed and optimized SQL models in DBT for data transformation and reporting requirements.
- Ensured data integrity, accuracy, and consistency throughout the migration process by developing and executing validation scripts.
ETL Developer
Prolifics
07.2021 - 02.2023
- Designed and implemented scalable data pipelines using Python and Apache Nifi
- Nifi and SQL, enabling efficient extraction, transformation, and loading (ETL) of large datasets from multiple sources
- Collaborated with cross-functional teams to identify data requirements and develop data models, ensuring the availability of accurate and reliable data for analytics and reporting purposes
- Optimized data storage and retrieval processes by leveraging cloud-based technologies such as Amazon S3, resulting in significant cost savings and improved query performance
- Developed and implemented data quality checks that reduced errors in reports by 60%
Developer
Tribal
03.2022 - 07.2022
- Converted and migrated complex reports from SQL Server to Oracle databases to enhance reporting capabilities and ensure data integrity.
- Utilized SQL Server Reporting Services (SSRS) for developing, deploying, and maintaining reports.
- Collaborated with database administrators and business teams to optimize report performance and ensure seamless data migration.
- Implemented testing and validation processes to ensure report accuracy and compliance with business requirements post-migration.
Education
Bachelor of Technology - Electronics and Communication
Anil Neerukonda Institute of Technology and Sciences
Bheemunipatnam07.2021
Intermediate - MPC
Sri Chaitanya Educational Institutes
Visakhapatnam04.2017
10th - SSC
Sri Chaitanya Techno School
Visakhapatnam04.2015
Skills
- Apache Nifi
- Talend Open Studio
- DBT
- SSMS
- SSRS
- IBM Cognos
- MySQL
- SQL Server
- PostgreSQL
- Snowflake
- Oracle
- Strong Problem Solving
- Attention to Detail
- Time Management
- Problem Solving
- Communication Skills
- Interpersonal Skills
- Leadership
Certification
- Azure Data Engineer Associate - Microsoft
- Db2_Sales_Foundation - IBM
- Db2_Technical_Sales - IBM
- SQL Analyst Associate - Databricks
- Databricks Lakehouse Fundamentals - Databricks
Languages
- English
- Telugu
- Hindi
Timeline
SQL Developer
CityLit
05.2024 - 05.2024
PostgreSQL Developer
Natwest
04.2024 - 04.2024
Developer
EDB
01.2024 - 01.2024
Data Engineer
Boyd Gaming
07.2023 - 10.2023
Talend Developer
Monsoon Accessorize
02.2023 - Current
Developer
Tribal
03.2022 - 07.2022
ETL Developer
Prolifics
07.2021 - 02.2023
Bachelor of Technology - Electronics and Communication
Anil Neerukonda Institute of Technology and Sciences
Intermediate - MPC
Sri Chaitanya Educational Institutes
10th - SSC
Sri Chaitanya Techno School