SUMMARY

• 8 years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design, Development, Testing, Implementation and Support of various Data Warehousing and Enterprise applications.
• 5 years of focused experience as an ETL Developer using Informatica PowerCenter 9.5.1/9.1/8.6/8.1 .
• Expertise with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience with data extraction, transformation and loading from different data sources into a Staging, Data Warehouse & Data Marts using Informatica.
• Data modeling experience using Dimensional Data Modeling using Star schema, Fact & Dimensions tables, Physical & logical data modeling using development tool ERWIN 7.3 for forward/reverse engineering.
• Good Understanding of Data Warehousing concepts like Star Schema and Snowflake Schema, Data Marts, Facts and Dimensions, OLTP and OLAP systems, Normalization, Kimball and Inmon Methodology.
• Knowledge in administration activities like creating services, folders, assigning privileges to users and groups using the PowerCenter Administration Console.
• Performance Tuning, identifying and resolving performance bottlenecks at various levels such as sources, targets, mapping, sessions and SQL.
• Experience in automation and scheduling of Informatica jobs using Informatica Scheduler, CRONTAB and PMCMD.
• Experience in Data Profiling and analysis using Informatica Data Quality (IDQ) 9.1.
• Good working skills in writing PL/SQL, SQL, stored procedures, functions in Oracle 11g/10g and optimizing the SQL to improve performance.
• Written UNIX Shell scripts to run Informatica jobs and to automate the file routines.
• Working experience in database client tools like TOAD, SQL plus, SQL developer to access/create/change database objects and creating scripts.
• Team player with excellent interpersonal skills and the ability to work well with co - workers.
• Exceptional ability to learn and master new technologies and work under tight deadline conditions.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.1/9.1/8.6/8.1 , Informatica Designer, Workflow Manager, Workflow Monitor

Data Modeling: Dimensional Data Modeling, Star Schema, Snow Flake Schema, Fact and Dimension Tables, Physical and Logical Data Modeling, Erwin 7.3

RDBMS: Oracle 11g/10g, MS SQL Server 2008, MS Access 2013/2010

Programming: UNIX Shell Scripting, SQL, PL/SQL, Toad, SQL Developer 3.2/4.0

Operating system: Windows XP, UNIX

Others: Informatica Data Quality 9.1, Informatica Scheduler, PMCMD, CRONTAB

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

ETL Developer

Responsibilities:

• Involved in gathering and analyzing business requirements to prepare technical rules.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Used the Informatica Power Center Designer to stage source data, perform transformation, and map data to load into target tables.
• Worked on Informatica Power Center - Source Analyzer, Mapping Designer, Target designer, Mapplets, and Reusable Transformations.
• Created logical and physical data models using Erwin.
• Extracting data from Flat Files and relational transaction systems into the Staging area using Informatica Power Center.
• Designed reusable components such as reusable transformations, Mapplets, user-defined functions and reusable objects sources and targets (shared folder) for ETL process.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Debugged Informatica mappings tested Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Performed performance tuning to improve Data Extraction, Data process and Load time.
• Worked with Mapping Variables at mapping level for incremental load.
• Implemented Type I and Type II Slowly Changing Dimensions.
• Tuned the Mappings for Optimum Performance by identifying the bottlenecks at source, target, mapping and session level.
• Used debugger to identify the bugs and logical inconsistency.
• Developed the test scripts using SQL for the unit testing.
• Tested and validated the data on target system and fixed the error codes on target data.
• Followed Scrum Agile Methodology with a Confidential length.

Environment: Informatica Power Center 9.5.1, Oracle 11G, SQL Developer 4.0, Windows XP, Linux Shell Scripting, Erwin 7.3, Excel 2013

Confidential, Lincoln, RI

ETL Developer

Responsibilities:

• Extensively involved with business team for analyzing the source systems data and building the design documents.
• Extracted data from SQL Server and flat files into the Staging area and then loaded into Oracle Data Mart using Informatica Power Center 8.6.
• Used various transformations including Source Qualifier, Filter, Router, Sorter, Joiner, Lookup, Sequence Generator and Update Strategy to apply the business logic during the mapping development.
• Defined Target Load Order Plan for loading data into target Tables.
• Widely used Shared folders, project folders (Non-Shared folders) and shortcuts to maintain integrity between Development, Test and Production environments.
• Created Pre/Post Session commands at the session level.
• Used different tasks such as Session, Assignment, Command, Decision, Timer and Email task.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Involved in performance tuning of source, target, mapping, session, and database level.
• Used Informatica IDQ 9.1 to complete initial data profiling and matching and/or removing duplicate data.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.

Environment: Informatica Power Center 8.6, IDQ 9.1, Oracle 11g, SQL Developer 3.2, PL/SQL, SQL Server 2008(source), Excel 2013.

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Extracted data from heterogeneous data sources. Designed mappings from Excel/Flat files to Oracle using Informatica Power Center 8.1.
• Analyzed Mapping, Session, Source, Target and System Bottlenecks to improve and tuned Performance of various ETL Jobs.
• Developed mapping in Informatica using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Developed Informatica Jobs to load data into the Staging, Fact, and Dimension Tables.
• Responsible for scheduling jobs using UNIX CRONTAB for daily, weekly and monthly loading of Data into the Oracle Data Mart.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
• Used deployment group to move Informatica Objects from DEV to TEST and PROD
• Used stored procedures for disabling and enabling indexes for efficient Data Load and also for populating audit tables
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used different tasks such as Session, Assignment, Command, Decision, Timer, Email, Event-Raise, Event-wait and Control

Environment: Informatica Power Center 8.1, Oracle 11g, Linux Shell Scripting, SQL Developer 3.0, Windows 7.0, PL/SQL, EXCEL 2010.

Confidential, Overland Park, KS

PL/SQL Developer

Responsibilities:

• Analyzed the requirements and prepare design documents
• Developed PL/SQL code using the technical and functional specifications
• Created Oracle objects like tables, views and synonyms
• Created Constraints and Indexes on the database objects
• Developed stored procedures, functions, and triggers for the application
• Designed the Integration test plan and verify the testing strategy with the customer support team
• Performed the tests on the newly coded procedures and documenting the same

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, Windows 2007

Confidential

QA Analyst

Responsibilities:

• Analyzed business requirements and technical specification for developing Test case and Test plan.
• Involved in the preparation of Test Scenarios, Test cases and scripts for different modules in the system.
• Performed functional and regression testing on different modules to ensure the quality of software.
• Performed manual testing for checking the functionality and executed the Test cases in Quality Center.
• Proactive in recording Test progress, results and defects and coordinated with development team to resolve the issue.
• Performed Backend testing by writing SQL Queries for different set of Input parameters to ensure the data integrity.
• Provided Daily Status to team on Test Scripts run, Number of Scripts failed/Passed and Open Defect Priorities.
• Reported and assigned the defects to the developer through HP Quality center.

Environment: Manual Testing, HP QC, Oracle 10g, PL/SQL, Windows XP.