Soumik Ghosh
Solution Architect - Associate Director
Pune
Summary
Experienced IT professional with over 15 years in end-to-end solution delivery through advanced ETL and cloud technologies. Specializes in regulatory reporting, cloud migration, and data architecture within finance, insurance, and retail industries. Demonstrated ability to lead teams and promote collaboration while maintaining coding standards. Proficient in Informatica PowerCenter, Oracle DB, PostgreSQL, Python, PySpark, Databricks, and Microsoft Azure to improve operational efficiency and achieve strategic goals.
Overview
11
11
years of professional experience
8
8
Certifications
4
4
Languages
Work History
Associate Director
UBS
- 01.2023
- Architected and led the end-to-end modernization of regulatory reporting platforms, aligning with evolving regulatory frameworks including EMIR 3 and ESMA/EU mandates.
- Designed and implemented a cloud-first data architecture, migrating legacy systems from Oracle (on-premise) to Azure PostgreSQL, improving scalability, resilience, and cost efficiency.
- Defined target-state architecture for ETL modernization by transitioning from Informatica PowerCenter to Azure Databricks and Python-based distributed processing.
- Led large-scale cloud migration programs, including: Informatica PowerCenter 10.1 → 10.4 (on-prem to cloud) Legacy Informatica 10.5 → Azure Databricks transformation
- Architected hybrid data platforms integrating legacy and cloud systems with strong focus on data lineage, governance, and audit compliance in a regulated banking environment.
- Spearheaded implementation of Data Mesh principles, enabling domain-oriented data ownership and improving data accessibility across business units.
- Designed and executed migration of reporting layer (SAP Business Objects) from Oracle to Azure PostgreSQL, enhancing reporting performance and maintainability.
- Provided architecture governance and design leadership, conducting design reviews, driving technology upgrades, and ensuring alignment with enterprise architecture standards.
- Collaborated with cross-functional teams (engineering, infrastructure, business, and compliance) to deliver high-availability, scalable, and audit-ready solutions.
- Mentored engineering teams on cloud architecture patterns, distributed data processing, and modernization strategies, fostering adoption of best practices.
Technology Lead
Infosys Ltd.
10.2017 - 01.2023
- Led and mentored a 20+ member team delivering regulatory reporting solutions for a Swiss bank, enforcing engineering best practices and coding standards.
- Architected scalable liquidity reporting and stress testing platforms, while optimizing high-volume data processing in Oracle and Informatica.
- Designed API-driven data ingestion, exposure, and authentication frameworks using Informatica PowerCenter.
- Built a dynamic rule engine in Oracle (PL/SQL) for liability reporting, minimizing code changes and improving maintainability.
- Developed reusable Python utilities for API-based JSON data ingestion and automation.
- Led migration of Informatica from on-prem (10.1) to cloud (10.4) with minimal disruption.
Technology Analyst
Infosys Ltd.
04.2015 - 10.2017
- Gathered and translated requirements for Bank of England regulatory submissions and operational reporting for a UK-based treasury bank.
- Collaborated with traders, dealers, and stakeholders to design a scalable data mart addressing business-critical insights.
- Authored functional specifications and designed database schemas using Erwin Data Modeler for implementation and sign-off.
- Implemented regulatory reporting using a flexible rule engine approach, improving adaptability to changing requirements.
- Developed Informatica ETL pipelines supporting underwriting, claims, and settlement processes across UK operations.
- Enabled CI/CD via TeamCity, Octopus Deploy, GitHub, and PowerShell automation for streamlined DevOps delivery.
- Built Alteryx workflows for reconciliation of regulatory and operational reports, enhancing accuracy and efficiency.
Senior Systems Engineer
Infosys Ltd.
12.2013 - 04.2015
- Developed and optimized Teradata (BTEQ, MLOAD, FASTEXPORT) and Informatica ETL pipelines for BW-to-data mart integrations (Oracle/Teradata).
- Mentored L3 support team and conducted trainings on PL/SQL, Teradata, and Informatica, improving incident resolution efficiency.
- Built Tableau dashboards for sales analytics and demand forecasting.
- Delivered a Splunk PoC dashboard with alerts to enhance monitoring of IBM Cognos platforms.
Systems Engineer
Infosys Ltd.
08.2011 - 12.2013
- Rapidly upskilled and delivered media analytics solutions using MSBI stack (SSAS, SSIS, SSRS).
- Automated ETL pipelines (full & incremental loads) using SSIS, improving data processing efficiency.
- Authored application requirement and functional documentation.
- Developed real-time streaming pipelines using Kafka–Storm integration.
- Worked on modern data platforms including Azure Synapse Analytics, Databricks, and PySpark for scalable data processing.
Education
B.Tech - Electrical Engineering
Nirma University
Ahmedabad01.2011
undefined
Asia English School
Ahmedabad01.2007
undefined
Asia English School
Ahmedabad01.2005
Skills
Informatica Powercenter 8x/9x/10x
Informatica CDI-PC
Oracle DB
Alteryx
Tableau
Python
NumPy
Pandas
Pyspark
Autosys (CA workload automation)
PostGress SQL server
Microsoft Azure
Databricks
Erwin DM
Unix shell scripting
DevOps CI/CD with GitLab
Enterprise Data Mesh concepts
Cloud Architecture
Azure data platform
Data engineering
Solution designing
Regulatory reporting
ETL modernisation
Stakeholder management
Data modelling
Certification
Infosys certified Data science fundamentals, Infosys (August 2019 — Present)
Interests
Badminton, Robotics, Swimming, Singing
WEBSITES AND SOCIAL LINKS
LinkedIn: http://linkedin.com/in/sou2011mik
Timeline
Technology Lead
Infosys Ltd.
10.2017 - 01.2023
Technology Analyst
Infosys Ltd.
04.2015 - 10.2017
Senior Systems Engineer
Infosys Ltd.
12.2013 - 04.2015
Systems Engineer
Infosys Ltd.
08.2011 - 12.2013
Associate Director
UBS
- 01.2023
B.Tech - Electrical Engineering
Nirma University
undefined
Asia English School
undefined
Asia English School