SUMMARY

• I have around 11 years of IT and DW /BI experience in which 8 plus years as an Informatica Consultant and 3 years as an Ab Initio Consultant. I have acquired good Knowledge of Complete Development Life Cycle of Data Warehouse/Business intelligence Projects.
• Having around 11 years of IT experience in development of Data warehousing solutions using Informatica 7.1/8.1/8.6/9.1 and Ab Intio 1.14(GDE) 2.14.1 Co - Operating system
• Implemented techniques like slowly changing dimension (type1, type2, and type3), slowly growing targets, and Simple pass through mapping with ETL tool Informatica.
• Created complex mappings using Lookup, Joiner, Aggregator, Filter, Router, Update Strategy and Expression transformations.
• Created and Executed Workflows using Workflow Manager and Workflow Monitor.
• Used Informatica Workflow Manager & Monitor to create the task, Schedule the task and Monitor the workflows.
• Developed Ab Initio graph as per business requirement
• Used various Ab Initio components like Lookup, Join, Reformat, Filter by expression, Rollup, Scan, Redefine format, Merge, Gather, Replicate, Sort etc.
• Good in Unix shell scripting, developed Unix scripts based on business needs.
• Created Unix shell scripts to sftp source file for ETL jobs, created/executed ETL job through crontab and debugged Unix Shell Scripting to fix the issues
• Optimized the ETL process using Performance Tuning Methods.
• Involved in unit testing, integrated testing and Regression testing of project.
• Involved in designing of HLD(High level design), SRS(software requirement specification) and Mapping document as per business requirement.
• Having good knowledge on Metadata Manager
• Interacted directly with the client to know the business requirement and executed the same in project.
• Worked on Power Exchange.
• Created Informatica data validation mapping to validate the source system data based on business need.
• Knowledge of Complete Development Life Cycle of Data Warehouse Project.
• Good knowledge of Informatica MDM
• Participated in system design and data modeling( Logical and Physical)
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements
• Have good experience on RDBMS Oracle 9i/10g, Teradata V2R5 and MS Sql Server.
• Have good knowledge in SQL, PL/SQL
• Worked with Version Control tools IBM Rational Suite- Clear Case / Clear Quest, Visual Source safe.
• Exposure to other tools: Control-M Scheduler, Defect logging tools - Test Director & Remedy.
• Project management tools Integrated Project Management System (IPMS)
• Handled team size of 8 members.
• Fixed QA/Production defect/issue raised on Mercury test director and Remedy
• Resource Management (Selection of New Project Personnel, if required).
• Managing, coordinating, planning and executing project.
• Directly reported to client Manager.
• Overseas (UK/US) Client Site exposure - worked at the Client site on deputation to the UK (around 3 years) and in USA for 4 years.

TECHNICAL SKILLS

Technology Experience: Informatica 6.1/7.1/8.1/8.6/9.1 , Ab Initio 1.14(GDE) 2.14.1 Co-Operating system, Teradata V2R5, Oracle 9i/10g,MS sql server, Control-M, Erwin, Business Object, Oracle warehouse Builder(OWB)

OS: Windows NT,/XP/1998,Unix

Hardware: Intel Pentium

Tools: Informatica 6.1/7.1/8.1/8.6/9.1 , Ab Initio Control-M, Erwin, Rational clearcase, Mercury Test director, BO,Remedy

Domain Experience: Sales and Marketing, Services, Manufacturing, Card Payment, Finance, Healthcare, Customer experience, Human Resource

RDBMS: Oracle 9i/10g, SQL, Pl/Sql, Microsoft SQL Server, Teradata V2R5

PROFESSIONAL EXPERIENCE

Confidential

Sr .ETL Developer/Lead

Responsibilities:

• Requirements Analysis - Identify sources of data and document business rules.
• Convert existing processing of HRDB data in to Informatica mappings and move all HRDB tables into Landing/Staging area.
• Perform one-time data migration to move all existing HRDB data to Enterprise data ware house (EDW)
• Perform data validation and eliminate reliance on DB2/mainframe as a source.
• Integrate HRDB data model with HHS Cap HR data model.
• Build Informatica ETL processes to load data through the Staging layer in to EDW
• Support down-stream users and migrate the down-stream users from DB2 to Oracle
• Creating HLD(High level design), TDD(Technical Design docs)and Mapping document as per business requirement.
• Developing Informatica mapping to implement techniques like slowly changing dimension (type1, type2), slowly growing targets, and Simple pass through.
• Created various Transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy to implement the business logic.
• Creating tasks/Workflows to perform the ETL execution.
• Performing unit/integrated testing of ETL process.
• Daily communication with SME/Business Analysts via mail, chat, teleconferences.
• Internal Quality Auditing of the deliverables before delivery.

Confidential

Oracle 9i/10g, Teradata

Responsibilities:

• Gathering requirements with business and implementing as per business requirement.
• Attending daily scheduled Conference calls
• Creating HLD(High level design), TDD(Technical Design docs)and Mapping document as per business requirement.
• Implemented techniques like slowly changing dimension (type1, type2, and type3), slowly growing targets, and Simple pass through mapping with ETL tool Informatica.
• Created various Transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy.
• Developed Unix script to executed ETL job using crontab.
• Created Unix script to sftp source file for ETL jobs
• Participated in system design and data modeling( Logical and Physical)
• Preparing daily/weekly status report.
• Daily communication via mail, chat, teleconferences.
• Internal Quality Auditing of the deliverables before delivery.
• Assigning the work from functional & technical perspectives.
• Interacting with the offshore and Onsite management.
• Resource Management (Selection of New Project Personnel, if required).
• Managing, coordinating, planning and executing project.
• Handling team size of 5 members

Confidential

ETL Lead

Responsibilities:

• Reviewing requirements with business and both onsite/offshore management team.
• Creating ETL design docs and Mapping document as per business requirement.
• Created various Transformations like Lookup, Joiner, Aggregate, Expression, Filter, Router, and Update Strategy.
• Costing and controlling the quality of product/service.
• Assigning the work from functional & technical perspectives.
• Interacting with the offshore and Onsite management.
• Resource Management (Selection of New Project Personnel, if required).
• Managing, coordinating, planning and executing project.
• Ensuring proper utilization of human resources.
• Handling team size of 7 members

Confidential

ETL Lead

Responsibilities:

• Developed Informatica mappings and workflows to implement the logic of Clearing and settlement C&S application.
• Participating in logical and physical design to build Clearing and settlement architecture.
• Involved in Unit testing and Integrated testing for the Clearing and settlement Applications
• Created and executed the workflow in staging environment for testing purpose.
• Interacted with BA(Business Analyst ) to know the business logic for C&S application and Implemented the same as per business requirement

Confidential

ETL Lead

Responsibilities:

• Developed Ab Initio graph as per business requirement
• Used various components like Lookup, Join, Reformat, Filter by expression, Rollup, Scan etc.
• Extracts data from the journals file coming from VDPS switch.
• Done the Unit testing of Ab Initio graph which has been developed by me to implement the Change Request (CR) as per business requirement.
• Interacted with BA (Business Analyst) to know the business requirement for DFM (Data feed manager) downstream application and developed the code as per Enhancement Request(ER).
• Involved in defect fixing of system testing and Regression testing.
• Involved in 2nd level production support to resolve the severity 1 issue.