SUMMARY:

• 9 years total IT experience with different Job Roles and Skill Sets.
• 5 years of experience in Data warehousing using ETL tool like Informatica Power Center.
• Extensively worked on Informatica Tools: Designer, Workflow manager and Workflow Monitor. Strong database skills, Object Oriented Programming and development knowledge
• Developed different mappings using different transformations.
• SQL proficiency in database programming using Oracle RDBMS.
• Good knowledge in PL/SQL and Netezza.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Perform unit testing at various levels of the ETL.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Analyze functional requirements, mapping documents, assist in problem solving and troubleshooting.
• Have excellent quality of adapting to latest technology with analytical, logical, innovative knowledge to provide excellent software solutions.
• Excellent skills with short learning curve when faced with new challenges and new environment.
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player.

SKILLS:

• Basic Networking concepts and technologies.
• Network connectivity troubleshooting and dialup connectivity, TCP/IP.
• Troubleshooting Win 98, 2000, XP, VISTA Operating Systems.
• Supporting Ms Outlook, Outlook Express Clients, Lotus Notes.
• Supporting Internet Explorer and Firefox Browsers.
• Knowledge on Global delivery framework, Lean Principles
• Knowledge on ITIL (Information Technology Infrastructure Library)
• Multitasking during the calls.

TECHNICAL SKILLS:

ETL TOOLS: Informatica

Development Tools: Oracle developer,Toad, Netezza developer

Version Control tools: Quality Assuarance tool(QA), Rational Clear case, Discovery tool

Languages: Oracle 11g, 10g, Netezza

O/S: Windows 2000/XP, Windows 7 and Basic UNIX Commands

Schedular: Autosys

PROFESSIONAL EXPERIENCE:

Senior Analyst - ETL Informatica

Confidential, Dallas, Texas

Responsibilities:

• To be the first point of contact for technical issues faced by End Users and the offshore team relating to development, support and maintenance of ONCOR’s Advanced Metering System. Leverage superior knowledge of IBM/Client specific tools including Informatica Power center, Oracle, Unix to perform effectively.
• Provided technical Leadership to offshore team.
• Performed work allocation, planning, delegate work to offshore, track tasks to completion, resolve offshore questions/issues and drive projects to successful completion.
• Attended status meetings with Customer/End Users regarding status tracking of projects and issues. Conduct status meetings with offshore team and external teams as applicable.
• Involved in multiple stages of SDLC (s/w development life cycle) including Analysis, Estimation, Coding, Unit Testing, User Acceptance Testing support for new/ongoing projects from ETL (Extract / Transform / Load) / DWH (Data warehousing) standpoint.
• Leveraged superior knowledge in combination of technical skills in both Oracle as well as Informatica ETL/DW to perform effectively.
• Performed Monthly production code release / migration coordination.
• Leveraged superior Leadership, Planning skills to drive Monthly code releases to success.
• Performed Project Level Coordination activities involving Stake holders, End Users, Onshore/Offshore team’s downstream application areas and Informatica Admins and DBAs (Database Administrators).
• Act as point of contact for Customer issues, and offshore questions.
• Perform Analysis/Enhancement tasks relating to Production code/data issues.
• Perform the role of Primary Onshore Contact for tickets raised by production control for Analysis. Perform Analysis of such issues.

Environment: Informatica 9.6.1, Oracle 11g

Ntezza SQL Developer, Lead

Confidential

Responsibilities:

• Involved in Coding stored procedures using Netezza Database.
• Initially involved in reviewing mapping documents
• Created SQL scripts in Netezza.
• Created SSIS Packages
• Unit Tested the code and created Unit test documents
• Validated the code in QA environment, comparing the code from DB2 with converted code in Netezza.
• Giving inputs for coding and Unit testing estimations to the Managers.
• Updating Team Status tracker and sharing with onsite team.
• Responsible for team development schedule and sharing updates to onshore and offshore Project managers on daily basis.
• Preparing Issue log, Effort log and Code development/Testing progress trackers and sharing with Managers.
• Coordinating with team members and discussing issues. Helping the team and providing solutions to any technical issues.

Environment: SSIS, Netezza database

Technical Lead

Confidential

Responsibilities:

• Understanding Confidential architecture and the customer requirements, analyzing the impacts of the requirements on the existing applications.
• Prepared the design documents based on the Transformation rules to load the data from source to the Target.
• Developed Informatica Mappings to load data from Source systems to Staging tables and then to Data Mart.
• Enhanced session performance by effectively using Persistent caches, Informatica Lookup Overrides, partitioning, and other session optimizing techniques.
• Used Parameter files to pass queries, define Mapping, Session Parameters, column values that frequently change etc.
• Created reusable change detection mapplet which reduced the development effort.
• Established Audit and Control process to identify soft rejects during file transfer or Informatica data processing
• Developed detailed Test cases for all Informatica mappings.
• Involved in code deployment.
• Scheduled ETL process on daily basis weekly and monthly basis.
• Tracked defects on regular basis and brainstormed offshore team to prevent the re-occurrence of the defects.
• Interacted with data analyst/QA teams on client side to get resolution/validate the issues.
• Had provided optimistic estimates to client and tracked offshore work at regular intervals to deliver the code as per the schedule.
• Involved in peer review of code/UTPs delivered by offshore.

Environment: Informatica 9.1, Oracle database

ETL Developer

Confidential

Responsibilities:

• Developed procedures in Netezza to load the data from source to target in the current iteration.
• Done enhancements for the previous iteration Informatica Mappings to load data from Source systems to Staging tables and then to Data Mart.
• Developed detailed Test cases for all Netezza procedures.
• Involved in deploying the code to TEST/QA/PROD and supported QA/UAT issues within no time.
• Tracked defects on regular basis and fixed them without leading to new issues.
• Interacted with data mappers on the client side to get resolution/validate the issues while doing analysis.
• Involved in peer review of code/UTPs delivered by offshore.
• Helping the team members whenever they struck while doing coding and fixing the defects.
• KT sessions given to the new team members joined in the team.

Environment: Informatica 9.1, Netezza database

ETL Developer

Confidential

Responsibilities:

• Created mappings to load source data into target tables.
• Developed number of Informatica mappings, mapplets and reusable transformation to facilitate one time, daily, monthly and yearly loading of data.
• Used various transformations in Informatica.
• Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log.
• Created tasks and workflows in the workflow manager and monitors the sessions in the workflow monitor.
• Responsible for preparing mapping documentation.
• Involved in Unit Testing and Peer reviews.

Environment: Informatica 9.1.1/ 9.1.5 , Oracle 11gTeam Size: 10 to 15

ETL Developer

Confidential

Responsibilities:

• Worked on Informatica Source Analyzer, Mapping Designer and Transformations.
• Proficient in SQL queries.
• Have good concept of ETL and Datawarehouse.
• Coordinated with Team members who are working on Power Center 9.1.1 and 9.5.1 (ETL Tool) to extract data from TRP source.
• Created Extraction, Transformation and Loading scripts to populate data-warehouse from operational database.
• Designed and developed aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Created Mappings and validated them to run those mappings in the Workflow Manager.
• Created sessions and validated them using Informatica Workflow Manager.
• Scheduled and monitored ETL jobs using Autosys and workflow manager.
• Involved in fixing the QA issues.
• Involved in supporting SIT environment code migration activity.

Environment: Informatica 8.6, Oracle 10g