Senior ETL Developer with 5+ years of experience designing and implementing end-to-end data pipelines, data warehouse architectures, and ETL/ELT solutions for large-scale financial data systems. I specialize in SQL/PL-SQL and Python-based transformations, optimizing pipelines for performance, scalability, and reliability across banking and insurance domains. I design data models and ER diagrams, build batch and real-time processing workflows, and automate scheduling/monitoring using tools like Apache Airflow. I also work with enterprise ETL platforms such as Informatica (PowerCenter/BDM/IICS) and cloud data platforms including AWS and GCP, with a focus on data quality, governance, and delivering high-quality, detail-oriented solutions.

Suraj Tamboli

Senior ETL Developer with 5+ years of experience designing and implementing end-to-end data pipelines, data warehouse architectures, and ETL/ELT solutions for large-scale financial data systems. I specialize in SQL/PL-SQL and Python-based transformations, optimizing pipelines for performance, scalability, and reliability across banking and insurance domains. I design data models and ER diagrams, build batch and real-time processing workflows, and automate scheduling/monitoring using tools like Apache Airflow. I also work with enterprise ETL platforms such as Informatica (PowerCenter/BDM/IICS) and cloud data platforms including AWS and GCP, with a focus on data quality, governance, and delivering high-quality, detail-oriented solutions.

Available to hire

Senior ETL Developer with 5+ years of experience designing and implementing end-to-end data pipelines, data warehouse architectures, and ETL/ELT solutions for large-scale financial data systems. I specialize in SQL/PL-SQL and Python-based transformations, optimizing pipelines for performance, scalability, and reliability across banking and insurance domains.

I design data models and ER diagrams, build batch and real-time processing workflows, and automate scheduling/monitoring using tools like Apache Airflow. I also work with enterprise ETL platforms such as Informatica (PowerCenter/BDM/IICS) and cloud data platforms including AWS and GCP, with a focus on data quality, governance, and delivering high-quality, detail-oriented solutions.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate

Work Experience

Senior ETL Developer at The Hartford Group - USA
January 1, 2025 - Present
Designed and implemented complex ETL pipelines to ingest, transform, and load 2TB+ of daily financial and market data into enterprise data warehouses and data lakes using Python and PySpark. Developed and optimized SQL/PL-SQL transformations (stored procedures, functions, cursors, triggers, materialized views) for Oracle and Snowflake. Built and maintained Informatica BDM-based ingestion and processing for large-scale transactional data, including reusable mappings/workflows for batch and incremental loads. Scheduled and monitored 1000+ daily ETL jobs, architected end-to-end workflows from extraction to data mart loading, and improved pipeline performance by 38% through query optimization, indexing, and parallel processing. Implemented Airflow automation for scheduling/monitoring and built RESTful services exposing processed data for trading, underwriting, and risk analytics. Applied data quality checks and anomaly detection using Pandas/NumPy and supported regulatory/KPI/risk-modeling
Application Developer Analyst at Accenture - India
June 1, 2019 - July 1, 2023
Designed and developed scalable Python-based ETL pipelines to process and load 1.5TB+ of daily financial transactions and operational datasets into enterprise reporting systems. Built ETL workflows to move data from data lake environments to Oracle databases and flat files for downstream analytics. Implemented ingestion pipelines for international transaction datasets ensuring consistency across environments, and created incremental/idempotent loads to prevent duplication. Delivered transformation and reconciliation pipelines using SQL and PySpark for warehousing and financial reporting. Developed Informatica IICS applications and scheduled workflows using Administrator console, and used Informatica BDM developer tools for connections, synchronization, and data migration between live/non-live environments. Maintained continuous ingestion by running 1000+ ETL jobs daily with failure troubleshooting. Also performed full lifecycle Oracle development including data modeling, PL/SQL (proced

Education

Master of Science in Data Science at Pace University, New York, USA
January 1, 2025 - May 1, 2025
Bachelor of Engineering in Computer Science at Mumbai University, India
July 1, 2015 - July 1, 2019

Qualifications

Artificial Intelligence Certification
January 11, 2030 - July 23, 2026

Industry Experience

Financial Services