Data Integration Specialist Resume

SUMMARY:

Solutions - driven developer with a proven track record of developing mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
Software Development
Solutions Deployment
User Training & Support
Agile / Scrum
Coding & Scripting
Debugging & Troubleshooting

TECHNOLOGY SUMMARY:

Programming: Informatica, SQL, SSIS, Oracle, Crystal Reports, Business Objects, Visual Basic

Software: MS Office Suite (Access, Word, Excel, PowerPoint, Visio)

Systems: Windows (all)

PROFESSIONAL EXPERIENCE:

Confidential

Data Integration Specialist

Responsibilities:

Was chosen to be part of a dedicated Agile team to do Enterprise Reporting using the Data Warehouse.
Redesigned, developed, implemented and supported Confidential Confidential ’s Data Warehouse using Informatica - Cutting processing time down from 4 hours to 90 minutes.
Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
Maintained warehouse metadata, naming standards and warehouse standards for future application development.
Designed star and snowflakes schemas and ETL Processes.
Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files and Excel files to target SQL Server warehouse database.
Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.
Performed Unit Test for Informatica mappings and workflows in both development and test environments.

Confidential

Data Warehouse Developer

Responsibilities:

Designed, developed, implemented and supported Confidential Confidential ’s Data Warehouse using Microsoft SQL Server stored procedures.
Made several enhancements to the ETL for the Data Warehouse.

Confidential

Report Writer/ ETL Developer

Responsibilities:

Redesigned the DataMart’s ETL using SSIS - Cutting processing time down by 50%
Designed, developed, implemented and support Confidential Confidential ’s first DataMart using Microsoft SQL Server stored procedures.
Created 100 + financial reports based on DataMart with Crystal Reports.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship