Rajdeep Suryawanshi

About Rajdeep Suryawanshi

Senior Engineer with over 6+ years of hands-on experience in designing, developing, and managing ETL pipelines and real-time Data Warehouse (DWH) applications, with expertise in AWS Glue, Databricks, Hadoop, HDFS, HBase, MapReduce, Hive, Oozie, Jenkins, Airflow, Snowflake Cloud, and Bitbucket. • Proficient in leveraging Apache Spark, specifically using PySpark and Spark SQL, to streamline data processing, ensure efficient testing, and manage data from diverse, complex sources. • In-depth understanding of Data Warehousing principles, with extensive experience in the Banking, Financial Services, and Retail sectors. • Comprehensive expertise across all stages of SDLC and STLC, encompassing test planning, defect management, requirement analysis, test design, execution, and status reporting, with a strong focus on quality assurance and risk mitigation. • Specialized in Data Integration and System Integration, complemented by advanced skills in defect analysis, problem-solving, and providing actionable insights to development teams. • Hands-on experience with ETL tools, including Informatica PowerCenter, SSIS, and Informatica DVO, ensuring optimal ETL processes across varied systems. • Extensive knowledge of the AWS ecosystem, particularly in the context of Data Lake services such as AWS Glue, S3, Athena, Lambda, CloudWatch, and RedShift, with a proven track record in architecting scalable and efficient cloud solutions. • Advanced proficiency in SQL, with specialization in complex operations such as Pivot & Unpivot and XML Tag manipulation for data transformation and reporting. • Expertise in performing rigorous data validation, including extract validation, count checks, null checks, schema and datatype validation, and end-to-end ETL testing to ensure data integrity and accuracy. • Demonstrated excellence in crafting and executing comprehensive test plans, test scripts, and defect management processes, utilizing a range of testing tools to track, monitor, and resolve defects. • Significant experience working within Agile/Scrum methodologies, collaborating effectively within cross-functional teams to deliver high-quality software solutions. • Skilled in developing detailed Test Plans, Strategies, Test Cases, Test Matrices, Requirement Traceability, Test Reports, and comprehensive documentation for both manual and automated testing processes. • Delivered proactive support to developers through thorough defect analysis and lifecycle management, ensuring the timely resolution of issues and preventing reoccurrence.

Experience

1. Senior Engineer

   Altimetrik

   Jul 2023 — Present · Pune, IN

   Pune, Maharashtra, India

Education

• Sinhgad College of Engineering

  Bachelor of Engineering - BE

  2015 — 2018