SUMMARY:

• 6 Years of Total IT experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations, Testing of Data warehousing and Database business systems.
• Proficiency in utilizing ETL tool Informatica Power Center 9.1/8.x/7.x for developing the Data warehouse loads with work experience focused in Data Integration as per client requirement.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Oracle, Flat Files (fixed width, delimited), DB2, SQL server, and Target databases Oracle, Teradata and Flat Files (fixed width, delimited).
• Having knowledge of Dimensional Modeling, Star and Snowflake schema.
• Extensive experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Performed Data Profiling and responsible for Business Analysis and Requirements Gathering.
• Created Oracle PL/SQL queries and Stored Procedures. Worked on data loads using Oracle PL/SQL and SQL *Loader from legacy systems and uploaded into Oracle.
• Created PL/SQL triggers. Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing. Writing PL/SQL code using the technical and functional specifications.
• Implemented Explain Plan and SQL Trace for improving the performance of SQL queries.
• Extensively worked with Oracle products, tools and utilities like SQL*Loader, PL/SQL, SQL*Plus. Experience in Oracle backend operations for creating stored procedures, indexes, triggers, materialized views, partitioned objects, and writing queries for efficient retrieval of data.
• Extensive Data Warehouse and OLTP experience using Informatica PowerCenter for designing and developing transformations, sessions and for scheduling and configuring jobs.
• Excellent knowledge in identifying performance bottlenecks and tuning the Mappings and Sessions by implementing various techniques like partitioning techniques. Knowledge on database languages such as SQL and PL/SQL which includes writing triggers, Stored Procedures, Functions and Views.
• Responsible for data analysis, requirements gathering, data profiling, traceability, Business Intelligence, business rules development, report analysis.
• Knowledge with Teradata SQL Assistant. Developed BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements. Tuned the existing BTEQ script to enhance performance.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Knowledge of working on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Excellent team player and self - starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x/8.x/7.x

Databases: Oracle (9i/10g/11g), Teradata V2R5/V2R3, MS-Access, DB2, MS SQL Server

OS: IBM AIX, Unix, Linux, MS-DOS, Windows.

Programming Skills: Shell Scripting, PL/SQL

DB Tools: SQL*PLUS, SQL*LOADER, TOAD, SQL Navigator

DM Tools: Visio, ER Studio, Analytix Mapping Manager V8.0, HP ALM 12.53

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Informatica ETL Developer, Data and Informatics/QA Lead

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Extensively work on the project related to the Medigap, CBIW, RELICC, Blue Rewards Formulary Enhancements, PCHM, Magellan, NCompass, TESIA Dental Provider, Collect Rebates, Drug Finance Guarantee and Unique Identifier.
• Worked with the database Oracle, MS SQL Server and Flat Files which involved the mapping from the Flat File to DA, DA to EDA, EDA to CBID STG and CBID STG to Stepwise which contain the historical load and incremental data.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Worked with Informatica Power Center Mapping Designer, Workflow Manager and Workflow Monitor.
• Extensively implemented Source Qualifier, Aggregator, Lookup, Expression, Router and Update Transformations.
• Extensively worked with Informatica Designer. Designed and developed Informatica mappings for data loads and data cleansing.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions in a detail design document.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based on commit interval.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Experience in installing and configuration of PowerCenter and Microsoft SQL Server.
• Debugging code, testing and validated data after processes are run in development/testing per business rules.
• Prepared unit test plans and maintained defect logs to resolve issues.
• Communicated with the Team to prepare unit test plans, to find solutions for the defects/issues and to share business knowledge.
• Worked with the QA team to determine the data validation and performed the data validating at the source and the target database level.
• Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Expensively worked on tuning the SQL query, store procedure, and creating the indexes to help in the performance of query.
• Involved in Unit, Integration, System, and Performance testing levels.
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Documented the ETL process and issues encountered during UAT and production support for ease of future maintenance.
• Extensively used TOAD and MS SQL Server to check if data is properly loaded into target systems by writing queries.
• Proficient on the HP ALM tools. Experience on uploading the test cases from the Excel ALM- Add In, creating folders in Test Plan, test set result in Test lab, creating defects and generating the ALM reports
• Worked on Mainframe to create JCL and ZMF Package to run the workflows in INT and Production environment.
• Implement Tortoise SVN tool create tags and maintained the versioning system for workflows, scripts and parameters on each environment.
• Conducted code reviews with my teammates before moving the code into QA and Production.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Experience on Serena Business Manager and One Stop tools to create an app id, DB connections and track the progress.
• Worked with the application such as Analytix Mapping Manager and Embarcadero Team Server to keep track of the latest mapping versions and Data model changes on the business requirement.

Environment: Informatica Power Center 9.6.1, Oracle 11g, Toad, SQL Navigator, MS SQL Server 2008, UNIX, Windows

Confidential, Pittsburgh, PA

Informatica ETL Developer

Responsibilities:

• Responsible for working with business analysis team, cognos team and .NET team to provide technical input.
• Responsible for generating design documents ETL standard specification documents based on functional requirements gathered in requirement analysis sessions.
• Responsible to migrate the data from I-series, Oracle and Teradata based on the requirement.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules.
• Extensively used all the features of Informatica including Designer, Workflow manager, Repository manager and workflow monitor.
• Created various Mappings using various Connected and Unconnected Transformations like source qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence generator, Update Strategy etc.
• Worked extensively on fixing invalid mappings, testing of stored procedures.
• Used parameter files to define values for parameters and variables used in mappings and sessions.
• Responsible for Unit testing and Integration testing of Informatica sessions.
• Responsible to modify the existing UNIX script, Teradata Script and Oracle Store Procedure.
• Scheduled Informatica workflows, UNIX script and Store procedure through Control - M scheduler.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Database development and ETL process in Oracle l0g and PSQL and UNIX scripting.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Informatica Data Quality (IDQ) was used to identify Data Duplication and understand the quality of data.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Worked with testers and participated in Unit, Integration, Regression and Performance testing of ETL applications.
• FTP between different environment using tools such as WINSCP.
• Responsible for loading and analyzing analytical data and historical data in Oracle and Teradata.
• Staging data to various environments with Fload, Mload and Tpump, SQL Loader, BTEQ and Toad.
• Wrote UNIX shell scripting the for the Control M jobs, SQL Loaders and Fload and Mload in Teradata.
• Responsible to migrate the script, maps and workflow from Dev to Production.
• Participated in deployment planning meetings to finalize deployment plan and to negotiate down times of other systems.
• Responsible for updating various business stake holders and other development teams about the status of ETL jobs and advising them in prioritization of debugging tasks.

Environment: Informatica Power Center 9.1, Teradata, Oracle, TOAD, UNIX shell scripting, Windows.

Confidential, Jersey City, NJ

Informatica ETL Developer

Responsibilities:

• Responsible for working with business analysis team during the requirements gathering sessions to provide technical input from ETL team stand point.
• Created Technical System Design documents, Low Level Design documents. Data validation from source to target load.
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Created dictionaries using Informatica Data Quality that was used to cleanse and standardize data.
• Extensively used all the features of Informatica including Designer, Workflow manager, Repository manager and workflow monitor.
• Created Sessions, Reusable Worklets and Workflows in workflow manager and Scheduled workflows and Sessions at specified frequency.
• Worked extensively on fixing invalid mappings, testing of stored procedures.
• Involved in performance tuning SQL and Informatica mappings/sessions by session partitioning techniques.
• Migrated Informatica objects (mappings/sessions/work lets/workflows) from the Dev to QA to Production Environments.
• Created Unit test case templates (standardized formats).
• Responsible for Unit testing and Integration testing of Informatica sessions.
• Extensively used TOAD to check if data is properly loaded into target systems by writing SQL Queries.
• Developed and modified Unix shell scripts to reset and run Informatica workflows using UNIX.
• Scheduled Informatica workflows using AUTOSYS scheduler.
• Captured data error records corrected and loaded into target system.
• Implemented Slowly Changing Dimensions.
• Extensively used the Versioning Tool Perforce for Informatica, UNIX and SQL Server.
• Used WinSCP tool for keeping the track of log files for the Run book.
• Participated in knowledge transfer sessions, Daily status meetings with off shore team to coordinate development effort.

Environment: Informatica Power Center 9.1, Teradata, Oracle, TOAD, UNIX shell scripting, Windows.