Ritesh Chidrewar Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

Leading the design and implementation of a robust data migration framework from AWS Redshift to Snowflake.Responsibilities:• Understand and analyze the existing queries in PLSQL.• Used Dynamic Stored Procedure for continuous data ingestion from the S3 bucket.• Created Mass Ingestion in IICS to load the data from Salesforce.• Created Stored Procedures to move the data from the raw layer to the confirm and reporting layer.• Created External Functions in Snowflake to invoke the API’S in AWS.• Worked on both Single and Multi-Cluster warehouses and used both Auto-Scale and Maximized modes in multi-cluster warehouses.• Used all types of tables in Snowflake like temporary, transient, permanent, and external tables.• Used cache mechanism in Snowflake to speed up the query performance.• Worked on the Zero-copy cloning feature in Snowflake.• Tested the models developed in Snowflake and then migrated to quality and then to production.• Worked on Time Travel feature for Permanent tables.Key Technologies used: AWS S3, Redshift, IICS, Python, Snowflake., Snowpark

Pune

Responsibilities:• Design and Development of ETL/ELT E2E batch pipeline framework leveraging Databricks and Azure services (ADF, ADLS).• Developed spark-based US HealthCare CMS reporting logic to generate monthly/weekly reports.• Orchestrated entire data pipelines with Azure ADF and Databricks JOBS scheduler/orchestrators based on client needs.• Translate business propositions into quantitative queries and collect/clean necessary data.• Developed batch jobs to manage data coming from different/multiple sources.• Develop automation utilities to ease the process of framework deployment to onshore/onsite(client) environments.• Provide architectural and infrastructure direction.• Strong working knowledge of developing systems with enterprise databases, including Apache Spark and modern cloud services/tools (Azure/GCP).• Led a team of two full-time employees.

Maharashtra, India

Responsibilities:• Designing and developing of Cloud migration framework of data ingestion pipelines.• Design, development, and maintenance of Near-Real-Time ETL pipelines which process 1B+ daily transactions for leading payments giant.• Implemented batch data ingestion pipelines from S3 to GCS/GCP.• Developed automation and data collection tasks/jobs using Apache Spark, Shell Scripting, Java Proficiency, and knowledge of best practices with the Hadoop (YARN, HDFS, MapReduce) Implement and configure big data technologies as well as tune processes for performance at scale. • Developed and managed the E2E tableau monitoring dashboard for efficient operations.• Developed utilities to perform compaction on prod Hive tables using Apache Spark/HQL Maintain existing ETL workflows, data management, and data query components. • Work in an agile environment and continuously improve the agile processes.

Pune Area, India

Cloud Operations /cloud computingResponsibilities:• Experience with Private Cloud Infrastructure (BXP – BNY Mellon Xtreme Platform) in Infrastructure as a Service (IaaS).• Exposed to Virtualization (VMware, Hypervisor).• Assist in the development and implementation of standardized infrastructure practices and procedures.• Assist in troubleshooting network and storage issues and make recommendations for growth.• Development of tools and processes for managing Linux and VMware-based servers.• Work closely with Cloud Operations to produce resilient, secure, high-performance services.• Perform systems monitoring to provide proactive alerting and historical performance records.

Bachelor'S Degree, Electronics And Telecommunication Engineering

Pursuing Bachelors Degree

Pg Diploma, Big Data Analytics, A

Completed Big Data Analytics Post graduate diploma course at CDAC ACTS Pune with A grade

High School, Science

Higher Secondary Certificate(HSC)