PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Texas

Informatica Developer

Responsibilities:

• Designing/Developing Informatica processes (mappings, mapplets, sessions, workflows and worklets) to load staging targets and then transforming and loading staging data to a Regional Application Users database
• Creating Source to Target mapping document
• Unit testing
• Documentation

Confidential. Dayton, Ohio

Informatica Developer

Responsibilities:

• Designing/Developing process flows, Informatica processes (mappings, mapplets, sessions, workflows and worklets) to load staging targets for data profiling and then transforming and loading staging data to an ODS
• Creating Source to Target mapping document
• Unit testing
• Documentation

Confidential, Dayton, Ohio M

Informatica Developer

Responsibilities:

• Member of the Informatica development team working as an ETL developer using Informatica PowerCenter 9.5, 9.6.1, Teradata 14.0, SQL Server, Neteeza, DataStage
• Developed Informatica mappings, sessions, workflows in support of a Healthcare analytics project, some of this work included converting DataStage code to Informatica.

Confidential, Dayton, Ohio

Informatica Developer

Responsibilities:

• Worked with Business/Data Analysts in development of Informatica processes to meet business requirements
• Unit Testing
• Assisting Integration testing team
• Creation of Software Implementation documentation for Integration, Certification and Production migration
• Worked on major enhancement of Scion Dental Claims interface which included modifications to existing Informatica objects as well as development of new

Confidential, Miamisburg, Ohio

Informatica Developer

Responsibilities:

• Member of the ETL development team working with Informatica PowerCenter 8.6, 9.5,Oracle and SQL Server databases;
• Responsible for the development, enhancement and testing of Informatica processes.
• Worked with BA to solidify business requirements
• Created/Modified/Unit Tested Informatica mappings, sessions and workflows to meet requirements for enhancements to existing systems
• Created migration package for the QA testing team

Confidential, Fairborn, Ohio

Informatica Developer

Responsibilities:

• Worked on the Requirements Traceability Matrix
• Worked on the Source to Target Matrix
• Created/modified Source to Target mapping
• Developed, unit tested and documented Informatica workflows
• Participated in UAT

Confidential, Tampa, Florida

Informatica Developer

Responsibilities:

• Responsible for the modification and testing of Informatica processes used to load Investor Reporting Data Warehouse.
• My responsibilities included the following;
• Modified and tested Informatica mappings, sessions and workflows based on pre - defined requirements and business rules.
• Monitor, identify and correct production issues related to Informatica workflow defects.

Confidential, Miami Lakes, Florida

Informatica Developer

Responsibilities:

• Member of the Enterprise Information Management team working primarily in UNIX environment using Informatica PowerCenter 9.1.0, Oracle 10g and Toad.
• Responsible for the modification and testing of Informatica processes used to identify Residential and Commercial account defects.
• I was also a member of the Production Support Team.
• Modified and tested Informatica mappings, sessions and workflows based on pre-defined requirements and business rules.
• Monitor, identify and correct production issues related to Informatica, database and UNIX scripts.

Confidential, Charlotte, North Carolina

Informatica PowerCenter Developer

Responsibilities:

• Responsible for the design, construction, enhancement and testing of Informatica processes used to populate the Consolidated Mortgage Data Mart.
• Requirements review and analysis.
• Detail design documentation review for Informatica mappings, sessions and workflows.
• Construction of Informatica mappings, sessions and workflows.
• DDL creation and submission to the DBA
• Work with Business Analyst through QA testing process
• Ensure all objects deployed correctly to Production
• Member of production support rotation

Confidential, Dallas, Texas

Informatica PowerCenter Developer

Responsibilities:

• Requirements gathering.
• Detail design documentation for Informatica mappings, sessions and workflows.
• Construction of Informatica mappings, sessions and workflows.
• Deployment to QA.

Confidential, Atlanta, Georgia

Informatica PowerCenter Developer

Responsibilities:

• Detail design documentation for multiple Informatica mappings, mapplets, sessions and workflows that were slated to populate the corporate ODS and data warehouse.
• Collaborated with and assisted offshore team with detail design documentation.
• Coding of multiple Informatica mappings, mapplets, sessions and workflows. The mappings and mapplets were comprised of the following Informatica transformations;
• Source Qualifier, Expression, Aggregator, Lookup, Normalizer, Filter, Router, Update Strategy, Input and Output.
• Construction of parameter file. We used session level parameters.
• Participated in code reviews with the Duke Energy Informatica Competency Center.
• Responsible for unit testing of each Informatica process.
• Participated in System Integration Testing which involved collaboration with multiple teams.
• Responsible for the migration documentation submitted to the administrator to get the Informatica objects migrated from Development to Test to QA to Production.
• Worked with the team to develop, test and implement an automated scheduling strategy. We used the ESP Cybermation scheduling software.
• Responsible for the production implementation all Informatica processes.
• Provided production monitoring and support thirty days post implementation.
• Created knowledge transfer documentation for the client production support team.

Confidential, Cincinnati, Ohio

Informatica Developer

Responsibilities:

• Worked primarily in a Windows environment using Informatica 7.1.3, 8.1.1, Oracle 9i, SQLServer 2000.
• Responsible for the creation, testing, scheduling, and implementation of Informatica processes to process clinical drug information
• Responsible for supporting production Informatica processes

Confidential, Raleigh, NC

Informatica Developer

Responsibilities:

• Worked primarily in a Sun UNIX environment using Informatica 6.2 and 7.1.3, Oracle 8i, 9i, Toad, Korn shell scripting, Teradata, AFT.
• Responsible for creating, testing, scheduling, implementing, and supporting Informatica processes created from specifications provided by the customer
• Creation and modification of Korn Shell scripts executed from Informatica objects
• Source data comprised of Oracle tables and flat files
• Targets comprised of Teradata and flat files
• Workflows comprised of Sessions, Command Tasks, Links, and Worklets