We provide IT Staff Augmentation Services!

Etl Application Lead /technical Manager Resume

SUMMARY:

  • Around 10 years of work experience in Information Technology industry as Technical Lead & manager with Data Warehousing, Data Quality, Data Governance & Master Data Management projects and various tools/utilities associated with it.
  • Extensive experience with complex ETL & Data Warehousing Solutions using ETL tools like Informatica Powercenter ( 9.x /8.x / 7.x) for design and implementation of business solutions along with Unix Shell Scripting, SQL, PL/SQL procedures and job scheduling via Autosys.
  • Experience with managing project resources, including subcontractors, and for establishing an effective communication plan with the project team and the client. Application of knowledge of Change Management, Release Planning, Stakeholder/Product Owner Management in both SDLC & Agile Life Cycles
  • 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 the usage and utilization of enterprise data.
  • Experience in using Data Quality Automation 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 the same into technical solutions.
  • Extensive experience in Technical Leadership, Application Development, Level 3 Production Support, Testing, Operations Maintenance projects .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 innovation & automation skills in key areas of Project delivery .

TECHNICAL SKILLS:

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

SDLC Methodology: Waterfall, Agile (Kanban)

ETL: Informatica Powercenter 10.x/ 9.x/8.x/7.x (advanced), Ab - Initio GDE version 2.14 Co-op version 2.15

Project Planning: Microsoft Projects, Rally, JIRA

Scripting: Linux/Unix, Perl, Python 3.x

Big Data Analytics: Hadoop, Flume, Pig, Hive, Hbase ( worked on internal POC projects under IBM Client Center of Advanced Analytics)

Data Validation: Informatica DVO ( Data Validation Option)

Automation: Implemented Automation Framework for Data Quality, Data Reconciliation & Data Validation

Data Quality: Informatica Data Quality (IDQ) 9.x ( Informatica Developer & Analyst tool), Informatica DVO (Data Validation Option)

Scheduling Tool: Autosys R11

Configuration management: IBM Rational ClearCase

Databases: Oracle 10g, 11g, 12c, Teradata 13.x, MS Access, SQL Server

Other Skills /Tools: SQL(Oracle, Teradata, SQL Server, MS Access), PL/SQL, Unix - Shell Scripting, Perl, SQL Developer, Teradata SQL Assistant, BTEQ, Toad, Informatica MDM 9.5, HP Quality Center, IBM Rational Clear Case, XML Spy, XML Viewer, MS Project, Rally, JIRA, Pandas, Anaconda, Spyder

FUNCTIONAL PROFICIENCIES:

  • Technical Leadership, Technical Management, Project Management
  • Technical Owner Delegate for multiple Data Warehouse Applications (Own & manage Access / Entitlements, Project Roadmaps, Revenue, Billability)
  • Release Planning, Solution construction, implementation, and systems integration
  • Requirement gathering from Business Users and Functional Translation
  • Requirement Identification, Analysis & Developing Solution Delivery
  • Design, coding, unit testing, system integration testing, code review, user acceptance testing support, production implementation, and post-implementation L3 support

PROFESSIONAL EXPERIENCE:

Confidential

ETL Application Lead /Technical Manager

Responsibilities:

  • Responsible for managing & leading a project team in delivering a solution to the client using the appropriate business measurements and terms and conditions for the project according to the project charter, project agreement or contract.
  • Responsible for managing several teams providing guidance and assistance including architecture, design, analysis on a daily basis.
  • Worked as Technical Lead across all the SDLC phases
  • Responsible for project planning, resource availability planning, roadmap forecast etc.
  • Provide technical solutions and lead the project activities as Dev POC throughout all the phases of the project.
  • Perform build /enhancement/defect fixes to ongoing Releases by following SDLC and policies and procedures and completing appropriate activities and associated documentation, as defined in the appropriate methodology.
  • Support system test of the enhancement Releases
  • Conduct performance analysis to determine if a new Release can meet existing Service Levels prior to production implementation
  • Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
  • Gather, Analyze and Build & document the ETL batch process, Data Model and architecture
  • Involve in Design, Develop of ETL processes with enterprise standards & best practices. Create proper scheduling of the 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 BI Reporting solution and scheduling using BOXI
  • Create Reconciliation framework that captures any fallouts between source to target loads at various stages like staging /mart and consumer tables.
  • Unit test the interface modules and coordinate with SIT team for testing activities.
  • Involved in SIT phase to coordinate the testing activities with testing teams. Created ETL cases, test scenarios and executed them with the 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

Skills: Informatica Powercenter 9.5, Informatica MDM 9.5,Unix Shell Scripting, Oracle 10 g

Responsibilities:

  • Participate in project planning, resource availability planning, determine artifact LOEs and finalize with client.
  • Provide technical solutions and lead the project activities as Dev POC throughout all the phases of the project.
  • 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 the data modeling sessions to understand the data model and providing them inputs based on the 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 the MDM/ETL batch process, Data Model and architecture
  • Design the ETL flow of extracting various Source data from Common Interface Layer up to the MDM Landing layer with data rejection handling as per different business scenarios
  • Design Type-II Slowly Changing Dimension (SCD) as part of the publish model
  • Design ETL flow to extract master data from MDM publish layer to various downstream systems like Veeva & Concur.
  • Build the 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 the requirements.
  • Unit test the interface modules and coordinate with SIT team for testing activities.
  • Involved in SIT phase to coordinate the testing activities with testing teams. Created ETL cases, test scenarios and executed them with the 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

Skills: Informatica Powercenter 9.1, Unix Shell Script, Teradata 13.x

Responsibilities:

  • Participate in project planning, resource availability planning, determine artifact LOEs and finalize with client.
  • Provide technical solutions and lead the project activities as Dev POC throughout all the phases of the project.
  • Gather, Analyze and document the 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 the 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 the 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 the workflow.
  • Developed various shell scripts in specific portions to implement critical business logics with Unix and Teradata BTEQ utility
  • Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query. Found the bottlenecks for the existing mappings to improve the performance of the 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 the same.
  • Worked with configuration management team to migrate the 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 the deadlines and the 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

Skills: Informatica Powercenter 8.6.2, Unix, Shell Script, Oracle 10g

Responsibilities:

  • Participate in project planning, resource availability planning, determine artifact LOEs and finalize with client.
  • Provide technical solutions and lead the project activities as Dev POC throughout all the phases of the project.
  • Understand the 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 the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions and database parameters.
  • Used Autosys to to control the overall ETL scheduling process
  • Updated SOP with the usage of new functionality for the 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

Skills: Informatica Powercenter 8.6.2, Unix, Shell Script, Oracle 10g

Responsibilities:

  • Participate in project planning, resource availability planning, determine artifact LOEs and finalize with client.
  • Provide technical solutions and lead the project activities as Dev POC throughout all the phases of the project.
  • Worked various SDLC phases of the 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 the 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 the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the 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

Skills: Informatica Powercenter 8.6.2, Unix, Shell Script, Oracle 10g

Responsibilities:

  • Participate in project planning, resource availability planning, determine artifact LOEs and finalize with client.
  • Provide technical solutions and lead the project activities as Dev POC throughout all the phases of the project.
  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema
  • Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
  • Analysis, Design and Development of the ETL components to load the 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 the 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 the 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

Skills: Informatica Powercenter 8.6.2, Unix, Shell Script, Oracle 10g

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 the 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 the applications to test:
  • Whether ETLs are accessing and picking up right data from right source.
  • All the data transformations are correct according to the business rules
  • Testing the rejected records that don’t fulfil transformation rules.
  • Integration testing for initial and incremental loading of the data warehouse.
  • Identity the requirement and prepared test scenarios.
  • Designing and execution test cases for data validation
  • Defect reporting and attending business calls.

Hire Now