Keerthi Reddy

Keerthi Reddy

Data Engineer
United States of America

نبذة عني

A detail-oriented and results-driven Data Engineer with 3+ years of experience in designing, implementing, and maintaining data pipelines and infrastructure. Analyze or transform stored data by writing Spark Jobs using P…

الخبرة

Data Engineer

Nvidia
Apr 2023 - حتى الآن · 3 سنوات 2 أشهر

• Developing Azure data factory pipelines by creating datasets, source and destination linked services to move the data from oracle database to
Azure Data Lake Store Raw Zone.
• Designing and implementing data pipelines to extract, transform, and load (ETL) data from various sources into Azure data services like Azure Data
Lake, Azure SQL Database, or Azure Synapse Analytics to manage 10TB+ of data, enabling in-depth analysis that led to a remarkable 10% increase
in customer retention.
• Creating Databricks notebooks using Python (PySpark) and Spark SQL for transforming the data that is stored in Azure Data Lake store Gen2 from
Raw to Stage and Curated zones.
• Working with various big data file formats such as Parquet, CSV and JSON in different scenarios of building data pipelines in Azure Data Factory
and Azure Synapse Pipelines.
• Implementing with Visual studio and Repos in Azure DevOps to do code commits and code migrations across dev, test and prod environments.
• Developing and implementing machine learning models for predictive analytics, recommendation systems, or anomaly detection tasks.
• Collaborated with cross-functional teams to identify and resolve data quality issues, leading to a significant decrease in data errors by 50% and
contributing to a 70% increase in stakeholder satisfaction.
• Utilizing Apache Spark SQL and data frame methods to execute data transformations and aggregations on difficult semi- structured data.
• Using Power BI as a reporting tool to connect with Synapse for generating daily reports.

Data Engineer

Nvidia, TX
Apr 2023 - حتى الآن · 3 سنوات 3 أشهر

Developing Azure data factory pipelines by creating datasets, source and destination linked services to move the data from oracle database to Azure Data Lake Store Raw Zone.
Designing and implementing data pipelines to extract, transform, and load (ETL) data from various sources into Azure data services like Azure Data Lake, Azure SQL Database, or Azure Synapse Analytics to manage 10TB+ of data, enabling in-depth analysis that led to a remarkable 10% increase in customer retention.
Creating Databricks notebooks using Python (PySpark) and Spark SQL for transforming the data that is stored in Azure Data Lake store Gen2 from Raw to Stage and Curated zones.
Working with various big data file formats such as Parquet, CSV and JSON in different scenarios of building data pipelines in Azure Data Factory and Azure Synapse Pipelines.
Implementing with Visual studio and Repos in Azure DevOps to do code commits and code migrations across dev, test and prod environments.
Developing and implementing machine learning models for predictive analytics, recommendation systems, or anomaly detection tasks.
Collaborated with cross-functional teams to identify and resolve data quality issues, leading to a significant decrease in data errors by 50% and contributing to a 70% increase in stakeholder satisfaction.
Utilizing Apache Spark SQL and data frame methods to execute data transformations and aggregations on difficult semi-structured data.
Using Power BI as a reporting tool to connect with Synapse for generating daily reports.

Data Engineer

Accenture Solutions Private Limited, India
Jun 2020 - Nov 2021 · 1 سنة 5 أشهر

Developed various functionalities for Data Ingestion framework using Python resulting in a 30% reduction in data processing time.
Created the Json configuration files for cleansing the data through generic Spark framework.
Designed and Developed ETL Processes in AWS Glue to migrate data from external sources like S3, and Parquet/Text Files into AWS Redshift.
Conceptualized and executed complex Spark SQL Jobs, achieving a 40% improvement in processing large-scale data sets for Data Marts.
Successfully implemented SCD2 logic using Spark for master reference data, enhancing historical data accuracy by 15%.
Good exposure in writing SQL queries and in data analysis and fixing data issues for various facts and dimensions for data warehouse and data marts for star schema and snowflake schema.
Experience in solving the performance issues in PySpark and created test case documents.
Used AWS Glue for transformations and AWS Lambda, SQS and SNS to automate the process & worked on AWS Data Pipeline to configure data loads from S3 to Redshift
Designing and implementing complex data pipelines using Apache Airflow, streamlining data processing, orchestrating workflows, and ensuring robust data quality and reliability across diverse data sources.
Utilized and worked on Source/Version control Tools using Github, validate the change sets code changes, Check-in/Out and versioning and developed CI/CD pipelines using Jenkins on AWS to create, test, and deploy the code to higher environment.
Assisted with the design and implementation of data governance and security policies and procedures, including data encryption and access controls.

Data Engineer

Zensar Technologies, India
Apr 2019 - May 2020 · 1 سنة 1 شهر

Experience in analysing ETL requirements and identify solution elements for the enhancement requests and change requests.
Built complex ETL/ELT pipelines for data processing in azure cloud using Azure Data Factory.
Prepared the Mapping from the Source Systems to the Target Reporting table with the required metrics.
Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs on Scala and Python.
Created stored procedures to load the data into fact and dimension tables in Azure SQL Data warehouse.
Created complex queries based on the business requirement using PySpark/SparkSQL in azure databricks.
Migration of on-premises data (SQL Server) to Azure Data Lake Store (ADLS) using Azure DataFactory (ADF).
Developed ETL workflows using Apache Spark and Python, resulting in a 30% reduction in data processing time and improved data accuracy.
Analyzed complex HiveQL queries to address the concerns regarding any error values/data mismatch between source and sink while validating the reports by users.

المهارات

البيانات الضخمة مستودع البيانات هادوب (Hadoop) سكالا سبارك أباتشي هايف أباتشي بيغ خدمات أمازون ويب (AWS) كافكا نوسكيو إل ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) Python Java SQL Hive Pig MapReduce HBase ETL Data Modeling Dimensional Design EC2 Azure GCP AWS Glue Azure Data Factory Microsoft Excel Power BI Tableau Seaborn SQL Server PostgreSQL MySQL Snowflake Git Jenkins Docker Kubernetes Apache Airflow Luigi Prefect Apache Kafka Amazon Kinesis PySpark Spark SQL Azure Synapse Analytics Azure Data Lake Azure Data Lake Store Azure SQL Database Azure Synapse Pipelines Azure DevOps AWS Lambda SQS SNS AWS Data Pipeline
الإبلاغ عن هذا الملف الشخصي؟