Data Warehouse Integration

Tirth Gondaliya

Mobile - 469-***-****

Email - ad5xrp@r.postjobfree.com

Location: Dallas - Texas

US Citizen

Professional Summary:

Almost 7+ years of experience in IT at various locations within United States in multiple roles such as ETL Informatica Developer and ETL Data Integration Developer, Data Modeller, Data Warehouse Consultant and Programmer.

● Experience in Data Warehouse development using ETL/Informatica Power Centre across various industries such as Automotive, Communications, Insurance and Retail.

● Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems in Azure SQL Data warehouse.

● Development of A2A Integration processes using Informatica Cloud Real Time (ICRT)

● Extensive experience in developing ETL mappings, scripts and data integration using Informatica Power Center 10.1/9.1/8.6.1/8.5/8.1.

● Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Testing, and Deployment.

● Experience in working with business analysts to identify and understand requirements to create Technical Design Documents.

● Experienced in data profiling and data analysis.

● Attended data model review sessions with Data Modeler.

● Expertise in understanding Business Model Identifying Dimensions and Facts.

● Solid understanding of OLAP concepts and challenges, especially with large data sets.

● Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator,

Aggregator, and Rank) for better usability.

● Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modelling (Star

Schema).

● Have worked on writing stored procedure, function and SQL script.

● Experience working with IICS concepts relating to data integration, Monitor, Administrator, deployments, permissions, schedules.

● Expertise in implementing slowly Changing Dimensions - SCD Type 1 & SCD Type 2.

● Experience in integration of various data sources like Oracle, DB2, Sybase, My SQL, SQL Server and non-relational sources like flat files into

staging area.

● Experience in converting SSIS packages to Informatica.

● Extensively worked with SQL and Pl/SQL.

● Experience in doing performance tuning of Data Base queries.

● Experience in UNIX environment, file transfers and job scheduling.

● Worked on Informatica Performance Tuning identifying and resolving performance bottlenecks in various levels like sources, targets,

mappings and sessions.

● Provided extensive Production Support for Data Warehouse for internal and Oracle DBMS from ETL servers via remote servers.

● Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer,

Assignment, Worklet, Control).

● Involved in Unit testing, System testing to check whether the data loads into target are accurate.

● Experienced in ETL Informatica & Database Upgrade Testing.

● Experience working in Agile methodology and ability to manage change effectively.

● Excellent communication, interpersonal skills, enthusiastic, self-starter, eager to meet challenges and quickly assimilate latest technologies

concepts and ideas.

Technical skills and Technologies:

Data Warehousing: Informatica Power Center 10.1/9.1/8.6.1/8.5/8.1, IICS informatica cloud, Power exchange, Teradata, Informatica Cloud Real Time (ICRT), Datastage, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, OLTP,

OLAP, S3.

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases: Oracle 11g/10g/9i/8i, Microsoft SQL Server, Postgres, MySQL.

Programming Languages: C, SQL, PL/SQL, SQL Plus, XML, VB.NET, T-SQL.

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/, Business Objects XI r2/6.x/5.x

Shell Scripting: UNIX Shell Scripting, Korn shell scripting.

Other Tools: SQL* PLUS,, and Putty.

Testing Tools: JIRA, HP ALM 11.5, HP Quality Center 9.0/9.2/10.0.

Methodologies: Agile

Operating Systems: WINDOWS, WINDOWS- NT/XP Professional, UNIX, HPAIX.

Professional Experience

University of Pittsburgh Medical Center – (Health Insurance) – Pittsburgh Pennsylvania

Duration: January 2021 – February 2024

ETL Informatica Developer

Roles & Responsibilities:

● Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements.

● Experienced in doing performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating the with tuning methods.

● Worked with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model.

● Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.

● Communicated with business customers to discuss the issues and requirements.

● Modified UNIX scripts to run informatica workflow.

● Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression,

Update Strategy, Transaction Control and Sequence Generator.

● Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables

● Development of A2A Integration processes using Informatica Cloud Real Time (ICRT).

● Implemented Change Data Capture (CDC) for handling delta loads.

● Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment.

● Oracle, DB2, My SQL, Flat Files and XML Files.

● Used Informatica file watch events to pole the FTP sites for the external files.

● Worked on building Service Connectors, application connection and process objects that are used for the development of ICRT/IICS processes.

● Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load into Teradata Warehouse.

● Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata SQL.

● Experience in Designing and developing data integrations using Informatica Cloud (IICS).

● Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

● Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

● Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.

● Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

● Pre and post session assignment variables were used to pass the variable values from one session to other.

● Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks,

● Maintaining bug, status using JIRA tool.

● Performed unit testing at various levels of the ETL and actively involved in team code reviews.

● Worked with ETL Admin team for code migration activities and deployments.

● Worked with QA team for better understanding of code development.

● Implemented & followed organization level Informatica best Standards & Procedures.

Power Wellness - Pittsburgh, PA

Duration: January 2019 – December 2020

Title: ETL Data Integration Developer

Roles & Responsibilities:

● Experience in DataStage, Data Warehousing, DataMart, Data Migration and DWH Testing with exposure to industries like design,

construction, and management services for medically integrated, commercial, university, and community fitness facilities.

● Power Query - import DW, transform, add, extract, group, custom column, replace, change type, M functions.

● Power Pivot - star data model, active and inactive relationships (1-1/M, M-M), bi-directional cross filtering.

● Visuals - table, column, bar, charts. Drill through. Dynamic chart axes by Bookmarks. Deploying to Service.

● Extensive Experience in full life cycle development of Data Warehouse including requirement gathering, source data analysis & profiling,

identification of business rules and development of ETL jobs.

● Very proficient in building Metadata driven ETL frameworks which supports Audit and Error process and recycle and 2 implementations,

variable frequency loads by handling Late Arriving Dimensions etc.

● Experience in coordinating deliverables through a global delivery model using Agile & waterfall methodologies.

● Creating Data MAPPING documents based on the Client’s requirement. Beginner’s experience on Hadoop Hive database and worked on

extracting data into Netezza.

● Created Netezza SQL scripts to test the table loaded correctly.

● Providing support to business users for resolving technical issues, resolving data related issues, and providing tool-based trainings for users.

● Hands on experience using AWS Services Subnets EC2, S3, CloudFront, SNS, SQS, RDS, IAM, CloudWatch and CloudFormation focusing on high

availability.

● Staging, Facts and dimensions created in SQL DB to store data from IMDB, Critic sites, Personal Catalogs.

Liberty Mutual - Boston, MA

Duration: January 2017 – December 2018

Title: ETL Informatica Developer

Roles & Responsibilities:

● Developed ETL programs using Informatica to implement the business requirements.

● Communicated with business customers to discuss the issues and requirements.

● Created shell scripts to fine tune the ETL flow of the Informatica workflows.

● Used Informatica file watch events to pole the FTP sites for the external mainframe files.

● Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over

the network.

● Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.

● Used debugger in identifying bugs in existing mappings by analysing data flow, evaluating transformations.

● Effectively worked on Onsite and Offshore work model.

● Pre and post session assignment variables were used to pass the variable values from one session to other.

● Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to

schedule jobs.

● Reviewed and analysed functional requirements, mapping documents, problem solving and trouble shooting.

● Performed unit testing at various levels of the ETL and actively involved in team code reviews.

● Identified problems in existing production data and developed one-time scripts to correct them.

Contact this candidate