Informatica/ETL Developer Resume Westlake, TX - Hire IT People

SUMMARY:

1 year of Information Technology experience as an Informatica Developer in Data warehousing. Data analysis, Application Design, Development, Implementation, Testing, Maintenance and Documentation.
Experience in Data Warehouse applications using Informatica, Oracle, MS SQL server, Windows and UNIX platforms and involved in full development life cycle of Data Warehousing.
Well experienced with ETL tool Informatica power center 10.1 in designing and developing Mappings, Workflows, Transformations, and Sessions.
Extensively worked with various Relational and non - relational sources and target systems including SQL Server, Oracle and Flat files
Experience in integration of various data sources like Oracle, SQL server and non-relational sources like flat files into staging area.
Involved in unit testing and to make sure validate source against target data.
Extensively used Scheduling tools like Tidal in ETL Jobs.
Good Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
Worked in a team for ETL and data integration in developing ETL mappings and scripts, transformations and all aspects of SDLC that includes requirements gathering, analysis and development.
Expertise with Informatica Debugger to understand the errors in mappings and used the Expression editor to evaluate complex expressions and look at the transformed data to solve mapping issues.

TECHNICAL SKILLS:

ETL TOOLS: Informatica Power Center 10.x/ 9.x(Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor)

DATABASES: SQL, Oracle, MS Sql Server

SCHEDULING TOOLS: Tidal

OPERATING SYSTEMS: Windows XP Professional, Windows 10, Windows server 2012, UNIX- OS

PROFESSIONAL EXPERIENCE:

Informatica/ETL Developer

Confidential, Westlake, TX

Responsibilities:

Worked with Analyst’s to understand the requirements and source to target mapping.
To develop the Informatica code during the build phase.
Designed, developed, implemented ETL process to extract, transform, and load (ETL) data from flat files and various source systems and load into Data Mart using the Informatica Power Center 10.1.
Worked on Oracle SQL Developer to write queries and validate source data against target data.
Developed mappings to extract data from SQL Server, Oracle and Flat files and load into Oracle using the Power Center.
Worked extensively on different types of transformations like Source qualifier, Expression, Aggregator, Router, Filter, Update strategy, lookup and Sorter.
Worked on creating sessions, workflows in workflow manager to load data from different Sources to Targets.
To unit test the code and to support user acceptance testing for each iteration of the project.
To do the code migrations across the DEV, QA, UAT environments for each iteration.
Implemented Type1/2 Slowly Changing Dimensions to maintain the historical data in DataMart as per the business requirements.
Created Tidal jobs to schedule Informatica workflows in a batch.

Environment: Informatica Power center 10.1, Oracle, MS SQL server, SQL Loader, Tidal, UNIX Shell Scripts.