Summary
Overview
Work History
Education
Skills
Websites
Certification
TOOLS
Hobbies and Interests
Timeline
Generic

Smit Nema

Narsinghpur,Madhya Pradesh

Summary

Results-driven ETL and SQL Developer with over 6+ years of experience specializing in high-performance data pipelines and transformation logic across Investment Banking, Pharma, Retail, and AdTech industries. Expertise in on-prem, big data, and cloud ETL workflows, complex SQL development, and analytics for clients such as Morgan Stanley, ZS Associates, Takeda, Walmart, and Samsung. Skilled in data modeling, ingestion, cleansing, archival, and optimization for actionable insights. Recognized for being hands-on, detail-oriented, and reliable in fast-paced production and support settings.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Software Engineer II

Epsilon
06.2022 - Current
  • Developed scalable ETL pipelines using Advanced SQL, Spark and PostgreSQL to support large-scale adtech/martech data operations.
  • Designed ingestion workflows for omnichannel campaign data from S3, FTP/SFTP (ORC, Parquet, CSV) into Greenplum-based EDW using XML-driven transformations.
  • Collaborated with global teams to deliver EDW solutions enabling audience segmentation, media attribution, and campaign performance analytics.
  • Led end-to-end ETL delivery—from requirement gathering and solution design to UAT and deployment—across multi-country rollouts.
  • Provided L1–L3 production support across mission-critical pipelines, ensuring data accuracy, SLA compliance, and platform stability.
  • Automated data workflows using Apache Airflow, powering insights through Hive, Presto, Spark SQL, and AWS EMR for marketing optimization.

Business Technology Solution Associate

ZS Associates
01.2022 - 06.2022
    • Partnered with internal teams and client stakeholders to deliver CRM and sales analytics solutions supporting field force effectiveness, territory planning, and performance tracking.
    • Led requirement gathering, solution design, testing, and deployment of multi-country commercial data processes tailored to pharmaceutical clients.
    • Worked on end-to-end implementation of data workflows integrating with ZS's ZAIDYAN platform , enabling unified CRM reporting, call activity insights, and incentive compensation support.
    • Managed ETL processes to standardize and harmonize HCP/HCO-level sales data across global affiliates, aligning with commercial operations strategy.
    • Supported UAT cycles, ensured CRM data accuracy, and collaborated with global teams to streamline analytics delivery across therapeutic areas.

Database and ETL Developer

TATA Consultancy Services
06.2019 - 12.2021
  • Delivered enterprise-grade data mart and data warehouse solutions in Morgan Stanley's TEDRA–ITARA division, powering high-visibility reporting for institutional securities.
  • Designed and built scalable ETL pipelines supporting trade analytics, front-office reporting, and strategic business insights.
  • Developed and maintained workflows using Informatica PowerCenter 9.5.4 / 10.2.0 , with automation via Autosys R11 for 24×7 SLA-bound data processing.
  • Translated complex business requirements into efficient PL/SQL logic and contributed across sprint cycles, UAT, and production rollouts.
  • Collaborated with global teams in Technology and Operations to drive timely, accurate data delivery across multi-region reporting platforms.
  • Reduced processing time for ETL tasks through the implementation of parallel execution strategies.

Education

B.E. - Electronics and communication

University Institute of Technology
Bhopal, Madhya Pradesh
05.2019

Skills

  • ETL & Workflow Tools: Informatica PowerCenter 102, Apache Airflow, Autosys, Azkaban, Custom ETL tools (Spark)
  • SQL & Data Processing: Advanced SQL, T-SQL, PL/SQL, Window Functions, CTEs, Joins, Aggregations, Performance Tuning, Query Optimization
  • Databases: PostgreSQL, Greenplum, IBM DB2, Sybase ASE 16, Redshift
  • Data Warehousing: EDW, Data Marts, Data Modeling, Data Profiling, Cleansing, Transformation, DWH Reporting
  • Data Analysis: Exploratory Data Analysis (EDA), KPI Dashboards, Root Cause Analysis (RCA), Trend Analysis, Ad-hoc Reporting
  • Visualization Tools: Tableau Basic, Excel (Pivot, VLOOKUP)
  • Cloud & Big Data: AWS CLI over S3, Hive, HDFS, Hadoop, Spark SQL
  • File & Data Ops: CSV/ORC/Parquet handling, awk, Unix CLI, q (KDB), FTP/SFTP integration
  • Scripting & Automation: Shell, Python, Perl; Automation Testing over UAT/QA; SDLC Type 3
  • DevOps & Agile: CI/CD (Jenkins), Git, Jira, Confluence, Agile/Scrum
  • Production Support: L1/L2/L3 Support, Incident Triage, Monitoring, On-Call Ops

Certification

  • Certification in ETL testing, Udemy
  • Certification Sharma Coaching Academy- [2013]
  • Certification in JAVA ESE , Sharma Coaching Academy- [2014]

TOOLS

  • Informatica Power Center, Azkaban
  • Workload balancer like Autosys R11,Apache Airflow, Oozie
  • Dbartisan,Aquadata Studio,SQL J Workbench, DbViz ,Visual Code Studio
  • Atlassian Bit Bucket ,Confluence, Jenkins
  • Atlassian Jira Board's , MS Excel, MS PowerPoint
  • Perforce p4, GIT
  • Pgadmin, Pager Duty
  • Reporting tool like Boxi R11, Tableau, Service Desk
  • Putty, ITerm2, Terminal

Hobbies and Interests

Cooking, Reading Newspaper, Playing Badminton

Timeline

Software Engineer II

Epsilon
06.2022 - Current

Business Technology Solution Associate

ZS Associates
01.2022 - 06.2022

Database and ETL Developer

TATA Consultancy Services
06.2019 - 12.2021

B.E. - Electronics and communication

University Institute of Technology

Similar Profiles

CREATE PROFILE
Smit Nema