ETL Lead

Location:

Posted:

June 13, 2018

Resume:

SUMMARY:

Over ** years of diversified experience in the field of Information Technology and Data warehousing using Informatica PowerCenter. Developing Strategies for Extraction, Transformation and Loading (ETL) mechanism-using Informatica.

Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic.

Generated server side PL/SQL scripts for data manipulation and validation for remote instances.

Involved in creating Unix Shell Scripting. Defragmentation of Tables, Partitioning, compressing and Indexes for improved performance and efficiency.

Extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Analysis, Design, Development, Testing, Maintenance and Enhancement in variety of technological platforms with special emphasis on Data Warehouse and Business Intelligence applications.

Complete understanding of Soft Ware Development methodologies like waterfall, Agile etc.

Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica PowerCenter.

Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.

Good knowledge in OLAP and OLTP process.

Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.

Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies

Extensively provided end to end 24/7 Production Support by monitoring data into a complex high volume environment using Quick Base ticket logging system.

Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multi-dimensional modeling.

Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions

Experience in Performance tuning of the Informatica and Oracle.

Expertise in implementing complex Business rules by creating complex mappings / mapplets, shortcuts, reusable transformations and Partitioning Sessions.

As part of OAT (Operational Acceptance Testing), moving processing Prod data to different lower level UAT environments (Other Production like Environments) as requested by the clients.

Extensively worked on L1 & L2 production support related issues and analyses issue priority and address to L3 team with details and follow up on items.

Responsible for creating conference calls for groups to discuss incidents that are production related, time or scheduled related incidents.

Coordinate with DEV teams and work with support teams to move fixes to production.

Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer

Experience in working with Informatica Admin team on installing Informatica server, power center client in Development, QA and Prod machines.

Experienced with working on Onshore Offshore Support Model and shifts.

Experience in working with production support team and Change management and Incident Management and Deployment Management teams.

Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.

Extensively worked on various databases including Oracle 10g, SQL Server, DB2, and Teradata.

Experience in Integration of various data sources like Oracle, SQL Server, and Flat Files

Extensively worked with SQL loader for bulk loading into the oracle database.

Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.

Proficient in understanding business processes / requirements and translating them into technical requirements.

Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment.

Ability to work independently or in a team environment or in a rapid pace environment.

Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

Experience in Health Care domain.

Education:

M.B.A from SMU, India from 2011 - 2013

P.G.D.CA from University of Hyderabad from 1994 – 1995

Bachelor of Science from Nagarjuna University from 1991 – 1994.

TECHNICAL SKILLS

Data Warehousing ETL Informatica PowerCenter 9.x/ 8.x/7.x/6.x/5.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Repository, Metadata, Data Mart, OLAP, OLTP..

Data Modeling Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flack, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERWIN

Databases Oracle […] Sybase, MS SQL Server […] DB2 8.1

Programming SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization, Perl

Tools TOAD,, SQL Developer, Excel, Word, PuTTY, WinSCP, Notepad++

Reporting Tools MicroStrategy, OBIEE, Cognos

Environment UNIX, Windows XP/Vista

Methodologies SDLC, Agile

Informatica Certified Designer

Informatica Certified in Architecture and Administration Power Center 7

Informatica Certified in Advanced Mapping Designer PowerCenter 7

Informatica Certified in Mapping Designer PowerCenter 7

AWS Certification

Amazon Web Services Solutions Architect for Associate level.

Project Name NHSN

Duration Oct’ 2017 – Till Date

Client Fresenius Medical Care, BURLINGTON, MA

Designation ETL Lead

Fresenius Medical Care is a German company specializing in the production of medical supplies, primarily to facilitate or aid renal dialysis. As part of the Dialysis to the patients, its required to provide detailed reports of the number of patients treated in their clinics to the Federal Governments. NHSN is part of that reports, which can take care of those details

Responsibilities:

Developed ETL mappings, Transformations and Loading using Informatica Power Center 9.6.1.

Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 9.6.1

Conducted performance tuning to increase performance of the mappings, sessions & workflows.

Involved in all SDLC phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.

Involved in Supporting ETL Applications production jobs and changing existing code based on business needs.

Interacted with business community and gathered requirements based on changing needs.

Involved in Analysis and translate functional specifications and change requests into technical specifications.

Responsible for data quality profiling, Data Modeling, ETL and gap analysis.

Extensively worked on Informatica 8.6 for designing and developing the ETL processes.

Worked with heterogeneous sources from various channels like Oracle, DB2, flat files, and COBOL files.

Environment: Informatica Power Center 9.6, Oracle 11g, SQL Assistant, MS UNIX, Perl Script, Win CVS, Putty, SQL Developer, XML files, Flat files.

Project Name :Customer Profile Migration

Duration : Aug 2012 – Aug 2017.

Client : Cigna, New York

Designation :Technical Lead

Individual and family medical and dental insurance plans are insured by Cigna Health and Life Insurance Company (CHLIC). In Arizona, individual HMO plans are insured by Cigna HealthCare of Arizona, Inc. Group health insurance and health benefit plans are insured or administered by CHLIC, Connecticut General Life Insurance Company (CGLIC), or their affiliates (see a listing of the legal entities that insure or administer group HMO, dental HMO, and other products or services in your state). Group Universal Life (GUL) insurance plans are insured by CGLIC.

Responsibilities:

Developed ETL mappings, Transformations and Loading using Informatica Power Center 9.6.1.

Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 9.6.1

Conducted performance tuning to increase performance of the mappings, sessions & workflows.

Used PL/SQL with Informatica Power Center 9.6.1 for Oracle 11g database.

Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.

Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.

Worked with complex mappings, mapplets, worklets and transformations

Implemented SQL/PLSQL Stored Procedures/Functions.

Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic.

Generated server side PL/SQL scripts for data manipulation and validation for remote instances.

Involved in creating Unix Shell Scripting. Defragmentation of Tables, Partitioning, compressing and Indexes for improved performance and efficiency.

Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data using the debugger.

Developed, implemented and enforced ETL best practices standards.

Performance tuning and bottleneck resolution.

Created and Implemented Reusable tasks like E-mail.

Involved in logical and physical data modeling and analyzed and designed the ETL processes

Involved in the documentation of the project like TDD( Technical Design Document)

Prepared the change request Plan and update the status of the change request to the onshore with progress and achievements.

Worked in different support activities when needed.

Environment: Informatica Power Center 9.6, Oracle 11g, SQL Assistant, MS UNIX, Perl Script, Win CVS, Putty, SQL Developer, MS Xcel, Flat files.

Project :Decision Support System

Duration : Jan 2011 – July 2012.

Client : Verizon, India

Designation :Technical Lead

The Decision Support System (DSS) Data Warehouse is used by the organization to identify opportunities to increase revenue and market share and to develop deal analysis capabilities. It supports Marketing and Pre and Post –Sales activities to create new incremental revenue, retain existing revenue. It gives the various teams within Wholesale organization Marketing and Sales the analytics they need on their customers to do their day-to-day business transactions. The specific information that the clients could get from the reports is the billing data which is summarized at a certain level. DSS specifically contains detailed billing information extracted from the Bill Data Tapes (BDT). BDTs are received on a bill round by bill round basis, extracted, and transformed to be loaded.

Responsibilities:

Worked closely with the Business analysts and attended meetings to gather and discuss the requirements for enhancements and defect fixes for various projects

Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.

Resolved Production issues and helped in promoting the code to different environments for testing needs and participated in the deployment group.

Participate in project status meetings, peer reviews and other events with developers to get the status of the deliverables.

Analyzed and Identified the Tables/Views, Procedures and ETL objects that need to be migrated and prepared necessary Documentation.

Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.

Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's.

Provided support and quality validation through test cases for all stages of Unit and Integration testing.

Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.

Developed mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Involved in migrating objects to different environments using Deployment groups and Labels.

Prepared various documents like ETL Specification doc, Technical Design doc, Run Book etc.

Worked with Informatica Partitioning when dealing with huge volumes of data and worked on parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.

Creating and modifying existing Technical Design Specification document and other client deliverables for different releases.

Coordinated and interacted with other teams to maintain integrity in performing the tasks and execution of the loads appropriately in a timely manner.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL Developer, UNIX, Notepad+ +, WinCVS, Putty, Flat files.

Project : Sigs to XRM Database Migration

Duration : January 2009 – Dec 2010.

Client : Verizon, India

Designation :Module Lead

XRM is a solution designed to automatically generate service orders for the Local Service Requests (LSRs) submitted by Competitive Local Exchange Carriers (CLECs).XRM exists with East states, where as SIGS exists with WEST states.

Here is the requirement to make both East, West states into single application, which is the existing XRM application. So need to migrate the entire SIGS database, which is existing now in Informix to Oracle database, which is XRM database.

Responsibilities:

Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.

Participated in reviewing requirements during analyze and ensuring that sufficient details is available going into the design phase.

Developed ETL Mappings using Informatica PowerCenter 8.1 involving extraction and loading of data from Informix Database to Oracle.

Worked with Informatica PowerCenter-server, Repository Manager, Designer, server Manager, Informatica Server.

Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor

Test the Informatica mapping and workflows against the specifications on the detailed design.

Participate in project status meetings, peer reviews and other events with developers to get the status of the deliverables.

Creating and modifying existing Technical Design Specification document and other client deliverables for different releases.

Extensively worked in the Performance Tuning of the programs, ETL Procedures and processes.

Developed Pre-Session and Post-Session UNIX scripts to automate the data load processes to target Data warehouse.

Extensively used parameter files to avoid hard-coding in mappings to facilitate possible future changes thereby saving migration times.

Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Defects were tracked, reviewed and analyzed.

Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.

Monitoring the ETL production jobs and resolved the issues/bugs.

Identified sources, targets, mappings and sessions and tuned them to improve performance.

Environment: Informatica Power Center 8.1, Informx, Oracle 10g, SQL Developer, UNIX, Notepad+ +, WinCVS, Putty, Flat files.

Project : Network Metrics Platform

Duration : June 2004 – December 2008

Client : Verizon, India

Designation :Analyst

Telecom is a regulated business in USA and the genesis of the project lies in the Central telecommunication Regulation act of 1996. This act opened the local telephone market for competition giving rise to the competitive local exchange carriers (CLEC). The bandwidth providers were mandated to provide service to these smaller telecom service providers who would collect their customers by offering discounts and use the bandwidth and services provided by carriers. The FCC therefore asked the incumbent local exchange carriers (ILECs) to produce metrics validating that the CLECs were being provided same level of service as any other customers of ILECs. The Network Metrics Platform (NMP) is an initiative to bring this data on a central platform. This entails extracting data from several existing systems feeding this data to the data warehouse, building data marts to support the reporting requirements, doing the number crunching and producing the required reports.

Responsibilities