SUMMARY

• 7+ years of IT Experience in analysis, design, development, implementation, troubleshooting and Maintenance of Data Mart / Data Warehouse applications using ETL tool Informatica power center 9.x/8.x (9.1/8.6/8.1/7.1 )
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, Db2, Netezza,Teradata and Flat files.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Experience in database programming inPL/SQL(Stored Procedures, Triggers and Packages).
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used shouts for notifying the alerts after successful completion.
• Working Experience in analyzing and improving performance of database code.
• Analyzed various production issues and provided solutions for different recurring failures.
• Experience in working with COBOL files, XML, and Flat Files.
• Well versed in Unix Shell Scripting. Hands on exposure on UNIX environment and experience in using third party scheduling tools like AutoSys.
• Effective knowledge to prioritize and run different tasks in a high - pressure environment.
• Experience with Financial, Marketing, Healthcare and Telecommunication Industries’ Data warehousing practices.
• Extensive knowledge with Dimensional Data Modeling, Star Schema/Snowflakes Schema, Fact and Dimension tables.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / De-normalization strategies.
• Experience in implementing update strategies and incremental loads.
• Usage of Informatica mapping variables/parameters and session variables.
• Strong in UNIX Shell scripting. Scripts using PMCMD utility and scheduled ETL load using utilities like Control-M and Autosys.
• Experience with Data modeling and Reporting tools like Erwin 4.X, OBIEE 10.1.3x., Cognos Report Net 1.1, and Business Objects 6.5.
• Expertise in creating Relational data model by defining data for each attributes and associated the same using E-R diagrams.
• Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by Application Users, Business System Analysts.
• Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6,Power Exchange/CDC.

Data Quality: Informatica Data Quality (IDQ Developer) 9.1/8.6, Informatica Data AnalystInformatica Data Explorer (IDE).

Databases: MS SQL Server 2005/2008, Oracle 9i /10g/11g, Netezza, DB2 and SQL Server .

Client Side Skills: SQL, PL/SQL, UNIX shell scripting, XML.

Tools: Toad, SQL developer, MS Project, MS Visio, Putty, Control-m (Scheduler)Configuration tools like Clear Case, FileZilla (for ftp operations),COGNOS Batch analyzer, Crimson editor, Visio, AutoSys,Tidal,TOAD,Erwin data modeler.

Methodologies: Data Modeling Logical/Physical, Star/Snowflake Schema, FACT & Dimension Tables, ETL, Software Development Life Cycle (SDLC).

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using the PowerCenter.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataMart.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Developed Slowly Changing Dimension for Types 1 SCD, Type 2 SCD with Change Data Capture(CDC)
• Used Informatics Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Written, Queries to retrieve data from DWH and implemented in DM.
• Written SQL Queries to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.

Environment: Informatica Power Center 9.5/ 9.1.2/8.6 , SQL Server 2005/2000, Oracle 11g, SQL, PL/SQL, UNIX Shell Scripts, Cognos, Autosys job scheduler, Mercury Quality Center

Confidential, Smithfield,RI

Informatica Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Extracted data from oracle database, different data sources and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, and Union.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.
• Improved the performance of the Informatica code using different session partitioning techniques.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.

Environment: Informatica Power Center 9.1/Power Exchange, Tivoli, Oracle 11g,PLSQL, DB2,Netezza, MS SQL Server 2012/2008 r2 2005,SQL* PLUS,MS Excel, UNIX(AIX), UNIX Shell, Autosys,TOAD

Confidential, NJ

Informatica Developer

Responsibilities:

• Extracted data from oracle database, different data sources and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, and Union.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Mappings, Mapplets and Sessions for data loads and data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Powercenter.
• Involving in extracting the data from Oracle and Flat files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Created parameters and variables for the reusable sessions.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Experience in analyzing business specification documents, developing test plans defining test cases, developing and XML test scripts.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica PowerCenter 8.6.1/9.1,UNIX, PLSQL,Oracle,SQL* PLUS, SQL SERVER 2008 R2, Erwin Data modeler,TOAD, MS Excel 2007, control-M

Confidential Chandler, AZ

Informatica Developer

Responsibilities:

• Development of ETL using Informatica.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Designed and developed the logical and physical data models (star schema) using of all current and future development databases across all products and application branches.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application. Made use of Post-Session success and Post-Session failure commands in the session task to execute scripts needed for cleanup and update purposes.
• Developed various mapping and tuning using Oracle and SQL*Plus in the ETL process.
• Involved in creating test plans, test cases to unit test the mappings, sessions and workflows.
• Involved in migrating the ETL application from development environment to testing environment.
• Created complex mappings and mapplets and Worked on different tasks like sessions, events raise, event wait, decision, e-mail, and command.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.

Environment: Informatica PowerCenter 8.6.1,, Oracle 10g, UNIX, PLSQL, SQL* PLUS, SQL SERVER 2008 R2, TOAD,Tidal, MS Excel 2007.

Confidential

Informatica Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
• Prepared technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution
• Worked in legacy code to analyze problems, confirm requirements, and create designs, code and testing.
• Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.
• Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters.
• Used the Workflow Manager to create Workflows, Worklets and Tasks.
• Wrote complex SQL queries and demonstrated ability to collaborate with other developers during Design, Development, and Testing.
• Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes.
• Used problem solving skills and quickly understood relationships between data with little documentation or guidance.

Environment: Informatica Power Center 8.6,Oracle 10 g, Flat Files, PL/SQL, DB2, Quest Central for DB2, Business objects 6.5, Talend, MS Visio,Windows 2000, UNIX,Tidal,Autosys .