Inderjeet Singh Saran
BRIDGEWATER,NJ
Summary
Dynamic Data Integration Specialist with over 20 years of experience in architecting, designing, and optimizing robust enterprise-grade data pipelines. Proven success in modernizing legacy ETL platforms and leading cloud migration initiatives, particularly in transitioning data ecosystems to AWS environments. Expertise in developing comprehensive ETL ecosystems for Operational Data Stores (ODS) and Data Marts using a diverse technical stack that includes Informatica PowerCenter, Talend, SQL, Amazon Redshift, and Oracle. Skilled in leveraging modern Big Data frameworks such as AWS, Databricks, PySpark, and Python, while providing mentorship and technical guidance to globally distributed teams to ensure successful project delivery.
Overview
25
25
years of professional experience
Work History
Senior Data Engineer
SiriusXM
11.2016 - Current
- Modernized legacy ETL pipelines using Redshift – SPs, Shell scripting, and Databricks so read and extract data from Kafka / AWS-S3 / EC2 and load into Redshift-ODS, and Redshift DataMart.
- Developed parameterized Python scripts that uses yaml configuration file to extract files from AWS-S3 / EC2 / Remote servers and process data via scalable data pipelines
- Built incremental Lakehouse pipelines using Spark Declarative Pipelines (Python & SQL).
- Orchestrated the workflows via Lake flow Jobs for production scheduling and dependency management.
- Utilized an automated deployment framework that uses Databricks Asset Bundle and CI/CD pipelines.
- Migration to Redshift - Python – Glue - Databricks: Jan-2024 – Present
01.2021 - 12.2023
- Converted Informatica ETL code into Talend Jobs and tasks to extract data from AW-S3 / Teradata to Redshift – ODS, Redshift – Datamart.
- Developed Talend pipelines using Talend Studio and published in Qlik Talend cloud.
- Orchestrated Talend Jobs and Tasks in Tidal setup.
- Developed metadata-driven frameworks for reconciliation.
- Mentored global engineering teams, improving code quality and adoption of best practices
- Optimized SQL and data pipelines, achieving 30–50% performance gains.
- Served with full Support for post production issues.
- Migration to Cloud (Talend - AWS-Redshift): Jan-2021 - Dec-2023
11.2016 - 12.2020
- Designed, Built, Implemented, and Supported ETL ecosystem for ODS & Data Marts to provide Analytics and Insights related to Listener (Consumption, User Preferences & Device Session data).
- Worked closely with business team to understand and interpret functional requirements and develop technical design and mapping documents.
- Developed Mappings, Sessions & Workflows using Informatica Power Center to extract data from multiple sources like Kafka, Csv, Json, Xml and loaded into Columnar database Vertica.
- Implemented metadata-driven framework and Error handling for complete ETL process.
- On-Prem Data Engineering (Informatica - Vertica - Teradata): Nov-2016 - Dec-2020
- Applications: ODS & Data Marts for Consumption, User Preferences, and Device Session Data
- Environment: AWS-cloud, S3, EC2, PySpark, Redshift, Python, Databricks, Kafka, Linux, Tidal, Bitbucket, GitHub, DB visualizer, Informatica, Talend, DynamoDB, DbVisualizer.
ETL Lead
NYK Line
01.2005 - 10.2016
- Designed, Built, Implemented, and Supported ETL ecosystem for ODS & Data Marts to provide Analytics and Insights related to Container (Booking, BL), Equipment flow, AR & AP, and Vessel trip data.
- Implemented Process control and Error handling Frame work for the ETL ecosystem.
- Closely worked with the business team for better business insights.
- Mentored and assisted team for timely delivery of the deliverables.
- Applications: Integration Data Bridges: ITS-VMF, IEIS, VENUS, NCALS, CAB, LAB, Booking-Container, Equipment
- Environment: Sunopsis / ODI, Oracle, Sybase, AS-400, Mainframes, IBM MQ series, UNIX.
Senior ETL Developer
Various
10.2000 - 12.2004
- ETL Developer roles at Fairfax, Polo Ralph Lauren, Hillen Brand Industries, CNA Surety, ConAgra Foods, and GE Power Systems.
- Senior ETL Developer | Prior Experience (Condensed) | Oct 2000 – Dec-2004
Education
Bachelor’s Degree - Engineering
Mumbai University
IndiaDiploma - Management Studies
Mumbai University
IndiaSkills
- Informatica PowerCenter Talend ODI SQL ETL / ELT Oracle AWS ( S3, Redshift, Glue, EC2 ) AWS Python Databricks PySpark Unix Shell scripting Dimensional Modeling( Star / Snoflake schema ) Erwin CVS XML JSON Parquet Kafka Jira ServiceNow DbVisualizer Git version control Big data processing
- Technical Leadership Data Pipeline Design Development & Optimization Workflow Orchestration ETL / ELT Modernization Metadata Driven Pipeline Frameworks Data Quality & Validation Performance Tuning Technical Leadership & Mentorship
KEY CAREER HIGHLIGHTS
- Reduced recurring ETL processing time by 45% via ETL workflow redesign and SQL optimization.
- Delivered fully automated ingestion frameworks eliminating 80% of manual operational work.
- Improved system reliability and cut production incidents through enhanced monitoring and alerting.
Timeline
01.2021 - 12.2023
Senior Data Engineer
SiriusXM
11.2016 - Current
11.2016 - 12.2020
ETL Lead
NYK Line
01.2005 - 10.2016
Senior ETL Developer
Various
10.2000 - 12.2004
Diploma - Management Studies
Mumbai University
Bachelor’s Degree - Engineering
Mumbai University