PROFESSIONAL SUMMARY:

• Around 7+ years of experience in IT Industry involving in full life cycle development including requirement gathering, analysis, design, development, testing, implementation, maintenance and documentation of Data warehousing models using ETL tools.
• Over 5+ years of experience on Informatica Power center and also as Database developer and 2 year of Ab Initio experience with ETL, Data Mapping, Transformation and Loading from source to target Databases in a complex, high - volume environment.
• Strong Data Warehousing ETL experience of using Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, and Oracle PL/SQL.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1 and type2.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier and SCD Type-2 etc.
• Expertise monitoring workflows, pipeline partitioning, configuring email.
• Expertise in implementing Power center Mappings, Mapplets and Workflows for the different stages of ETL.
• Experienced in UNIX shell scripts to run Informatica workflows and controlling the ETL flow and also used to to automate the batch application.
• Excellent working experience with creating/modifying the Informatica Scripts and also transition of outdated scripts.
• Expertise in Query Analyzing and Performance tuning.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, user acceptance testing and documentation.
• Vast experience in development of Ab Initio graphs for ETL (Extract, Transform and Load) of various data feeds coming into the system from different source systems and transforming them as per the business rules and finally loading the transformed data into the database tables.
• Good working knowledge on Ab Initio Business rules engine.
• Worked closely with the business analysts and solution architects in finalizing the technical design of new applications for development / enhancements / production fixes.
• Ability to implement solutions with quantitative, analytical, diagnostic, debugging, and problem solving skills in all phases of SDLC.
• Coordinated with offshore team on development and maintenance projects.
• Substantial experience in Financial, Retail service industry business processes.
• Proven track record of delivering optimal problem solving and decision making technical solutions in fast track development environment within timeframe.
• Experience in creating and enhancing administrative, operational and technical policies and procedures, adopting best practice guidelines, standards and procedures.

TECHNICAL SKILLS:

Platform : Windows, UNIX/LINUX.

Database: Oracle 11g/10g/9i, MS SQLServer2008/2005, MS Access, IBM DB2, Teradata.

ETL tool: Ab Initio CO>OP 3.2/3.1/3.0/2.15/2.14/2.11 , GDE 3.2/3.1/3.0/1.15/1.14/1.11 , Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Exchanger.

Programming: SQL, PL/SQL, HTML, UNIX SHELL SCRIPTING

Defect Tracking Tool: HP Quality Center

WORK EXPERIENCE:

Confidential, Raleigh, NC

Sr. ETL/ DWH/ QA Analyst

Responsibilities:

• Lead various subject areas in the project by designing Informatica mappings. Worked extensively in design, development, testing and deployment of code.
• Involved in the requirements gathering by interviewing business users and responsible to prepare documentation for detail technical design.
• Involved in analysis of functional requirements, created mapping documents, assisted in code debugging and documentation.
• Worked extensively on design, development and testing for different projects.
• Worked extensively in Coding, testing, debugging, documentation and implementation of several releases.
• Involved in Code Review, Design reviews, testing reviews.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Assume ownership and accountability for the assigned deliverables through all phases of the development lifecycle.
• Used various lookups in the graph to enhance the processing of joins.
• Extensive knowledge in test case review, and Implementation and Post Implementation documents.
• Responsible for the Assembly and the Component Test plans and Test plan execution.
• Contributed the team during testing phase up till leading implementation for getting done various change requests, impact analysis for coding changes done
• Responsible for execution of the module (deliverables, coding to standards/architecture, understand/adhere to change, fix defects, and co-ordinate release management (and other) processes.
• Responsible for Defect Analysis and update status of defects using HP Quality Center.
• Satisfy programming requirements for assigned work with minimum supervision within budget and time constraints.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Created an Event Publish Service to publish the data near to real time even being a batch process.
• Created a fully parameterized Generic component to modify data for testing. This graph can be used to modify all types of files.
• Developed several generic code for application using dynamic dml and xfrs and also worked on all phases of SDLC for several releases.
• Involved in creating the standard process documents for different projects to share among the team.
• Good knowledge in coding and fine tuning SQL scripts, PL/SQL Stored Procedures
• Extensive working knowledge in UNIX and shell scripting.
• Involved in creating the job files and corresponding schedules.

Environment: : Informatica Power Center 9.5, Oracle 11g/10g, SQL, PL/SQL, Shell Scripting, IBM Tivoli Scheduler, Ab Initio Co >Op 3.2/3.1, GDE 3.2/3.1.

Confidential, Chapel Hill, NC

Sr. ETL/ DWH /QA Analyst

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, Db2 UDB, SQL Server and XML Files.
• Extensive working capability in data integration methodology and technology.
• Involved interactively with the business units to understand the requirements and gather the feedback during the design, development and testing of solutions.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Proven track in lifecycle support code analysis, deployment, migration, production implementations.
• Excellent working experience working against RESTful API by using HTTP requests to GET, POST,PUT,DELETE.
• Worked with Power Center parameter file, which is a list of parameters and variables and their associated values, includes information for multiple services, service processes, workflows, work lets, and sessions in a single parameter file.
• Good working knowledge on Control-M.
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensive knowledge on Analyzing the Software Requirement Specifications and Software Development Life Cycle (SDLC) like waterfall and agile methodologies.
• Executed Informatica workflows using PMCMD utility thru UNIX scripts.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center 9.5, Oracle 10g/11g, UNIX Shell Scripting, TOAD, SQL.

Confidential, Richmond, VA

ETL QA Analyst

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) like waterfall and Agile methodologies from Business Analysis to Development, Testing, Deployment and Documentation.
• Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data Mart.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping.
• Extensively used SQL coding for overriding the generated SQL in staging and also tested the data loaded into the database.
• Created reusable transformations and mapplets to use in multiple mappings.
• Maintaining existing data flow mappings and fixing any defects associated with them as reported by the QC team.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Handled large volumes of data warehouse database.
• Performing code review, formal testing, optional testing, and specification review using Test Director.
• Implementing performance tuning methods to optimize developed mappings.
• Conducting debugging sessions and fixing invalid mappings.
• Designed and developed UNIX Scripts to automate the tasks.
• Analyzing production support documents and finding the feasible time to run their jobs. 

Environment: Informatica Power Center 8.6, Power Exchange, Erwin, Oracle 10G/9i, SQL Tools, Power Connect, PL/SQL, UNIX, TOAD, Windows XP.

Confidential, Bedford, NH

ETL QA Analyst

Responsibilities:

• Involved in Complete SDLC like waterfall and Agile methodologies from Business Analysis to Development, Testing, Deployment and Documentation.
• Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data Mart.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping
• Created reusable transformations and mapplets to use in multiple mappings.
• Extensively used SQL coding for overriding the generated SQL in staging and also tested the data loaded into the database.
• Maintaining existing data flow mappings and fixing any defects associated with them as reported by the QC team.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions by handling large volumes of data warehouse database.
• Performing code review, formal testing, optional testing, and specification review using Test Director, analyzing production support documents and finding the feasible time to run their jobs. 

Environment: Informatica PowerCenter 8.6, Power Exchange, Erwin, Oracle 9i, SQL Tools, Power Connect, PL/SQL, UNIX, TOAD, Windows XP.