SUMMARY

• Developed Unit Test monitoring the run time to ensure successful execution of the data loading processes involve in preparing high level documents about mapping details.
• Involved in preparing SDD (System Design Document) based on PRD (Project Requirement Document), TRD (Technical Requirement Document) and Market analysis team inputs.
• Did error handling and performance tuning in Teradata queries and utilities for the existing complex scripts.
• Created Autosys jobs to schedule sessions and workflows on Linux and scheduled various reports using Schedule Management tool/Event Studio
• Maintained high level document including source name, target name, number of rows in both target and source, transformation used and session information.
• Involved in Technical Architecture Design Process, by gathering high level Business Requirement Document and Technical Specification Document from Technical Architecture and followed the specific conventions.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
• Conducted one on one interviews with Clinicians to understand the process of approving new subject into a Clinical Trial to become a SME on new subject enrollments
• Independently wrote Oracle Store Procedures and functions that calculate penalty at the end of the month.
• Created the modified the Teradata utilities BTEQ, MLOAD, FLOAD script to load the data from the various data source and legacy systems into Teradata Test and Production environment.
• Used the Teradata EXPLAIN and visual explain to analyze the cost and improve the Query performance.
• Created the workflow for Incremental Load and Slowly Change Dimensions (SCD1, SCD2, SCD3) using the Lookup and Aggregator transformation both for real time and Batch Processes.
• Used Informatica command utilities like pmcmd to communicate with integrated server to perform some task like start workflow, abort workflow.
• Performance tuned the mappings using different techniques like indexes, store procedure, functions, and materialized view to provide maximum efficiency.
• Developed complex mappings to convert DB2 stored procedures into ETL mappings using Informatica Power Center to load data into Teradata.
• Coordinated with developers, infrastructure, QA, instructional designers, and client SMEs to ensure deliverables and milestones were met for client requirements, use cases, software design, development, unit testing, system integration testing (SIT), user acceptance testing (UAT), quality assurance (QA), training, pilot/production readiness, implementation, and closure.
• Address Stability and Memory leak issues with Address Validation System Upgrade to troubleshoot any issues reported per Business teams during UAT execution
• Developed UNIX shell scripts to move source files to archive directory, maintaining logs and automate processes by using command utilities sed, awk, cut and other Unix command
• Provided project manager with regular status updates assisting the overall project management initiative.
• Wrote all project documentation from project definition, scope and business requirements document including process modeling for "as is" and "to be" states, mockups and wireframes.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica/SQL Developer

Responsibilities:

• 9+ years of experience in Information Technology as an ETL Developer, experience in all phases of life cycle of Requirement Analysis, Functional Analysis, Design, Development, implementation, Testing, Debugging, Productions Support, and Maintenance of various Data Warehousing Applications.
• Heavy experience in Data integration, Migration and ETL processes using Informatica PowerCenter 10.X,9.X,8.X, Power Exchange (CDC), Informatica Data Quality both in real time and batch processes.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from various sources such as Oracle, Flat Files, Teradata, XML, SAP, DB2, SQL Server, Tibco.
• Involved in Technical Architecture Design Process, by gathering high level Business Requirement Document and Technical Specification Document from Technical Architecture and followed the specific conventions.
• Created various profiles using Informatica Data Explorer (IDE) & IDQ, from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.
• • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.
• Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Using Informatica Power center 10.1 to make the changes to the existingETLWrote PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load delete records based on a condition and re - name the tables.
• Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 10.x.
• Extensively worked on building workflows, worklets, sessions, command tasks etc.
• Designed and developed Informatica mappings including Type-I, Type-II and Type-III slowly changing dimensions (SCD).
• Created mappings using different IDQ transformations like Parser, Standardizer, Match, Labeler and Address Validator.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Supported monthly data load activity using SSIS for Account Assignment System.
• Involved in writing SQL Stored procedures and Shell Scripts to access data from various sources.
• Performed System, Integration testing and supported User Acceptance Testing.
• Worked extensively on configuring OBIEE dashboard, reporting layer for OBIEE, source container for OBIEE.
• Managed stakeholder communication and validated the fixed issues in order to ensure support availability as per agreed SLAs.
• Responsible to handle multiple (18)Informaticaapplications to design, implement,supportand operating Data Integration Infrastructure.
• Worked on planning, design and implementing the standards, guidelines and best practice.
• Conduct requirement planning sessions for the hands-on development of the implementation strategy and customize payroll layouts based on best practices and plan noledge

Confidential, Nashville, TN

Sr. ETL Developer

Responsibilities:

• As a Sr. ETL developer had high-level overview of all required TRD and Mapping Document and reviews them as development prospective to find out what all the development required.
• Involved in the meeting with the Business to discuss the business requirement, ETL specification, calculation of all the metrics, sub metrics and reports that Frontier generate for the business to review.
• As a primary developer in the team, responsible to schedule Team meeting to discuss the Development, changes required, Time Line to meet all the SLA.
• As a part of the development team understanding the business requirement, involved in the code change in the Oracle Store Procedures and Package required for the different metrics that calculates the revenue based on the CLEC usage, Retail, and DUF usage.
• Developed Informatica Workflow using the Informatica PowerCenter 9.1 that was required for the new Order, Trouble, Billing feeds. Using the Informatica PowerCenter/Power Exchange and also was responsible for the Daily Load of over 500 files every day.
• Developed standard and re-usable mapping and mapplets using the various transformations like expression, lookup, joiner that Extract, Transform and Load the data between different environment using relational writer and Fast Export.
• Performed the roles of Senior ETL Informatica and Data Quality (IDQ) developer on a data warehouse initiative and was responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (DW), perform data cleansing activities using various IDQ transformations.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Created source system containers for OBIEE.
• Created subject areas in containers for OBIEE.
• Created narrative reports in OBIEE.
• Developed complex wrapper scripts to invoke Informatica code which can perform equivalent to Ab initio code.

Confidential - Plano, TX

SR. ETL Developer

Responsibilities:

• Master Data Management (MDM) process and tool was used to provide data transformation, data consolidation, data governance so that business is supportive to take Decision Support System.
• Categorized Dimension and Fact table by interviewing Oracle functional expert and Business Analyst and evaluated the granularity, Historical consistency and attribute availability.
• Used Informatica Power Exchange with CDC option to capture the inserted, updated, deleted and any changed data and Exchanging data between different partner having their own format and database.
• Designed Mappings using Mapping Designer to load the data from various sources (Flat Files, Sap, Teradata, VSAM) using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations
• Extensively used the capabilities of PowerCenter such as File List, pmcmd, Target Load Order, Concurrent Lookup Caches etc. Created and Monitored Workflows using Workflow Manager and Workflow Monitor
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables, Session Parameters and making Parameter file to pass value through Shell Scripting.
• Performed the roles of Senior ETL Informatica and IDQ developer on a data warehouse initiative and was responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (DW) and additional target data warehouses.
• Collaborated with data architects, BI architects and data modelling teams during data modelling sessions.
• Extensively worked on performance tuning of Informatica and IDQ mappings.
• Extensively used Informatica Data Quality transformations - Labeler, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.

Confidential, NY

ETL\IDQ Developer

Responsibilities:

• Responsible to analyze functional specification and prepared technical specification, development, deploying and testing according to business requirement
• Involved in data profiling process to systematically examine the quality, scope of data source to build a reliable ETL system with minimum transformation and human intervention before load to target table.
• •Involved in cleansing process to clean invalid values like zip code format, ensuring consistency across records, removing duplicates and ensure if complex business rules has been enforced.
• •Worked on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• •Created the modified the Teradata utilities BTEQ, MLOAD, FLOAD script to load the data from the various data source and legacy systems into Teradata Test and Production environment
• •Extracted the data from the flat files and Relational databases into staging area and populated into data warehouse using SCD Type 2 logic to maintain the history.
• Developed number of complex Informatica Mappings, Mapplets, and reusable Transformations to implement the business logic and to load the data incrementally.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica Power Center.
• Created the Design for Extraction process from legacy systems using combined techniques of Data Replication and Change Data Capture.

Confidential, Houston, TX

ETL Developer

Responsibilities:

• Understanding the business needs by gathering information from Business Analyst, Data Modeler and Business user.
• Involved in process of preparing Physical design of input and output by documented record layouts, source, target location, file/table sizing information.
• Extensively explore the physical model of Data Warehouse including all the Dimensions and facts like household, branch, account etc. to better understanding of requirement and meet all the SLA.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings and documented how data will be transformed.
• Supported technical teams involved with ORACLE issues and operations also developed UNIX shell Scripting and PL/SQL Procedure to extract and load data.