Mansi Goyal

Data Engineer

India3 yrs 3 mos experience

Key Highlights

  • Awarded Role Model Award for exceptional leadership.
  • AWS Certified Developer Associate with hands-on AWS experience.
  • Expert in designing data pipelines using Data Mesh architecture.
Stackforce AI infers this person is a Data Engineering expert in SaaS and Healthcare industries.

Contact

Skills

Core Skills

Data EngineeringCloud ComputingProfessional MentoringCareer Counseling

Other Skills

SQLPythonData Build Tool (DBT)SnowflakeApache AirflowFivetran ETL ToolEltLookerAmazon Web Services (AWS)PySparkGoogle BigQueryData PipelinesMicrosoft ExcelAmazon S3Data Governance

About

A goal-oriented professional with 4 years of experience in the IT industry, specializing in Cloud Data Engineering and Data Analytics. ๐Ÿ“Proficient in tools like SQL, DBT, Python, Snowflake, ETL/ELT, Airflow, Data Modeling, Data Transformation, Data Warehousing, Data Visualization (Looker), AWS Services (Redshift, Glue, MWAA, Lambda), PySpark, Excel. ๐Ÿ“Expertise in designing and building data pipelines using the Data Mesh architecture, implementing efficient data ingestion, transformation, and loading across Medallion structures (pre-bronze, bronze, silver, gold) to enable informed decision-making and strategic insights. ๐Ÿ“Partnered with business stakeholders and PMs to translate requirements into technical specifications, DBT data models, execution workflows, ensuring scalable reporting solutions. ๐Ÿ”ง Tech Stack worked on: ๐ŸŒŸ Languages: Python, SQL, C/C++ ๐ŸŒŸ Data Engineering Tools: DBT, Snowflake, Airflow, Fivetran, ETL/ELT, PySpark, Looker, Data Pipelines, BigQuery, OLTP/OLAP, Atlan, Oracle, Excel, Linux, CICD ๐ŸŒŸ AWS Services: S3, Glue, Redshift, Airflow, Appflow, EC2, RDS (PostgreSQL), IAM, Secrets Manager ๐ŸŒŸ Databases: SQL Server, My SQL, Oracle DB, PostgreSql ๐ŸŒŸ Version Control: Git/GitHub ๐Ÿ“ˆ Achievements: โ€ข Felicitated with Role Model Award for exceptional leadership, character, and commitment to work. โ€ข AWS Certified Developer Associate and AWS Certified Cloud Practitioner with hands-on experience in AWS services and application development.

Experience

Topmate.io

Mentor

Jun 2025 โ€“ Present ยท 9 mos ยท Remote

  • ๐—ต๐˜๐˜๐—ฝ๐˜€://๐˜๐—ผ๐—ฝ๐—บ๐—ฎ๐˜๐—ฒ.๐—ถ๐—ผ/๐—บ๐—ฎ๐—ป๐˜€๐—ถ_๐—ด๐—ผ๐˜†๐—ฎ๐—น๐Ÿฌ๐Ÿณ
  • ๐Ÿ‘† ๐‚๐ฅ๐ข๐œ๐ค ๐ฅ๐ข๐ง๐ค ๐ญ๐จ ๐›๐จ๐จ๐ค 1:1 ๐ฌ๐ž๐ฌ๐ฌ๐ข๐จ๐ง ๐ฐ๐ข๐ญ๐ก ๐ฆ๐ž
  • ๐ˆ'๐ฆ ๐ง๐จ๐ฐ ๐ฉ๐š๐ซ๐ญ ๐จ๐Ÿ ๐“๐จ๐ฉ 1% ๐‚๐ฅ๐ฎ๐› ๐จ๐ง ๐“๐จ๐ฉ๐ฆ๐š๐ญ๐ž
  • Guiding individuals on Resume Building, Job Search Strategies, Securing Internships, Cracking Interviews, and Optimizing LinkedIn Profiles, Mock interviews to maximize opportunities.
  • Connect 1:1 with me for personalized guidance!
Professional MentoringCareer CounselingData EngineeringData Build Tool (DBT)SnowflakeAmazon Web Services (AWS)

Tide

Senior Data Engineer

Apr 2025 โ€“ Present ยท 11 mos ยท Delhi, India ยท Remote

  • Connecting SMEs with right funding options.
  • Architected and implemented scalable, automated pipelines for data extraction, transformation, and analysis within a Data Mesh framework, optimizing data flow and ensuring high availability and performance across the Marketing domain.
  • Proficient in data storytelling, transforming complex data insights into simple, easy-to-understand narratives and presentations for cross-functional teams.
SQLPythonData Build Tool (DBT)SnowflakeApache AirflowFivetran ETL Tool+17

Zs

Data Engineer

Sep 2024 โ€“ Mar 2025 ยท 6 mos ยท Gurugram, Haryana, India ยท Hybrid

  • Engineering data pipelines to support high-volume processing, leveraging MWAA, SQL, DBT,
  • Appflow tailored to client needs, optimizing business outcomes across multiple pharmaceutical
  • subdomains, including Sales, Customer, Marketing, Engagement etc.
  • Architected multi-layered DBT models leveraging ETL/ELT best practices, implementing snapshots
  • and incremental strategies (SCD1/SCD2), and collaborated with cross-functional teams to deliver
  • scalable data solutions supporting key business requirements.
  • Built a centralized data repository for a pharmaceutical client by ingesting multi-domain (Customer, Sales, Marketing, Engagement etc.) data from sources including Veeva CRM, IQVIA, and Salesforce, modelled the data to deliver analytics-ready datasets that enabled downstream reporting and insights generation.
  • Leveraged DBT materializations (incremental, materialized views, tables) and implemented snapshots and custom macros to design efficient load strategies including SCD1, SCD2, and truncate-load, optimizing data transformations, maintainability and model refresh performance.
  • Conducted data quality checks on datasets exceeding 20M+ records, collaborated with QE team to identify and resolved 150+ DQ issues, ensured readiness for production deployment and achieved 99.9% data accuracy.
  • Collaborated with cross functional teams to deliver the solutions as per the client requirements that optimize their business outputs.
SQLData Build Tool (DBT)Amazon Web Services (AWS)Amazon RedshiftAWS GlueApache Airflow+20

Gemini solutions pvt ltd

4 roles

Senior Software Engineer (Data Engineer)

Promoted

Apr 2024 โ€“ Aug 2024 ยท 4 mos ยท Panchkula, Haryana, India

  • Integrated enterprise data from diverse sources (SFTP, APIs, databases) into Oracle and Snowflake
  • via Python, Airflow, DBT, and AWS ETL pipelines, enabling scalable storage and unified access.
  • Designed and implemented a scalable data warehousing and transformation framework, optimizing Airflow pipelines, managing feature delivery and rollback strategies, and maintaining system reliability and documentation.
  • Led the modernization of legacy on-prem SybaseIQ database by orchestrating the migration of 120+ production tables (avg. 30GB each) to Snowflake using Airflow pipeline templates for seamless data transfer via AWS S3, reducing operational costs from several million to under $290K.
  • Designed robust and scalable batch data pipelines to ingest Equity/ Stocks/ Indexes/ Securities data from on-prem Sybase IQ into Snowflake via Amazon S3 as an intermediate storage layer, processing CSV, JSON, and Parquet formats, and optimizing data storage with date-based partitioning and columnar compression for efficient querying and cost-effective processing.
  • Orchestrated data pipelines in Airflow to perform historical and incremental data loads, implementing sharding for parallel processing of high-volume datasets, retry and failure handling, and building fact and dimension tables in Snowflake; leveraged zero-copy cloning and Time Travel for data recovery, and enforced robust data quality checks to ensure accuracy, reliability, and trusted reporting.
  • Implemented data governance protocols to ensure data quality and compliance, resulting in improved data accuracy and security measures.
  • Engineered a stats aggregation process to monitor DBTโ€™s Snowflake Warehouse utilization, automating monthly and quarterly reporting and eliminating 4+ hours of manual effort per report.
PythonSQLData Build Tool (DBT)SnowflakeAmazon Web Services (AWS)Data Modeling+15

Software Engineer L2 (Data Engineer)

Apr 2023 โ€“ Mar 2024 ยท 11 mos ยท Panchkula, Haryana, India

Software Engineer - L1 (Data Engineer)

Aug 2022 โ€“ Mar 2023 ยท 7 mos ยท Panchkula, Haryana, India

Technical Trainee

Feb 2022 โ€“ Aug 2022 ยท 6 mos ยท Panchkula, Haryana, India

Chaayos

Technology Intern

Jan 2022 โ€“ Jan 2022 ยท 0 mo ยท Remote

  • ๐“๐ž๐š๐ฆ ๐’๐ข๐ณ๐ž: ๐Ÿ”
  • Worked on Java based Menu Management Application.
  • Worked closely with team members to divide tasks, ensuring efficient project progress and timely completion.
  • Supported fellow interns by providing assistance, sharing knowledge, and offering feedback to enhance individual and team performance.

Oil and natural gas corporation ltd

Summer Intern

Jun 2021 โ€“ Jul 2021 ยท 1 mo ยท Remote

  • The '๐Ž๐ง๐ฅ๐ข๐ง๐ž ๐๐ฎ๐ข๐ณ ๐€๐ฉ๐ฉ๐ฅ๐ข๐œ๐š๐ญ๐ข๐จ๐ง' is designed to reduce manual effort and save time by automating the quiz process. The application allows the admin to organize quizzes subject-wise, and students can attempt the quizzes online. ๐“๐ž๐š๐ฆ ๐’๐ข๐ณ๐ž: ๐Ÿ“
  • ๐…๐ž๐š๐ญ๐ฎ๐ซ๐ž๐ฌ ๐š๐ซ๐ž:
  • Quiz Organization
  • Automatic Grading
  • Effective Examination
  • Question Management
  • User-Friendly Interface

Education

UIET Panjab University

B.E. โ€” Information Technology

Aug 2018 โ€“ Jun 2022

O.S.D.A.V. Public School, Kaithal

Class 12th โ€” Non Medical

Apr 2016 โ€“ Mar 2017

Stackforce found 100+ more professionals with Data Engineering & Cloud Computing

Explore similar profiles based on matching skills and experience