Ratnesh Singh

Ratnesh Singh

Data Engineer
India

About Me

Experience in Query optimization, Improving Performance and maintain data integrity. Over 4.5 Years' experience as data engineer, Design solutions of database, ETL and Data warehousing. Optimizing the ETL (AWS Glue) perf…

Experience

Data Engineer

Accion Labs
Jun 2019 - Present · 7 years

Designed and executed ETL pipelines in alignment with Data Lakehouse principles, leveraging AWS S3, AWS Glue, Apache HUDI, and AWS Kinesis. • Achieved a remarkable 10X improvement in Spark Jobs performance, resulting in significant reductions in both running time and operational costs. • Successfully managed daily data loads of 12GB, overseeing 10 million daily transactions. • Developed a user-friendly API and Dashboard complete with lineage diagrams to facilitate monitoring of Glue Pipelines and real-time tracking of table data freshness. • Seamlessly integrated diverse data sources, including MongoDB, MySQL, Kinesis, Static files, and Glue Catalog, for streamlined data processing. • Employed Apache HUDI to enhance the Data Lake Platform and harnessed Redshift Spectrum for efficient data querying and reporting. • Conducted code refactoring to optimize system performance and maintainability. • Deployed Data Lakehouse Schema Change management.

Skills

Big Data Data Repository Hadoop Scala Spark Apache Hive Apache Pig Amazon Web Services (AWS) Kafka NoSQL Redshift S3 SQL Server MySQL Redshift Spectrum Snowflake SynapseDB Python PySpark AWS Glue Tableau GitLab CI/CD AWS Lambda Azure Functions Azure Databricks AWS Kinesis Hudi SQL Stored Procedures Database Design Data Modeling Normalization Performance Monitoring Performance Tuning Troubleshooting Documentation ETL ELT Data Warehousing Data Lake Data Lakehouse Data Pipeline BI Architecture Apache Hudi Pandas Power BI Azure Synapse Azure DevOps DAX Oracle CI/CD
Report this Profile?