GOURISH
PROFILE SUMMARY
Data Engineering professional with 14 years of experience in ETL technologies and strong
expertise in data warehousing, data migration and integration using Informatica platforms.
Experienced Informatica and Snowflake certified developer with extensive hands-on
experience in Informatica PowerCenter (8.x/9.x/10.x) and Informatica Intelligent Cloud
Services (IICS/IDMC) including CDI, CAI, CDQ, API Manager, Mass Ingestion and Monitoring
services.
Strong experience across technologies such as Snowflake Cloud, Oracle SQL, PL/SQL, Unix
shell scripting, Autosys, MS SQL Server, SAP Business Objects, Salesforce and AWS Cloud.
As a Project Delivery Lead, involved in:
• Requirement analysis
• ETL development
• Data migration
• Testing and support
Recognized for strong communication skills, proactive delivery ownership and ability to meet
project deadlines without compromising quality.
Skills
Category Skills
ETL & Data Informatica PowerCenter 8.x/9.x/10.x, Informatica Intelligent Cloud
Integration Services (IICS/IDMC), CDI, CAI, CDQ, API Manager, Mass Ingestion
ETL development, data extraction, transformation and loading,
Data Warehousing
dimensional modeling (Star Schema & Snowflake Schema)
Programming &
Oracle SQL, PL/SQL, Unix Shell scripting, Windows Batch scripting
Scripting
Cloud & Databases Snowflake Cloud, Oracle, MS SQL Server, Netezza
Integration & Tools Salesforce, SAP Business Objects, PowerExchange for CDC
Schedulers &
Autosys, Tidal, UC4
DevOps Tools
Cloud Platforms AWS Cloud
Category Skills
Development Tools Jira
Operating Systems UNIX, Windows NT, Windows XP
Business
Data Warehousing ETL and Reporting
Intelligence
Certifications
• Informatica PowerCenter 9.x Certified — Informatica Corporation
• Oracle SQL Certified — Oracle Corporation
• SnowPro Certified — Snowflake
• Informatica PowerCenter Certified — Brain Bench
• Data Warehousing Concepts Certified — Brain Bench
• Unix Shell Scripting Certified — Brain Bench
PROFESSIONAL EXPERIENCE
Project 1
Role: Senior Data Engineer
Domain: Financial Services & Banking Domain
Project: Adecco Integrated Front Office Data Migration
Client: Adecco Global
May 2021 – Present
Technologies: Informatica IICS, Informatica PowerCenter 10.x, Snowflake, Salesforce, UNIX
scripting, MS-SQL, Autosys
Responsibilities
• Gathered business requirements for data migration initiatives.
• Defined data migration architecture and designed data flows from legacy systems to
Salesforce CRM and Snowflake Cloud Data Warehouse.
• Worked on multiple projects to analyse data usage and migration impacts.
• Designed and managed the data migration lifecycle.
• Extensively worked on IICS services including:
o CDI (Cloud Data Integration)
o CAI (Cloud Application Integration)
o Mass Ingestion
o API Manager
• Built REST API integrations and web services using Application Integration
connectors.
• Integrated third-party APIs using JWT authentication and REST connectors.
• Exposed IICS processes as APIs for external systems.
• Documented data migration requirements, risks, milestones and quality checks.
• Conducted source system analysis and source-to-target mapping.
• Performed migration testing, reconciliation and exception reporting.
• Managed cross-program data assurance across source and target systems.
Project 2
Role: Advisory Technical Services Specialist
Domain: Financial Services & Banking
Project: Hornet / Actimize AML
Client: Barclays
Jan 2017 – May 2021
Technologies: Informatica PowerCenter 10.2, IICS, SAP BO, Unix scripting, MS-SQL, Autosys,
Jira, ServiceNow, GitHub, TeamCity, Nolio
Responsibilities
• Developed ETL mappings using Informatica PowerCenter and IICS.
• Designed and deployed ETL objects for new data feeds.
• Created workflows, sessions and worklets across sources such as Oracle, SQL Server,
Salesforce and MQ messages.
• Implemented Slowly Changing Dimensions (SCD Type 1, Type 2, Type 3).
• Implemented transformations including:
o Source Qualifier
o Lookup
o XML transformation
o Java transformation
o SQL transformation
• Worked extensively with IICS services including CDI, CAI, Mass Ingestion and API
Manager.
• Implemented pushdown optimization for performance tuning.
• Built Unix shell scripts for SFTP file transfer and encryption.
• Used scheduling tools such as Tidal and Autosys.
• Provided production support and troubleshooting for Informatica pipelines.
• Integrated Salesforce with Oracle using PowerExchange and Informatica Cloud.
• Mentored junior ETL developers.
Senior Project Engineer
Project 3
Domain: Financial Services & Banking
Project: GSP Trade Monitoring System
Client: UBS
May 2015 – Nov 2016
Responsibilities
• Developed ETL solutions for a global compliance alert system.
• Designed ETL specifications and transformation logic.
• Built ETL pipelines using Informatica PowerCenter and IICS.
• Worked extensively on fact tables and Slowly Changing Dimensions.
• Implemented transformations such as Filter, Router, Expression, Lookup, Aggregator
and Joiner.
• Developed workflows and scheduled ETL jobs.
• Implemented performance tuning and workflow optimization.
• Supported unit testing, system testing and production support.
Project 4
Role: Consultant
Domain: Sales & Retail
Project: Warranty Management System (WMS)
Client: HP Global Soft
Dec 2013 – May 2015
Responsibilities
• Designed ETL pipelines for warranty analytics and reporting.
• Built ETL processes to load data from Oracle and flat files into data marts.
• Implemented incremental load processes for dimension and fact tables.
• Developed PL/SQL stored procedures for transformation logic.
• Created Unix scripts and scheduler jobs for workflow automation.
• Developed technical documentation for ETL processes.
Project 5
Domain: Financial Services, Retail & Banking
Project: Deutsche Bank Data Warehouse Programs
Oct 2010 – Dec 2013
Projects included:
• DBDC Migration Project
• DBFEEDS-FSR Data Warehouse Expansion
Responsibilities
• Migrated Informatica objects from PowerCenter 8.6 to 9.1.
• Created Informatica mappings, workflows and reusable transformations.
• Managed repository users, groups and privileges.
• Built ETL pipelines using transformations such as:
o Filter
o Expression
o Aggregator
o Lookup
o Router
o Update Strategy
• Performed debugging, performance tuning and testing.
• Created shell scripts and PMCMD commands for workflow execution.
• Provided L2/L3 production support and root cause analysis.
• Participated in technical documentation and support activities.
Education
[Link] (2010)