Kshitij Thatte

Data Engineer with 4 years of experience designing and delivering enterprise-scale ETL/ELT pipelines, data warehouse solutions, and modern data platforms in the banking domain. Experienced in Azure Data Factory (ADF), Databricks, PySpark, SQL, Hive, and Informatica PowerCenter for building scalable data integration and transformation solutions. Skilled in Medallion Lakehouse Architecture, distributed data processing, data modelling, data quality validation, and performance optimization.

Proven ability to collaborate with cross-functional teams to deliver reliable, production-ready data solutions supporting enterprise analytics and reporting.

Associate Consultant at Oracle Financial Services Software (2022-07 – Present)

• Built robust ETL/ELT pipelines using Azure Data Factory, Databricks, and PySpark for ingestion, transformation, and loading of structured and semi-structured data from multiple core banking systems.
• Designed and developed scalable Lakehouse Architecture on Azure Databricks and PySpark processing multi-terabyte banking datasets, enabling faster analytics and reporting.
• Implemented advanced Spark optimizations including partitioning, caching, broadcast joins, and Delta Lake features, reducing processing time by 45% and improving pipeline performance.
• Collaborated with architects, business analysts, QA teams, and cross-functional stakeholders to translate business requirements into scalable data solutions while supporting production deployments.
• Established data quality frameworks with validation rules and reconciliation processes, achieving 99.5% data accuracy for critical financial datasets.
• Designed and developed enterprise ETL workflows to integrate Trade Finance data into Operational Data Store (ODS) and Data Warehouse environments using SQL and Informatica PowerCenter.
• Developed transformation logic and optimized SQL queries to improve processing efficiency and support high-volume financial data integration.
• Implemented automated reconciliation and validation checks to ensure data accuracy, consistency, and completeness across downstream reporting systems.
• Supported production releases, defect resolution, and performance improvements while collaborating with business users and technical teams throughout the software delivery lifecycle.
• Developed middleware integrations using IBM App Connect Enterprise (ACE) to enable secure communication between Oracle FLEXCUBE and enterprise banking applications.
• Supported SIT/UAT testing, production deployments, and issue resolution while collaborating with distributed teams to ensure stable enterprise system integrations.

Bachelor of Technology in Computer Science & Engineering – Lakshmi Narain College of Technology & Science, Bhopal (2022)