Sonam Malhotra

Experience

• 

  Satyam Computer Services Ltd

  Aug 2005 - Jan 2008

  Software Engineer

  * As part of this project’s assignment, I traveled onsite and worked from the client’s office: British Petroleum, London, UK. * Upgraded Informatica PowerCenter version 5.1.2 to version 7.1* Analyzed business requirements and worked with business teams to develop/design ETL processes* Automated different processes within Informatica PowerCenter tool

• 

  Deloitte

  Jan 2008 - Sept 2009

  Business Technology Analyst

  * Understood and Acquired business requirements * Participated in gaining functional knowledge with respect to design and development work from Business Users* Managed and maintained process documentation for Quality compliance * Provided technical solutions/strategies required during ETL Design & Development phase* Implemented Slowly Changing Dimensions and Change Data Capture during the Load and Extraction Process* Prepared ETL Strategy Document consisting of all the strategies with respect to ETL* Prepared ETL Mapping Specification Documents through interaction with Client* Prepared Unit Test Plans and obtain Sign-off from client on the Plans Show less

• 

  Sapient

  Sept 2009 - Oct 2010

  Business Strategy Analyst

  * As part of this project’s assignment, I traveled onsite and worked from the client’s office: Deutsche Telekom Product and Innovation, Darmstadt, Germany. * Designed ETL flow and execute Oracle SQL queries on the staging, dimension and fact tables* Estimated ETL and Database related tasks for each iteration * Created Implementation Strategy documents. Review, update and provide feedback on Business Analysis document* Created strategy to download source files from Remote File Servers* Handled the issues/defects/change requests raised by the Testing team Show less

• 

  J.P. Morgan

  Jan 2011 - now

  Vice President

  * Interfaced with on-site Business Users/Product/Application Owners to understand business requirements as part of New Design, Defects, Change Requests and Enhancements, providing estimates, formalized release plans and implementation schedules/dependencies.* Participated in the solution design, build and troubleshooting of Integration implementations using Pentaho and Informatica PowerCenter and created Data Mapping, Implementation and Architecture documents for any new Design. * Achieved Modernization Goals set by the Organization by Migrating on Premises ETL code (Pentaho, Informatica) and Database Tech stack to Cloud Platform (Glue, Pentaho on ECS).* Worked on Database Migrations from AWS RDS Postgres to AWS Aurora Postgres, Version Upgrades, Sybase exit strategies and using API’s and services for loads.* Implemented systems to ensure the accuracy and integrity of data, including validation and cleansing processes. * Ensured best development practices for managing Data Pipelines and proper Unit Testing/Integration Testing of the components are followed along with creation of appropriate Test cases. * Designed Reconciliation strategy post data migration on AWS and various Automated Data Validation checks to improve Quality of data for end users.* Performed Environment Build and Deployment Activities using various Build Management Tools and DevOps and maintenance activities to support the Applications* Involved in on-boarding Site Reliability Engineering (SRE) Practices within the Project* Followed Collaborative Leadership working closely with other team members/teams, providing guidance and support on data-related and technical matters. Show less