SUMMARY

• Around 8 years of work experience in Information Technology industry as ETL developer with Data Warehousing, Data Quality, Data Governance & Master Data Management projects and various tools/utilities associated with it.
• Extensive experience with Informatica Powercenter (9.x /8.x / 7.x) for design and implementation of complex business solutions along with Unix Shell Scripting, SQL, PL/SQL procedures and job scheduling via Autosys.
• Experience in Informatica Performance Tuning, Query Optimization in mappings to optimize load and query performance.
• Good knowledge of Data Quality, Data Governance, Data profiling, Master Data Management, Data Analysis and Data Standardization from various source systems with focus on data management techniques and technologies to improve teh usage and utilization of enterprise data.
• Experience in using Data Quality Reporting framework using IDQ (Informatica Data profiling) tool modules like Analyst and Developer to create Profile reports, profiling rules, scorecards, data standardization transformations like address doctor.
• Strong analytical and problem solving skills, with sound experience of designing and developing Data warehouse applications for Life sciences domain.
• Experience in conversion projects of implementing Abinitio & Data Stage solutions with Informatica.
• Experience with basic Informatica Powercenter Administration tasks with Administrative console and Repository manager for code migration, creating /configuring folders, groups, user roles and privileges
• Experience in implementing Data Warehouse solutions with dimensional modeling, Slowly Changing Dimensions(SCD Type I, II & III) model, Start and Snowflake schema implementation.
• Strong SQL experience along with experience in PL/SQL store procedures, functions, packages and cursors across and within ETL codes to implement complex business scenarios
• Excellent ability to understand business requirements from a domain standpoint and converting teh same into technical solutions.
• Having great knowledge of working with Application Development, Testing, Operations Maintenance projects in Life Science domain. Experience in ETL testing with creation and execution of QA/UAT Test cases, logging defects and coordinating with business for resolution.
• Possess diversified technical background having good knowledge on Software Development Life Cycle (SDLC), Production Environment handling, Data Migration etc.
• Profound innovative skills in key areas of Project delivery . Received teh ‘Innovator Of Teh Year’ award from Cognizant ETL - MDM Practice.

TECHNICAL SKILLS

Concepts Methodology: Data Warehousing, Data Quality, Data Governance, Master Data Management

ETL: Informatica Powercenter 9.x/8.x/7.x (advanced)

Data Quality: Informatica DQ 9.5

Scheduling Tool: Autosys

Databases: Oracle 10g, 11g, 12c, Teradata 13.x, MS Acess

Other Skills /Tools: SQL(Oracle, Teradata, SQL Server, MS Access), PL/SQL, Unix - Shell Scripting, SQL Developer, Teradata SQL Assistant, BTEQ, Toad, Informatica MDM 9.5, HP Quality Center, IBM Rational Clear Case

PROFESSIONAL EXPERIENCE

Confidential

Onsite ETL Application Lead & Developer

Responsibilities:

• Perform enhancement/defect fixes to ongoing Releases by following SDLC and policies and procedures and completing appropriate activities and associated documentation, as defined in teh appropriate methodology.
• Support system test of teh enhancement Releases
• Conduct performance analysis to determine whether or not a new Release can meet existing Service Levels prior to entering into production
• Provide LoE for new releases and finalize project plan with PM
• Participating in teh data modeling sessions to understand teh data model and providing them inputs based on teh existing data to make sure designed model is technically feasible.
• Gather, Analyze and Build & document teh ETL batch process,
• Involve in Design, Develop of ETL processes with enterprise standards & best practices. Create proper scheduling of teh interfaces writing jil files with Autosys
• Analyze Data transformation implementation analyzing Abinitio graphs and implement them using Informatica
• Create a Data Qulity framework with proper Business rules ensuring major data quality exceptions are captured.
• Responsible to Implement Data Quality reports using Business Rules via Informatica Powercenter and IDQ
• Create Reconciliation framework that captures any fallouts between source to target loads at various stages like staging /mart and consumer tables.
• Unit test teh interface modules and coordinate with SIT team for testing activities.
• Involved in SIT phase to coordinate teh testing activities with testing teams. Created ETL cases, test scenarios and executed them with teh QA team.
• Involved in UAT activities & Deployment of code to production
• Analyzed and resolved various data issues in various layers of ETL and coordinated with downstream systems for any publish issues.

Confidential

Onsite ETL Lead

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Interacting with business users for requirements gathering and converting these requirements into technical solutions
• Participating in teh data modeling sessions to understand teh data model and providing them inputs based on teh existing data to make sure designed model is technically feasible.
• Involved in preparation of Business Requirement document(BRD), SDS(System Design Document), Test plan and Deployment documents.
• Gather, Analyze and document teh MDM/ETL batch process,
• Design teh ETL flow of extracting various Source data from Common Interface Layer up to teh MDM Landing layer with data rejection handling as per different business scenarios
• Design Type-II Slowly Changing Dimension (SCD) as part of teh publish model
• Design ETL flow to extract master data from MDM publish layer to various downstream systems like Veeva & Concur.
• Build teh ETL Informatica layers with various transformations like router, sorter, update strategy, joiner etc. and Unix shell scripts
• Responsible to tune ETL mappings to optimize load and query Performance
• Design data quality & reporting framework, define data quality rules after extensive data profiling on source system data
• Work closely with Data Stewards in formulating rules and procedures to address manual data analysis and remediation procedures and data quality reports.
• Used various Tasks like Control, Assignment, Timer, Event-Wait, Event-Raise, Email as a part of Workflow Logic as per teh requirements.
• Unit test teh interface modules and coordinate with SIT team for testing activities.
• Involved in SIT phase to coordinate teh testing activities with testing teams. Created ETL cases, test scenarios and executed them with teh QA team.
• Involved in UAT activities & Deployment of code to production
• Analyzed and resolved various data issues in various layers of ETL and MDM and coordinated with downstream systems for any publish issues.

Confidential

Onsite ETL Lead

Responsibilities:

• Gather, Analyze and document teh MDM/ETL batch process, Data Model and architecture
• Interacting with business users for requirements gathering and converting these requirements into technical solutions
• Lead Onsite and offshore teams for successful delivery of teh project
• Worked on source data profiling and implemented automated data quality profile reports and scorecards for processing data in various stages .
• Worked with different transformations to implement teh business logics. Transformation like Source/Target Transformations, Lookup transformation, Stored Procedure transformation, Expression Transformation, Joiner, Aggregator, sorter, Normalizer, Rank and Sequence Transformations are extensively used along with Teradata loaders
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of teh workflow.
• Developed various shell scripts in specific portions to implement critical business logics with Unix and Teradata BTEQ utility
• Extensively work on teh performance tuning of Informatica PowerCenter Mappings as well as teh tuning of teh sessions by creating multiple sessions on primary key values by using partition query.Found teh bottlenecks for teh existing mappings to improve teh performance of teh mappings
• Implemented data quality and exception framework to address data issues and rejects while processing data from various source systems
• Worked with Data Stewards team to analyze data issues and process to mitigate teh same.
• Worked with configuration management team to migrate teh code from development to Production
• Closely worked with QA team in creation and execution of ETL test cases for QA /UAT phases
• Preparation of High Level Design (HLD), Detail Level Design (DLD)
• Preparation of Test planning like Integration Test Plan (ITP) and Estimation Plans in conformance with teh deadlines and teh various scopes
• Tracking Requirement Changes and preparation of Requirement Traceability Matrix
• Reviewing of Unit Test Plan (UTP), test data, test cases and code
• Preparation of Deployment Plan and user manual

Confidential

Offshore Technical Lead

Responsibilities:

• Understand teh Functional Design and Business Rules to create Data Model and Technical Design Doc
• Delivered Analysis, Design, Coding & Testing of ETL & PL/SQL components
• Designed ETL architecture and data flow along with Source to target mapping .
• Developed ETL mappings in Informatica PowerCenter Designer using various transformations like Source Qualifier, Aggregator, Expression, Connected and Unconnected Lookup, Update Strategy, Sequence Generator etc
• Created shell scripts, database views for supporting report purpose.
• Extensively work on teh performance tuning of Informatica PowerCenter Mappings as well as teh tuning of teh sessions and database parameters.
• Used Autosys to to control teh overall ETL scheduling process
• Updated SOP with teh usage of new functionality for teh business/support users
• Tracking Requirement Changes and preparation of Requirement Traceability Matrix
• Preparing of Unit Test Plan (UTP), test data, test cases and code
• Preparation of Deployment Plan and user manual

Confidential

Offshore Technical Lead

Responsibilities

• Worked various SDLC phases of teh project from analysis, deign to implementation.
• Coded ETL mapping, session and workflow and various shell scripts and PL/SQL procedures associated.
• Profile data from multiple source systems with creation of score cards and profile reports.
• Redesigned ETL process for best performance and proper dependency.
• Performance tuned and optimized teh existing mappings to reduce run time.
• Implemented data quality framework for generating exceptions for various business rules.
• Analyzed all errors generated by Informatica and fixed those errors in data collection.
• Optimized teh mappings using various optimization techniques and also debugged some existing mappings using teh Debugger to test and fix teh mappings.
• Prepared test data files, with both positive and negative testing scenarios.
• Supported UAT testing and defect fix.
• Trouble-shot and implemented existing code.
• Designed deployment strategy and deployment template.
• Introduced balance control and error handling ETL routine.
• Reviewed ETL process detail design from ETL Developer.
• Reviewed of Unit Test Plan (UTP), test data, test cases and code
• Preparation of Deployment Plan and user manual

Confidential

Module Lead

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand teh requirements and teh impact of teh ETL on teh business.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and tan to Data Mart.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated teh Data into teh Target Star Schema
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load teh data into Global Data Warehouse.
• Analysis, Design and Development of teh ETL components to load teh Customer and Product data.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in teh Informatica Designer.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of teh workflow.
• Tracking Requirement Changes and preparation of Requirement Traceability Matrix
• Reviewing of Unit Test Plan (UTP), test data, test cases and code
• Preparation of Deployment Plan and user manual
• UAT Support, Code Migration, Deployment Support

Confidential

Developer

Responsibilities:

• Worked on various kinds of Unix shell scripts, Informatica transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Interpreting Informatica mappings to develop extensive SQL queries/scripts to validate teh completeness, integrity and accuracy of data within an ETL process testing cycle.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Unit testing teh applications to test:
• Whether ETLs are accessing and picking up right data from right source.
• All teh data transformations are correct according to teh business rules
• Testing teh rejected records that don’t fulfil transformation rules.
• Integration testing for initial and incremental loading of teh data warehouse.
• Identity teh requirement and prepared test scenarios.
• Designing and execution test cases for data validation
• Defect reporting and attending business calls.