Ratnesh Singh

Ratnesh Singh

Data Engineer
India

نبذة عني

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…

الخبرة

Data Engineer

Accion Labs
Jun 2019 - حتى الآن · 7 سنوات

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.

المهارات

البيانات الضخمة مستودع البيانات هادوب (Hadoop) سكالا سبارك أباتشي هايف أباتشي بيغ خدمات أمازون ويب (AWS) كافكا نوسكيو إل ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) 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
الإبلاغ عن هذا الملف الشخصي؟