Summary
Work History
Education
Skills
Websites
Accomplishments
Certifications
Generic
Sonam Malhotra

Sonam Malhotra

Lead Software Engineer and Architect
Mumbai,Maharashtra

Summary

Accomplished Technical Architect with 19 years of experience in Application Development and Software Engineering within the financial services industry. Experienced in collaborating with global teams (US, EMEA, APAC) on strategic initiatives with proven track record in Database Migration, Cloud Platform (AWS) Design & Provisioning using Terraform and Data Engineering processes. Expertise in ETL tools such as Informatica PowerCenter and Pentaho Data Integration, alongside proficiency in Application Modernization and AWS Cloud Migration. Skilled at managing end-to-end Software Development Life Cycle to drive innovative solutions.

Work History

Vice President, Lead Software Engineer

J.P. Morgan Services India Pvt. Ltd
Mumbai
1 2011 - Current
  • Collaborated with management and stakeholders to develop strategic initiatives for long-term goals, leveraging technology to resolve technical roadblocks.
  • Led cross-functional teams for the successful Database Migration from AWS RDS Postgres to AWS Aurora PostgreSQL resulting in increased efficiency and client satisfaction.
  • Developed and maintained Data Engineering processes ensuring smooth integration of data from diverse sources into Database and Data Lake along with best development practices for managing Data Pipelines.
  • Led the Migration of on-premises ETL Tech stack to Cloud Platform, provisioning AWS services using Terraform.
  • Provided estimates, formalized release plans and implemented ETL data validation processes.
  • Involved in POC for creation of a Self-Service data platform using the Data Mesh Architecture, leveraging Snowflake Cloud Datawarehouse for Data Distribution
  • Led Site Reliability Engineering (SRE) Practices with respect to Monitoring and Observability within the Project.
  • Provided guidance and direction to less experienced staff, mentoring junior developers in resolution of complex technical problems, fostering talent development.

Business Strategy Analyst

Sapient Corporation Pvt. Ltd.
Gurgaon
09.2009 - 10.2010
  • As part of this project’s assignment, I traveled onsite and worked from the client’s office: Deutsche Telekom Product and Innovation, Darmstadt, Germany
  • Coordinated project schedules & appropriate contingency plans with management ensuring timely delivery of tasks
  • Created strategy to download source files from Remote File Servers and handled the issues/defects/change requests raised by the Testing team
  • Technologies: Informatica PowerCenter Version 8.1, Oracle 10g, SQL, PL/SQL, WINSCP for Unix, TOAD for Oracle, Sun Solaris, UNIX OS

Business Technology Analyst

Deloitte Consulting India Pvt. Ltd
Hyderabad
01.2008 - 09.2009
  • Understood and Acquired business requirements and participated in gaining functional knowledge with respect to design and development work from Business Users
  • Provided technical solutions/strategies and implemented SCD and CDC strategies during the ETL Design
  • Prepared ETL Strategy and Mapping Specification Documents through interaction with Client
  • Technologies: Informatica PowerCenter Version 7.1, Oracle 9i, SQL, PL/SQL, WINSCP for Unix, TOAD for Oracle, Sun Solaris, UNIX OS

Software Engineer

Satyam Computer Services Ltd.
Hyderabad
08.2005 - 01.2008
  • As part of this project’s assignment, I handled the migration activity from client’s location at British Petroleum, London, UK
  • Upgraded Informatica PowerCenter version 5.1.2 to version 7.1 and automated different processes within Informatica PowerCenter tool
  • Technologies: Informatica PowerCenter Version 5 and 7.1, Oracle 9i, SQL, PL/SQL, TOAD for Oracle, Sun Solaris, UNIX OS

Education

Advanced Diploma in Business Administration (ADBA) -

LN Welingkar Institute of Management Development & Research
Mumbai
01.2014 - 01.2015

Bachelor Of Technology (B.Tech.) -

Sreenidhi Institute of Science And Technology
Hyderabad
01.2001 - 01.2005

XII -

Ratna Junior College
Hyderabad
01.2000 - 01.2001

X -

Marshalls School
Dehradun
01.1998 - 01.1999

Skills

ETL Tools: Informatica PowerCenter Version 105, Pentaho Data Integration Ver 93

Accomplishments

  • Won team level 'Innovation Award' for the TFR Migration Project to GFR and 'Rewards & Recognition (R&R) Award' for onboarding GFR to US NPE at JP Morgan.
  • Won 'Circle of Excellence (COE) Team Award' for 'GFR AWS Event Based Scheduling Framework' within JP Morgan.
  • Won 'COE Individual Award' and 'Star of the Month (STOM) Individual Award' for 'Reconciliation Framework for Data Comparison' within JP Morgan.
  • Won 'Star of the Month (STOM) Individual Award' for 'Fund Val RDS to Aurora PostgreSQL Migration' in JP Morgan.
  • Gave Presentation on 'AWS Batch Framework Using Pentaho' as part of 'SME Forum for Client Technology' and 'Client Service Knowledge Share Session' to an audience spanning entire AWM Client Technology at JP Morgan.
  • Represented the team at 'SRE Party' onboarding 'AWS Batch Customer Journey' as part of the project at JP Morgan.
  • 'Cloud Party' and 'Code-A-Thon' participant – enabling the team to migrate Pentaho Jobs to AWS.
  • Onsite at client location for projects - British Petroleum, London, UK and Deutsche Telekom Product and Innovation, Germany.

Certifications

  • AWS Certified Solutions Architect – Associate (SAA - C02) & AWS Certified Data Engineer - Associate (DEA-C01)
  • Certified: Terraform Associate (003), HashiCorp
  • Professional Scrum Master I (PSM I), Scrum.org
  • Advanced Diploma in Business Administration (ADBA), LN Welingkar Institute of Management Development & Research
  • Certification on Financial Markets (NCFM) & Mutual Funds (MFBM), National Stock Exchange (NSE) of India
  • Oracle Certified Professional (OCP), Oracle Corp
  • Informatica Certified Designer, Informatica Corp

Similar Profiles

  • Rashmita Baruah

    Rashmita BaruahRashmita Baruah

    Process Improvement Associate at J.P. Morgan Services India Pvt Ltd.Process Improvement Associate at J.P. Morgan Services India Pvt Ltd.

    View Profile
  • Balasubrahmanyam Daliparty

    Balasubrahmanyam DalipartyBalasubrahmanyam Daliparty

    Associate Vice President at J.P. Morgan Services India Pvt. Ltd.Associate Vice President at J.P. Morgan Services India Pvt. Ltd.

    View Profile
  • SAGAR DASHORA

    SAGAR DASHORASAGAR DASHORA

    Vice President - Engineering Lead at J.P. Morgan Services India Pvt. LtdVice President - Engineering Lead at J.P. Morgan Services India Pvt. Ltd

    View Profile
Sonam MalhotraLead Software Engineer and Architect