Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Mamta Singhal

Bengaluru

Summary

Experienced Data Engineer & Data Analyst with expertise in ETL development, data warehousing, and business intelligence. Skilled in AWS Redshift, Snowflake, Matillion, Looker, and SQL to build efficient data pipelines and deliver actionable insights. Proficient in data modeling, automation with Python, and cloud technologies (AWS, GCP). Strong background in data governance, campaign analytics (Marketo, Salesforce), and BI tools like Power BI and Tableau. Adept at collaborating with teams to drive data-driven decisions and optimize business processes.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Software /Senior Data Engineer

Streamline Business Solutions
Bangalore
09.2024 - Current
  • ETL Development & Data Integration:Designing and managing ETL pipelines using Matillion, ensuring efficient data extraction, transformation, and loading (ETL) into AWS Redshift.
    Automating Matillion job deployment using MatillionPy, improving workflow efficiency and minimizing manual intervention.
  • Data Warehousing & Query Optimization:Managing AWS Redshift (PostgreSQL) databases, optimizing queries and schema design for performance tuning and scalability.
    Implementing data modeling best practices to enhance data retrieval efficiency across multiple schemas and environments.
  • Looker (LookML) Development & Data Visualization:Building and maintaining LookML models, creating optimized explores, dashboards, and reports for stakeholders.
    Enhancing Looker dashboards to support business intelligence, enabling data-driven decision-making.
  • Data Governance & Quality Management:Ensuring data integrity, consistency, and security by monitoring ETL processes and enforcing data governance policies.
    Performing data validation, anomaly detection, and reconciliation to maintain high data quality across different environments.
  • Cloud Infrastructure & Automation:Managing data migration and replication across Redshift instances (dev, test, UAT, production) while ensuring compliance with regional data laws.
    Writing and managing Flyway migrations, committing changes to Git, and triggering Jenkins jobs for Redshift schema updates.
  • Collaboration & Stakeholder Engagement:Working closely with cross-functional teams (engineering, analytics, business intelligence, and product teams) to improve data workflows and insights.
    Assisting in performance monitoring, troubleshooting ETL failures, and optimizing data processing for better reliability

Data Engineer

Marrina Decisions
Bangalore
06.2023 - 07.2024
  • Was working on clients (Google & Indeed)
  • Developed and maintained ETL pipelines using Matillion for data extraction, transformation, and loading (ETL) into AWS Redshift.
  • Managed data modeling and transformations in Redshift (PostgreSQL), optimizing queries and schema design for improved performance.
  • Automated deployment of Matillion jobs using MatillionPy, ensuring seamless CI/CD integration for ETL processes.
  • Built and maintained LookML models in Looker, enabling efficient reporting and analytics for marketing campaign insights.
  • Ensured data governance and quality management across Marketo and Salesforce (SFDC), handling field requests, lead routing, and workflow automation.
  • Designed and optimized complex SQL queries for data extraction, reporting, and troubleshooting across multiple sources.
  • Developed weekly, monthly, and quarterly reports in Looker and other BI tools to provide insights into marketing campaigns and business performance.
  • Conducted statistical analysis, hypothesis testing, time series analysis, and regression modeling to support data-driven decision-making.
  • Collaborated with cross-functional teams to align data integration, reporting, and campaign tracking with business objectives.
  • Managed data pipeline monitoring and troubleshooting to ensure smooth data flow and minimal downtime.

Data Analyst - Research & Development

Netcom Learning
Bangalore
07.2022 - 06.2023
  • Developed and implemented data collection systems and ETL processes, optimizing data pipelines for efficiency and accuracy.
  • Worked with Snowflake to design data models, optimize queries, and improve data warehousing solutions.
  • Integrated and managed customer engagement data within MessageGears, ensuring seamless campaign execution and reporting.
  • Acquired data from primary and secondary sources, maintaining databases and data systems for business intelligence and analytics.
  • Used statistical methods and data mining techniques to identify trends, patterns, and actionable insights from large datasets.
  • Conducted data cleaning and validation, reviewing system reports and performance indicators to resolve inconsistencies.
  • Built automated reports and dashboards in BI tools, training end users for enhanced data-driven decision-making.
  • Collaborated with management and stakeholders to prioritize data initiatives and enhance business intelligence strategies.
  • Provided technical expertise in data storage structures, data transformation, and data analytics, ensuring optimal performance.

Data Analyst - Team Lead

Silicon Media Technology
Bangalore
03.2019 - 07.2022
  • Led data-driven marketing campaigns, leveraging marketing automation platforms to optimize customer segmentation, engagement, and conversion rates.
  • Developed custom Python scripts and automation tools to streamline data extraction, transformation, and analysis, reducing manual efforts and improving efficiency.
  • Conducted advanced analytics on customer behavior, product performance, and market trends, providing strategic insights to improve marketing ROI.
  • Designed and implemented a company-wide reporting system, defining key performance metrics (KPIs) and building standardized reports for cross-functional teams.
  • Built interactive Power BI dashboards for real-time monitoring of marketing performance, sales trends, and operational KPIs.
  • Conducted predictive analytics and trend forecasting to support business strategy and decision-making.
  • Presented data insights, business observations, and strategic recommendations to C-level executives and stakeholders through detailed PowerPoint presentations and reports.
  • Led a data governance initiative, ensuring data accuracy, consistency, and compliance across marketing and business intelligence platforms.
  • Collaborated with cross-functional teams (marketing, sales, product, and engineering) to optimize data flows, reporting, and campaign performance tracking.
  • Provided mentorship and training to junior analysts, fostering a data-driven culture within the organization.

Education

MCA - Computer Applications

DBIT
Dehradun
06-2018

BCA - Computer Applications

Alpine Groups
Meerut
06-2016

Skills

    Data Engineering & ETL
  • Matillion (ETL Pipelines, MatillionPy)
  • Flyway (Database Migrations)
  • Apache Airflow
  • Jenkins (CI/CD for Data Pipelines)
    • Data Warehousing & Databases
  • AWS Redshift (PostgreSQL)
  • Snowflake
  • SQL (Advanced Queries, Window Functions, Performance Optimization)
  • Database Programming & Schema Design
    • Business Intelligence & Data Visualization
  • Looker (LookML, Explores, Dashboards, Reports)
  • Power BI, Tableau
  • Advanced Excel
    • Programming & Scripting
  • Python (Pandas, NumPy, Automation Scripts)
  • SQL (Joins, CTEs, Query Optimization)
  • Shell Scripting
  • HTML, CSS, JavaScript
    • Cloud & DevOps
  • AWS (Redshift, S3, EC2, Lambda)
  • GCP (Google Cloud Platform)

Certification

  • Udemy : Data Science Bootcamp 2024
  • Matillion ETL Certification (Building a Data_Warehouse using Matillion)
  • Looker & LookML Certification
  • AWS Certification (Cloud)
  • Microsoft Azure Fundamentals (Data Concepts)

Accomplishments

  • Employee of the Month – Recognized for exceptional performance and leadership in driving data pipeline optimization and automation.
  • Best Data Project – Awarded for successfully leading the design and deployment of an end-to-end ETL pipeline in Matillion, improving data processing efficiency by 30%.

Timeline

Software /Senior Data Engineer

Streamline Business Solutions
09.2024 - Current

Data Engineer

Marrina Decisions
06.2023 - 07.2024

Data Analyst - Research & Development

Netcom Learning
07.2022 - 06.2023

Data Analyst - Team Lead

Silicon Media Technology
03.2019 - 07.2022

MCA - Computer Applications

DBIT

BCA - Computer Applications

Alpine Groups

Similar Profiles

CREATE PROFILE
Mamta Singhal