Summary
Overview
Work History
Education
Skills
Timeline
Generic

Esakki Raja

Data Architect /Data Engineer
Your City

Summary

Seasoned Data Architect and Technical Team Lead with over 14 years of experience in designing, developing, and implementing enterprise-grade data solutions in Banking and Financial Services. Highly skilled in building end-to-end ETL pipelines, cloud-based data lakes, and real-time reporting solutions using a rich stack including Informatica, SSIS, Azure Data Factory (ADF), Databricks, Azure Data Lake, SQL Server, Oracle, Power BI, and Splunk. Expert in regulatory reporting (Basel, FATCA, CRS), data governance, pipeline optimization, and cloud migration. Strong record of architecting high-performance systems while leading cross-functional agile teams.

Overview

14
14
years of professional experience

Work History

Internal Stakeholders

Team Lead – Ingestion Lead

01.2018 - 01.2021
  • Redesigned on-prem ETL processes using SSIS and modernized with Azure ADF pipelines.
  • Built reusable SSIS components using Script Task/Components, variables, and logging frameworks.
  • Led migration of 50+ legacy workflows to cloud-native pipelines reducing batch time by 30%.
  • Implemented pipeline monitoring via Azure Monitor, ADF logs, and custom alerting.
  • Mentored junior engineers, conducted design/code reviews, and standardized best practices.

Team Lead – Dashboard & Reporting

Virgin Money & Société Générale
01.2016 - 01.2018
  • Engineered real-time Splunk dashboards to monitor critical metrics (TPS, error codes, transaction delays).
  • Configured log forwarding from payment applications and transformed events using SPL queries.
  • Defined service-level thresholds and created alerts for anomalies using correlation searches.
  • Integrated dashboards with business operations for SLA adherence and proactive incident management.
  • Optimized dashboard latency and search performance using indexed fields and data models.

Team Lead – ETL & Reporting

FINO Payments Bank & Bandhan Bank
01.2013 - 01.2016
  • Developed SSIS packages for integrating core banking systems with finance and MIS databases.
  • Designed ETL flows involving slowly changing dimensions (SCD), lookups, conditional splits, and derived columns.
  • Published SSRS reports with complex stored procedures and subscriptions for daily MIS circulation.
  • Automated multi-branch consolidation and ensured reporting accuracy through validations.
  • Led a 5-member ETL team, ensuring SLA compliance, issue triage, and production deployments.

Team Lead – Ingestion Lead

Standard Chartered Bank
01.2007 - 01.2013
  • Owned regulatory data ingestion for Basel III, FATCA, and CRS compliance using Informatica workflows.
  • Designed mapping parameters, reusable transformations, and dynamic sessions for modularity.
  • Optimized Oracle procedures and queries used in reporting ETL and downstream processes.
  • Created SSRS reports for compliance tracking and enabled audit trails for submitted data.
  • Interfaced with Risk and Compliance departments to align system changes with reporting rules.

Education

Bachelor of Engineering - [Specialization]

[Your University Name]

Skills

ETL & Data Pipelines

undefined

Timeline

Team Lead – Ingestion Lead

01.2018 - 01.2021

Team Lead – Dashboard & Reporting

Virgin Money & Société Générale
01.2016 - 01.2018

Team Lead – ETL & Reporting

FINO Payments Bank & Bandhan Bank
01.2013 - 01.2016

Team Lead – Ingestion Lead

Standard Chartered Bank
01.2007 - 01.2013

Internal Stakeholders

Bachelor of Engineering - [Specialization]

[Your University Name]
Esakki RajaData Architect /Data Engineer