Gaurav Jain

About Gaurav Jain

As a member of the Enterprise Data Integration team I learned to provide value to customers by delivering outstanding integration solutions. I am confident to present and defend my design, code and document review with technical or business team. I have experience in the full development lifecycle, working with diverse data formats and provide input to Data Integration strategy and helping to set and drive standards and best practices.

Experience

1. Sr Etl Informatica Developer

   Rabobank

   Feb 2021 — Present · St Louis, MO, US

   Responsibilities: • Experience in Informatica Intelligent Cloud Services (IICS) Application Integration components like Processes, Service Connectors, and Process Object. • Experience in data modelling, schema designing, data loading, data replication, SQL Query writing and optimization on distributed databases preferably on Cloud Technologies • IICS (Informatica Cloud)- Data Integration, Mass Integration, Application Integration & API Integration. • Effectively using IICS Data integration console to create mapping templates to bring data into staging layer from different source systems like Sql Server, Oracle, Teradata, Salesforce, Flat Files, Excel Files • Implemented Data Synchronization, Data Replication, Mass Ingestion, mapping tasks in IICS. • Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse. • Worked on Informatica ICS interface (REST API) to generate OAuth 2.0. authorization and automate the process that sends the push Service Now files into local Drive. • Created automation process for Online reporting and sending information from SAP to client vendor via SFTP with active employee file update on regular basis. • Encrypt and mass integration to move the file to sftp and archive folder after encryption. • Created IICS Connections using various cloud connecters in IICS Administrator • Designed MASS Ingestion task to ingest large datasets - File Ingestion • Developed Cloud Integration parameterized mapping templates (DB, and table object parameterization) for Stage, Dimension (SCD Type I and Type II, CDC and Increment load) and fact table. • Worked on Informatica Data Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.

Education

• Project Management Institute

  PMP, Project Management, A

  2018 — 2018

• Dr. B. R. Ambedkar University

  Bachelor's degree, Computer Science

  1999 — 2003

• University of Wales

  Master of Business Administration - MBA, International Marketing

  2005 — 2007

• Trailhead by Salesforce

  Salesforce Admin

  2021 — 2022