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
Informatica PowerCenter
SSIS
Azure Data Factory (ADF)
SQL-based ETL scripting
Cloud Technologies
Azure Data Lake Gen2
Azure Databricks
Azure Data Explorer (ADX)
Azure Synapse
Data Engineering
PySpark
Delta Lake
CI/CD (DevOps) for Data Pipelines
Parameterization
Data Flow Orchestration
Data Modeling & Architecture
Dimensional Modeling
Star/Snowflake Schema
Lakehouse Architecture
Data Vault
Reporting & Dashboards
Power BI
SSRS
Splunk
KPI visualization
Databases
SQL Server
Oracle
T-SQL
PL/SQL
Performance Tuning
Query Optimization
Version Control & DevOps
Git
Azure DevOps
Project Management
Agile/Scrum
Stakeholder Management
Delivery Ownership
Code Review & Mentoring
Compliance & Domain
Basel III
FATCA
CRS
Payment Gateways
MIS
Finance
Core Banking Systems
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]