Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Sahitya Bayoju

Sahitya Bayoju

Dallas

Summary

About 7+ years of professional experience in IT working with Legacy Database systems, which includes work experience in Big data technologies as well.

Vast experience of working in the area of data management including data analysis, gap analysis and data mapping.

Develop generic SQL procedures and complex T-SQL statements to achieve the reports generation.

Hands on experience for Data Integrity process and Data Modelling concepts.

Sr. Data Engineer with a proven track record at Amazon, I excel in optimizing ETL workflows and ensuring data integrity, showcasing my strong work ethic and database development skills. significantly enhancing project efficiency. My approach focuses on impactful achievements, blending technical prowess with collaborative success.

Overview

6
6
years of professional experience

Work History

Sr. Data Engineer

Amazon
06.2023 - Current
  • Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
  • Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
  • Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
  • Used Windows Azure SQL reporting services to create report with tables, charts and maps.
  • Defined Extract-transfer-load (ETL) and Extract-load-transfer (ELT) processes for data lake.
  • Worked on debugging and identifying the unexpected real-time issues in production server SSIP packaged.

Data Engineer

Accenture
08.2021 - 05.2023
  • Supported efficient data migration processes by designing and implementing robust ETL procedures, ensuring minimal downtime during transitions.
  • Experience in building and architecting multiple data pipelines, end to end ETL and ELT process for Data ingestion and transformation in GCP.
  • Devised simple and complex SQL scripts to check and validate Dataflow in various applications.
  • Performed Data Analysis, Data Migration, Data Cleansing, Data Transformation, Integration, Data Import and Data Export through Python.
  • Developed and Deployed data pipeline in cloud such as AWS and GCP.
  • Performed Data Engineering functions data extract, transformation, loading and integration in support of enterprise data infrastructures-data warehouse operational data stores and master data management.
  • Responsible for data services and data movement infrastructure good experience with ELT concepts building ELT solutions and Data modeling.
  • Architected several DAGs (Architected Acyclic Graphs) for automating ELT pipelines.
  • Hands on experience on Architecting the ELT transforming layers and writing Spark jobs to do the processing.
  • Enhanced data processing speed by optimizing ETL pipelines for efficient data ingestion and transformation.
  • Delivered high-quality documentation detailing technical specifications, user guides, troubleshooting steps, and best practices for utilizing developed solutions efficiently.
  • Provided reliable and secure access to sensitive information by enforcing strict authorization policies in line with company guidelines.
  • Achieved faster query response times through the implementation of appropriate indexing strategies in databases.
  • experience in fact dimensional modeling (Star schema, Snowflake schema) transactional modeling and SCD(slowly changing dimension).
  • Devised PL/SQL stored procedures, Functions and Triggers, Views and Packages. Made use of Indexing, Aggregation and Materialized views optimize query performance.
  • Develop near real time data pipeline using spark.
  • Implementing Apache Airflow authoring, Scheduling and monitoring Data Pipelines.
  • Analyzed the system for new enhancements/functionalities and perform Impact analysis of the application for implementing ELT changes.
  • Experience implementing back-end pipeline, with Pandas Numpy
  • Collaborate with team members and stakeholders in design and development of data environment.
  • Preparing associated documentation for specification, requirements and testing.





Oracle PL/SQL Server Developer

Wipro Technologies
04.2019 - 07.2021
  • Worked on Project estimates, resourcing, status updates, project plan updates, and team coordination.
  • To find out bugs in application and rectify them.
  • To prepare documents as per the changes in the code.
  • Involved in SQL activities.
  • Created stored procedure with cursors to generate the reports.
  • Created Indexes, Constrains and triggers, synonyms in different schema.
  • Worked on Bulk collection and PL/SQL for getting optimal performance.
  • Coordinating with onsite, attending regular hand-off and transition meetings for new projects.
  • Generating various reports on requirement using PL/SQL, ProC and SQL*plus SPOOL Command.
  • Involved in Unit testing, Debugging and Integration testing of the application.
  • Peer review of code before turning over to production.
  • Managing Monthly release for all applications development and bug fixing.
  • Extensive knowledge and working of Bulk collect and Bulk binding for data retrieval.
  • Created scripts to load the data into database tables from the flat files using SQL* Loader.
  • Involved in loading files to tables using NZLOAD and extensively used NZSQL.

Education

Bachelor of Science - Computer Science

Gayathri Degree Collage
Karimnagar
05-2016

Skills

  • Git version control
  • Scripting languages
  • Strong work ethic
  • Programming
  • Application development
  • Data pipeline control
  • Database development
  • Data pipeline design
  • Data warehousing expertise
  • Customer service

Languages

English
Professional Working
Hindi
Professional Working
Telugu
Native or Bilingual

Timeline

Sr. Data Engineer

Amazon
06.2023 - Current

Data Engineer

Accenture
08.2021 - 05.2023

Oracle PL/SQL Server Developer

Wipro Technologies
04.2019 - 07.2021

Bachelor of Science - Computer Science

Gayathri Degree Collage

Similar Profiles

CREATE PROFILE
Sahitya Bayoju