SUMMARY

• 7+ Years of IT experience in analysis, application design, development and testing in client/server applications.
• Experienced in extracting, transforming and loading the data from different sources using Informatica ETL tool on Windows/Unix environment.
• Extensively used Informatica Power Center 9x/8x/7x/6x for ETL (Extraction Transformation and Loading) of data from multiple source database systems.
• Strong experience of Informatica Repository Manager, Workflow Manager and Designer.
• Highly skilled in designing the Mappings & Mapplets, configuring the Worklets, Servers, Connections and Scheduling the Workflows with Worklets and Sessions.
• Worked on various transformations like Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy, Sequence Generator, Source Qualifier and Stored Procedure transformations Sorter transformations etc.
• Expertise in creating Mappings, Mapplets and reusable transformations.
• Data modeling experience using Dimensional Data modeling, Star Schema/Snowflake Schema modeling, Fact & Dimension tables, Physical &logical data modeling using ERWIN.
• Worked extensively in data modeling, normalization, database design, data loading, data retrieval and modification.
• Hands on experience in handling large volume of data in production environment.
• Worked with different data source like Flat Files, XML Files and Databases.
• Proficient in Oracle Tools and Utilities such as SQL Plus, SQL*Loader, Erwin.
• Possesses excellent communication skills, analytical skills, interpersonal skills and problem - solving skills with accent teamwork.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x

Databases: Oracle10g/9i/8i/8.x/7.3, SQLServer7.5/2000, MYSQL, Sybase, DB2,MSAccess97/2000

Data Modeling: Erwin 4.1, Rational Rose, MS Visio

Languages: SQL, PL/SQL, NZSQL, NZLOAD C, C++, Shell Scripting, HTML, XML, VB Script, Java script

Tools: SQL*Plus, SQL*Loader, Import & Export utility, TOAD, Harvest Change Manager, Visual Source Safe, Erwin, Test Director, MS Office suite (MS Word, MS Excel, MS PowerPoint, MS Access)

Operating Systems: Windows XP/2000/NT/98, DOS 6.0/3.0, Unix (AIX and SUN SOLARIS), Linux

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

Sr. Informatica Developer

Responsibilities:

• Able to handle multiple assignments, participated in full data transformation process, gathered business requirements, analyze requirements, design solution, development, unit testing and production support.
• Participated in the BRD and TRD walkthrough sessions, interact with the Business and System Analyst team in understanding the requirements to document the Technical Design Document (TDD).
• Conducted Technical Design Document (TDD) walkthrough sessions with Business, Development and Testing teams as a presenter.
• Created complex mappings in Power Center Designer using Lookup, Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Joiner, XML Source Qualifier and Stored Procedure transformations.
• Implementing logical and physical data modeling with STAR and SNOWFLAKE techniques using Erwin in Data warehouse as well as in Data Mart.
• Developed highly optimized SQL queries and PL/SQL Stored Procedures and Functions.
• Interacting with Project Manager and translate the requirements, business rules into technical requirements
• Developed a number of complex Informatica Mappings and Mapplets to transform data as per business rules.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Workflow Manager to create and run the sessions for loading the data using the mappings created.
• Involved in Unit level testing and Assembly testing of target data and analyzed the test results.
• Document ETL Run Book as part of my deliverable for every task assigned.
• Able to handle and resolve the production issues, make necessary code changes as per the enhancement request from the business.
• Participated in code reviews meetings & used to discuss software solutions and development issues.

Environment: Informatica Powercenter 9.1, DB2, SQL Server, Unix, XML, Web Services, Ms Visio, Share Point 2010, Siebel, HIPAA, NASCO, NMS, E1(Evolution 1), CDH, HRA and HSA.

Confidential, Buffalo, NY

Sr. Informatica Developer

Responsibilities:

• Interacted with Project Manager and translate the requirements, business rules into technical requirements.
• Participated in all phases of full life cycle development, maintenance of systems, including requirements analysis, software design, software implementation, testing and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer, Transformation Developer, Repository Manager and Workflow Manager which includes Task Developer, Worklet and Workflow Designer
• Developed Informatica Mappings and PL/SQL stored procedures for loading Facts and Dimension Tables to Enterprise Data Warehouse (EDW) in Oracle 10g
• Created Mapplets, Transformations using Mapplets Designer, Transformation Developer for standardization of the data as per business requirement
• Writing PL/SQL Stored procedures, functions and packages using TOAD.
• Involved in performance tuning and developed optimized queries for improving performance of the Extract Transform and Load (ETL) process
• Developed UNIX Shell scripts for the automation of ETL process, execute batch process and created E-Mail notification tasks using post-session scripts for notifying the results of the runs
• Worked closely with other team members and client representatives to meet the system requirements and business objectives of the customer.
• Excellent team player with problem solving and troubleshooting capabilities.
• Responsible for attending daily QC defects tracking status meeting.
• Responsible for attend weekly modification meeting and environmental schedule release meetings.

Environment: Informatica Powercenter 7.1.1/8.1.1 , DB2, Health Rules, PowerHMS, ERWIN, XML, Web Services, SQL, Ms Visio, Share Point 2010, HIPAA and Agile methodology.

Confidential, Nashville, TN

Sr. Informatica Developer

Responsibilities:

• Used Informatica tools Designer, Workflow Manager and Workflow Monitor to extract, transform and load the data in to target tables.
• Updated technical specs according to the requirement changes
• In the first phase getting the data from OLTP and pulling into Operational Data Source (ODS or Staging Area), in the second phase pulling the data from ODS to Dimensional Modeling according to the user requirement. From the first and second phase, reports will be build using OLAP tools
• Developed complex mappings using Slowly changing Dimensions Concept
• Used mapping parameter/variable for Incremental Loading
• Written UNIX shell Scripts for getting the data from all systems to Data Warehousing system.
• Implemented source-target mappings, developing migration techniques & processes for multiple source platforms.
• Used various transformations like Source Qualifier, Expression, Lookup (connected and un connected), Router, Update Strategy etc. to develop the mappings
• Used post session commands for sending email to get the status of the session
• Involved in Unit Testing and write unit test cases for mappings
• Scheduled and monitored the sessions

Environment: Informatica Powercenter7.1/8.1, SQLSERVER, PL/SQL, UNIX Shell Scripting, Erwin4.0, JAVA, Windows 2000 Server.

Confidential

Sr. Informatica Developer

Responsibilities:

• Created Mapplets, Transformations using Mapplet Designer, Transformation Developer for standardization of the data as per business requirement
• Developed Mappings between source systems and warehouse components.
• Created Monitored and running the Sessions, Workflows and Worklets using Workflow Manager and Workflow Monitor to load the data into the Data warehouse.
• Developed PL/SQL stored Procedures, Functions and Triggers.
• Extensively worked in the Performance tuning of the programs, ETL Procedures and processes and tune database queries to improve performance for SQL queries.
• Involved in Unit level testing

Environment: Informatica Powercenter 6.1, Oracle 10g/9i,Sql, PL/SQL, UNIX, TOAD, Unix, C#, ASP.NET and Windows XP.