SUMMARY:

• Associate has 12+ years of ETL and data integration experience in developing ETL and reports using Informatica, Teradata, Netezza and Business Objects.
• Experience in developing ETL mappings using Informatica Power Center 9.x client tools Designer, Workflow Manager & Workflow Monitor.
• Experience in Performance tuning of Informatica mappings and sessions.
• Worked on Creation of complex Informatica mappings and Business objects reports
• Having strong knowledge of SQL tuning and Performance optimization of Reporting Application on Oracle, Teradata and Netezza Databases
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Good problem solving skills and working knowledge on Requirement Analysis, preparing report logical models, SQL tuning
• Responsible for Requirement gathering & analysis, Development, Documentation, Testing, debugging and Implementation of Database/Data Warehousing applications
• Having functional domain knowledge of Telecom and Banking (Mortgage Banking) industries
• Expertise in Handling Project Delivery of various sizes
• Have excellent exposure to the onsite - offshore (Outsourcing) business model coordination
• Have excellent Team management, Committed and Good Leadership qualities

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer and Data Analyst

Responsibilities:

• Analyze the impacts of de-scoping existing CLS extracts for marketing data
• Analyze the data mapping for existing fields from new SOR AFS and come up with new mapping document to develop ETL
• Convert existing Informatica code with DB2 targets to work with Netezza database
• Preparing technical design Documents before ETL
• Developing mappings using Informatica for ETL
• Fine-tuned the mapping for faster loads.
• Preparing the Unit and integration Test Plan and Test cases for developed Mappings
• Trouble shooting the load failures on QA and UAT environments
• Co-ordinate with multiple stake holders for Productions environment readiness and migration
• Co-ordinate with project management and offshore to make sure the deliverable are met with the timelines per project plan

Confidential

ETL Team Leader

• Worked with SOR technical and BA teams to come up with detailed requirement documents
• Analyzed impacts on existing data elements from the new SOR attributes and created requirement documents to remediate the impacts
• Prepared technical design Documents before ETL
• Developed mappings using Informatica for ETL
• Working on different transformations Lookup, Normalizer, Update strategy, Aggregator, Expression, Filter, Router, and Sorter etc.
• Fine-tuned the mapping for faster loads.
• Preparing the Unit and integration Test Plan and Test cases for developed Mappings
• Troubleshooting the production failures and implementing the emergency data/code fixes
• Analyzing the data lineage issues reported business users and coordinating with SOR stakeholders for fixing the issues

Confidential

Team Lead

• Requirement Analysis and estimation
• Preparing design Documents before ETL
• Developing mappings using Informatica for ETL
• Working on different transformations Lookup, Normalizer, Update strategy, Aggregator, Expression, Filter, Router, and Sorter etc.
• Fine-tuned the mappings for faster loads
• Preparing the Test Plan and Test cases for developed Mapping
• Monitoring the loads in production and troubleshooting the failures
• Created data maps to read the EBCDIC/variable length files through Informatica
• Responsible for offshore deliverables (Code, Unit test case and results..etc.)

Confidential

Module lead

• Software-enhanced wireless telephone and messaging, two way radio products and systems, networking and internet access products for consumers, network operators and commercial, Government and industrial customers.
• End to end systems for delivery of interactive digital video, voice and high-speed data solutions for broadband operators
• Embedded semiconductor solutions for customers in wireless communications, networking and transportation markets
• Integrated electronic systems for automotive, industrial, telecommunications, computing and portable energy systems
• Preparing design Documents before ETL
• Developing mappings using Informatica for ETL
• Working on different transformations Lookup, Normalizer, Update strategy, Aggregator, Expression, Filter, Router, and Sorter etc.
• Fine-tuned the mapping for faster loads.
• Preparing the Test Plan and Test cases for developed Mapping
• Monitoring the loads in production and troubleshooting the failures
• Developing Business Objects reports based on various business user requirements

Confidential

Team member

• Understanding the Data Model requirements, Sourcing of data and information for the various heterogeneous sources
• Developed complex mappings using expression, aggregator, filter, joiner, lookup, router and update strategy to develop and feed Data Marts
• Fine-tuned the mapping for faster loads
• Validating the Data before and after loading into the target database / flat file
• Preparing the Test Plan and Test cases for developed Mapping
• Worked on migration tools Kintana and Clear case while migrations
• Monitored the loads in the production and fixed the failures
• Involved in production support for Power Analyzer reports and fixed the data issues in the reports noted by business users

Confidential

Team member

• Worked extensively in requirement analysis
• Developed complex mappings using expression, aggregator, filter, joiner, lookup, router and update strategy to develop and feed Data Marts
• Fine-tuned the mapping for faster loads
• Validating the Data before and after loading into the target database / flat file
• Participated in system and user acceptance testing
• Developing Business Objects reports based on various business user requirements