Vinayak Sutar

About Vinayak Sutar

Over 5 years of experience in the BI domain as a Data Engineer, with a proven track record in architecture solutioning using Agile methodologies. Expertise in both Solution Architecture and DataStage Development, delivering high-quality BI solutions across multiple domains.Successfully executed 10+ projects and project sprints, involving a range of activities such as requirement gathering, planning, design, development, and testing. Proficient in providing end-to-end solutions for BI data management and analysis.Specialized in Snowflake and Python scripting for efficient data management and analytics. Expert in leveraging Snowflake for data warehousing and analytics, and utilizing Python to automate data processes and transformations.Experienced in working with AWS services such as S3, AppFlow, MWAA, AWS Glue, enabling scalable and efficient data processing solutions. Skilled in data storage and management through AWS S3, facilitating large data volume handling and seamless data access.Expertise in Hadoop, Spark, PySpark, Sqoop, HDFS, and Hive for large-scale data processing and analytics. Proficient in applying dbt (Data Build Tool) for effective data transformation and modeling in data warehouse environments.Developed and optimized ETL DataStage jobs for sourcing data from various databases and file types such as DB2, Oracle, SQL Server, and files shared via SFTP (.txt.csv.xlsx). Utilized tools like database connectors, sequential stages, unstructured stages, execute commands, and scripting languages to build robust ETL pipelines.Involved in all project phases, from requirement gathering and planning to design, development, testing, UAT, deployment, and post-production support. Ensured successful delivery and transition of projects across multiple stages.Prepared and maintained documentation such as Business Requirement Documents (BRD), Risk Assessment (RA), Design Documents, Technical Architecture Documents, Standard Operating Procedures (SOPs), and Unit Test Cases for seamless communication and collaboration among stakeholders.Proficient in Linux scripting, having written scripts to read files from password-protected and passwordless SFTP locations. Successfully implemented file archival and zipping processes for data management, improving efficiency and data security.Developed and executed scripts for column count validation to ensure accurate file retrieval with the correct structure. This contributed to data integrity and error prevention during data processing.

Experience

1. Manager - Analytics Platform

   Piramal Pharma Ltd

   Sep 2024 — Present · Mumbai, IN

Education

• Late Bhausaheb Hiray S S Trusts Institute of Computer Application Next to New English School Bandra (East) Mumbai 400 051

  Master's of Computer Application, Computer Application

  2017 — 2020