SUMMARY:

• 8 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing using Informatica Power Center and Power Exchange.
• Experience in various phases of data warehouse development lifecycle, including gathering requirements to design, development, testing
• Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers
• Extensively worked with Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer and Teradata SQL Assistant.
• Wrote, tested and implemented Teradata Fast load, Multi load and Bteq scripts, DML and DDL.
• Experience in Creating the Data Mart using the Flat file sources
• Experience in implementing the complex business rules by re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings
• Expertise in Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data like Flat Files, XML Files, Oracle, DB2, SQL Server into Data Warehouse/Data Marts using Informatica.
• Involved in identifying the bottle necks and performance tuning of Informatica Mappings, Sessions.
• Excellent problem solving skills with strong technical background, quick learner and excellent team player with great interpersonal skills and ability to meet tight deadlines under high pressure.
• Created and updated the job schedules as and when new jobs were added and dependencies were updated in the scheduling tool
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 8.x/7.x/6. x.
• Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
• Good communication skills, technical and professional client interaction skills, self-motivated, quick learner and team player.

TECHNICAL SKILLS:

Operating System: UNIX, Windows NT, Windows Server 2008 R2

Development: PL/SQL, UNIX shell script, Import/Export.

Tools: TOAD, Oracle SQL Developer, Visio

Databases: Oracle 11g/10g/9i/8i/7.x, Teradata V2R6/R12/R13, DB2 and Green Plum, Netezza, MS SQL 2008/2005/2000

Reporting Tools: Business Objects, Tableau, micro strategy

ETL Tools: Informatica 5.x/6.x/7.x/8.x and 9.x (Repository Manager, Designer, Workflow Manger).

Technologies/Methodologies: OLAP, OLTP, Tidal, Autosys, Gap Analysis, Kimball methodologies

PROFESSIONAL EXPERIENCE:

Confidential, Miamisburg, OH

Sr. Informatica Developer

Roles and Responsibilities:

• Responsible for requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Responsible for documenting the requirements, translating the requirements into system solutions and developing the implementation plan as per the schedule.
• Active involvement in development for the Migration of DWH in Mortgage domain from Informatica 9.5.1 (legacy) to Informatica 9.6.1 (GFB).
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, SQL server and flat files).
• Used various transformations like the Lookup, Expression, Update strategy, Filter, Router, Joiner, Source Qualifier, etc.
• Involved in requirements gathering and design of data warehouse to integrate data from various source systems.
• Performed unit testing of SCD type 2 mappings as well as the Truncate and Load mappings.
• Created various Session/Mapping parameters and parameter files.
• Wrote complex SQL procedures to insert the records of the created parameters for a respective workflow, into the control tables.
• Created packages to promote the code developed into other environments using Harvest.
• Documented Informatica mappings in Excel spread sheet.
• Worked on various kinds of relational sources and targets like the Oracle, SQL Server and also the file sources.
• Involved in Modify the dimensional model, database structure, and ETL jobs to support upcoming project (lending transformation) changes.
• Involved in leveraging the conformed dimensions.
• Involved in creating data feed to outside vendors using ETL jobs.
• Involved in development work of various enhancements to support LT project.
• Re-created the workflows from the legacy system to the new GFB system and tested them and fixed the errors.
• Involved in the GFB standardization.
• Co-ordinated with the offshore team for testing the various workflows as part of GFB standardization process.
• Performed unit testing on the code developed and wrote the various test cases.
• Created the basic UNIX shell scripts to relate the Informatica sessions and the records inserted into the control tables for the session parameters.

Environment: Informatica 9.5/9.6, Power exchange 9.5/9.6 Oracle, DB2, SQL Server databases, Mainframe (Power Center), IBM MQSeries, MSM, Hyperion Essbase, SAS, Web Services, Web Methods, PeopleSoft and Siebel. Red Hat Enterprise Linux 6.5.

Confidential, Madison, WI

Informatica Developer

Roles and Responsibilities:

• Responsible for requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Responsible for documenting the requirements, translating the requirements into system solutions and developing the implementation plan as per the schedule.
• Providing the impact analysis for the new requirements, created Source to Target Mapping Specification Document.
• Participated in business requirement review meetings with BA’s, Solution Architect and users.
• Involved in developing complex Informatica mappings using web services, SAOPUI tool, WSDL FILES and transformations Source Qualifier, Expression, Look-up, Router, web consumer transformation XML parser transformation
• Worked in Informatica B2B Data Transformation.
• Migrate all open and closed cases history and its reference data to the CASD platform (web based application) using Web service endpoints.
• Imported Metadata from Teradata tables.
• Prepared BTEQ scripts to load data from Preserve area to Staging area.
• Extensively worked on Teradata SQL Assistant querying Teradata Preserve/staging tables in different schemas.
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts.
• Creation of job sequences and scheduling them to automate the ETL process.
• Involved in developing mappings to load data from oracle source database to the web based application using web service hub.
• Involved in creating web service hub and develop mapping using web service hub
• Involved in troubleshooting the load failures and Performance tuning by determining bottlenecks in sources, mappings and sessions
• Worked with complex SQL queries to test the data generated by the ETL process against the target database used SOAPUI tool to import project WSDL files and XMLs to validate mapping
• Completed documentation of database structures and processer used to move data in and out of the database for future development and explanation of database
• Completed documentation of database structures and processer used to move data in and out of the database for future development and explanation of database.
• Involved in performance tuning for source, target, mappings, sessions and server.

Environment: Informatica 9.5/9.6, Power exchange 9.5/9.6 Oracle 11g, Teradata V2R13, SoapUI-4.5, winsql 9.0, Tidal, Micro strategy, Netezza, Teradata.

Confidential, Rockville, MD

ETL Developer

Roles and Responsibilities :

• Analyzed source and target data warehouses and data mart data model for migration
• Responsible for requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Responsible for documenting the requirements, translating the requirements into system solutions and developing the implementation plan as per the schedule.
• Providing the impact analysis for the new requirements, created Source to Target Mapping Specification Document.
• Involved in complete SDLC with data modeling - form logical, physical and conceptual data model. Extracted data from various heterogeneous sources like DB2, Oracle, SQL Server, Flat files and COBOL files.
• Worked with Power Center tools like Designer, Workflow Manager, Task Developer, Workflow Monitor and Repository Manager.
• Extensively used various active and passive transformations.
• Defined the process to follow for that other project team members.
• Completed documentation of database structures and processer used to move data in and out of the database for future development and explanation of database
• Responsible for Unit Testing of mappings and workflows.
• Worked on Slowly Changing Dimensions Mappings of Type I, II and III.
• Involved in performance tuning for source, target, mappings, sessions and server.

Environment: Informatica Power Center 9.1/8.6, Oracle, Windows NT and UNIX.

Confidential, Schaumburg, IL

Informatica Developer

Roles and Responsibilities :

• Interacted with the client and with the stakeholders for the requirements gathering and preparing the functional specifications.
• Worked on end-to-end application support, starting from Analysis, Development, Testing and Production Support.
• Interacted directly with various stakeholders for quicker resolution on various issues.
• Used Informatica Power Center 8.6 for creating the required mappings, sessions and workflows. Extensively worked on tuning and thereby improving the load time.
• Involved in creating oracle stored procedures, functions and triggers.
• Created test cases for different test requirements. Worked on Informatica Data Analyzer for creating various reports, which helped the end users in analyzing the data.
• Worked on UNIX for moving the parameter files and to connect with DB2 data bases.
• Extensively used Quality Center for designing the test cases and to provide the associated test results. Involved in Performance tuning of various mappings and sessions to increase the performance.

Environment: Informatica Power Center 8.6, Informatica power exchange 7.1, Oracle 10g, UNIX, Windows NT, Remedy and Clear Quest (as ticketing tools).

Confidential, Atlanta, GA

Jr Informatica Developer

Roles and Responsibilities:

• Gathered and documented business and functional requirements
• Created design documents and technical specifications.
• Involved in production nightly load cycle monitoring
• Taking care of implementations and production validation after every release from IDC
• Participating in data mart audits and figuring out the issues if there are any
• Analyzing the defects identified in production and fixing them
• Involved in MCR works from designing to till implementation
• Involved in developing new mappings and workflows
• Tuning Informatica Jobs which are taking hours to run in production cycle and causing delay in deliverables. Supporting end user tickets to answer user queries
• Involved unit testing of defects and MCR works. Involved in UAT.

Environment: Informatica Power Center 8.6, Oracle 10g, UNIX, Windows NT.