Gaurav Jain
Sr Etl Informatica Developer @Rabobank
Signup · Get unlimited contacts
WORK HISTORY
Sr Etl Informatica Developer @Rabobank
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
Dr. B. R. Ambedkar University
Bachelor's degree, Computer Science
University of Wales
Master of Business Administration - MBA, International Marketing
Trailhead by Salesforce
Salesforce Admin
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.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.