Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Rupin Garise

Toronto,ON

Summary

Highly skilled professional with 10+ years of hands-on experience in analyzing, architecting, developing and designing solutions (ETL,Data Warehouse, Data Mart, ODS) in OLTP technologies using star and snowflake dimensional modeling. Hands-on exposure with Informatica Cloud(IICS)/ETL, Informatica Powercenter, Informatica Power Exchange and Reporting technologies. Self-motivated team performer with experience as Informatica Lead/Informatica cloud(IICS)Developer/DW Architect/Sr. Oracle Developer.

Overview

14
14
years of professional experience

Work History

Sr. Informatica/IICS Developer

CGI
Toronto, ON
08.2013 - Current
  • Interacted with Business partners to identify/understand requirements, design specifications, expectations, and vision in key regulatory projects like Transparency, Interoperability (FHIR), RAPS and Provider Data Directory.
  • Identify ETL specifications based on business requirements and creating ETL Mapping Documents, high level documentation for product owners and data managers.
  • Handled end-to-end Development and Implementation of Data warehouse and Data Marts by taking into consideration business cases, objectives, optimization, and requirements. Which reduces loading timings 25 %.
  • Re-architected and developed MSP reporting project.
  • Managed Onsite, Onshore and Offshore Teams with 10+ members.
  • Managed code reviews and ensure that all solutions and processes are aligned to architectural/requirement specifications, SLAs and standards.
  • Developed CMS regulated projects with critical deadlines and saved million dollars to client.
  • Developing Informatica Cloud Mappings, Ds task, Data replication and task creation.
  • Provide resolution to extensive range of complicated ETL-related problems, proactively and as issues surface.

ETL Informatica Developer

Sritek INC
Dallas, TX
03.2013 - 07.2013
  • Designed and created mappings using tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
  • Involved in various phases of project from design to development to integration and acceptance testing.
  • Extensively used various Transformations like Source Qualifier, Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
  • Analyzed session logs, bad files and error tables for troubleshooting mappings and sessions.
  • Debugged maps using Debugger and Transformation’s verbose data.
  • Performance tuning of mappings, transformations and sessions to optimize session performance.
  • Created shared folders, local and global shortcuts to reuse metadata.
  • Created various sessions, tasks like event raise and event wait.
  • Scheduled and monitored workflows by use of Workflow Manager and Workflow Monitor.
  • Defined parameters, variables and parameter files for flexible mappings/sessions.
  • Involved in Unit testing and Integration testing.
  • Prepared various kinds of documents like Test case document, mapping design document.
  • Involved in performance tuning of mappings to tune data loads, and worked with DBAs to tune SQLs for better performance.
  • Involved in migration of code from development to QA environment and then to production.

Software Intern

Technodrive Business Sol INC
San Jose, CA
08.2012 - 02.2013
  • Worked with business analysts to identify appropriate requirements for Data warehouse and to document business needs for decision support data.
  • Performed data transformations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
  • Written SQL overrides in Source Qualifier for improving performance of mapping.
  • Familiar with parameter file and its usage.
  • Written pre session and post session scripts in sessions.
  • Created sessions and workflow for designed mappings.
  • Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
  • Monitored batches and sessions for weekly and Monthly extracts from various data sources across all platforms to target database.
  • Optimized Performance of mappings to load data quickly.

Intern

Honeypot IT
Hyderabad, India, TS
08.2009 - 01.2010
  • Used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, Workflow Manager and Monitor
  • Used Source Analyzer and Warehouse Designer to import source and target database schemas and used mapping designer to map source to target.
  • Used transformation Developer to create Joiner, filters, Router, Expressions and Aggregation transformations in mappings.
  • Extensively used transformations like lookup, aggregate, joiner, filter, and sequence generator, expression to create complex mappings
  • Write Informatica ETL design documents, establish ETL coding standards, develop Informatica mappings and perform reviews of same.

Education

Master of Science - Computer Science

International Technological University
San Jose, CA
05.2013

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University
India
08.2009

Skills

  • ETL Team Leader
  • Informatica Power Center 10x/9x/8x
  • Informatica Power Exchange CDC
  • IICS (Informatica Cloud) Data Integration
  • Scope and Roadmap for DW ,ETL and BI
  • Data Modelling, ETL High Level and Low Level Design
  • Teradata, SQL Server and Oracle(PL/SQL)
  • Strong knowledge on SQL Architecture
  • KPIs and Reporting specific calculations
  • Developing/Designing ETL Informatica processes/mappings
  • Tuning ETL/Informatica mappings/processes
  • Best practices for developing ETL jobs
  • UNIX Shell Scripting and ETL automation
  • Tuning of complex SQL Queries/Processes
  • SCD 1, 2 ,3 and Change Data Capture (CDC)
  • Resolving production ETL failures
  • Optimal performance strategy using indexes, joins indexes, partitioning, statistics etc
  • Root cause analysis of business driven issues
  • Experience on Cisco Tidal Enterprise, Autosys and Ctrl M Schedulers
  • Good team player, constant learner, excellent analytical & logical skills

Accomplishments

  • Extensively tested and debugged IICS and found performance bugs.
  • Reported the bugs and Informatica acknowledged the Bugs.
  • Critically reported the Bug in IICS where the code written in Expression Transformation for the Variable and Output ports disappearing even after the code is saved.
  • Worked directly with the informatica Team in debugging the issue va live sessions.
  • The fix was addressed by Informatica in the subsequent major release on August/29/2023 and involved in the testing of the Bug fix before the release with Informatica.
  • Received Applauds for delivering regulatory projects with Critical deadlines which saved Client from financial penalties.

Timeline

Sr. Informatica/IICS Developer

CGI
08.2013 - Current

ETL Informatica Developer

Sritek INC
03.2013 - 07.2013

Software Intern

Technodrive Business Sol INC
08.2012 - 02.2013

Intern

Honeypot IT
08.2009 - 01.2010

Master of Science - Computer Science

International Technological University

Bachelor of Science - Computer Science

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Rupin Garise