We provide IT Staff Augmentation Services!

Etl Informatica Lead Resume

Denver, CO

SUMMARY

  • TOTAL IT: 8 years of experience in IT industry in implementing Full Life Cycle (SDLC) Data Warehousing from Business Requirements Gathering & Analysis, Design, Development, Testing, Implementation and Production Support.
  • DW ETL: 8 years of experience in Data Warehousing and Data migration tools with expertise on Informatica and good hands on PL/SQL and Scripting.
  • Good hands on executing the Data Warehouse, Data Integration & Data Migration projects.
  • Expertise in developing Strategies for Extraction, Transformation and Loading mechanisms using Informatica PowerCenter (9.x/8.x/7.x). Strong experience in performance tuning of source, targets, mappings and sessions.
  • 5+ years of Experience in requirement gathering with business team and ETL technical Specification document developments, developing the High Level Design (HLD) and Low level Design (LLD).
  • Working Knowledge on different data sources such as Flat Files, Oracle, SQL Server, XML and Excel Files. Experience in Performance tuning of targets, sources, mappings and sessions. Have knowledge on SQL Server
  • Experience with Unix Shell Programs, Integrating Unix Shells with ETL jobs like Informatica, Sessions, Workflows and Control - M
  • Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
  • Leading the team at offshore/Lead. Managing the team of about 8-12 members.
  • Coordinating with offshore on project status and participating in all the projects review with offshore team (Century Link India).
  • Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Tuned mappings using Power Centre-Designer and used different logic to provide maximum efficiency and performance. Experience on the Informatica partitioning.
  • Excellent understanding of Data warehouse concepts and experience of executing 3 Life Cycle Data warehouse projects using Change Data Capture (CDC) method.
  • Good work experience on the Control-M scheduling Tool. Implemented scheduling in various projects using the Control-M.
  • Have experience on providing the Project LOE’s and creating the project plan, have a good knowledge about CMMi Process.

TECHNICAL SKILLS

Project Domain: Data warehousing & Business Intelligence, Data Migration

ETL Tool: Informatica Power Center 7.5/8.5/8.6/9.1

Languages: SQL, PL/SQL, LUNIX, Shall Scripts

Databases: Oracle 9i/10g/11g

Tools: Dimensions CM (PVCS), Remedy and Toad

Operating Systems: Windows XP/NT/2000, UNIX

Scheduling Tool: Control-M 6.x/7.1

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

ETL Informatica Lead

Responsibilities:

  • Understanding the business user use-case documents and analyzing the Functional specification documents.
  • Created Source to Target specification documents, High Level and Low Level design documents.
  • Leading team at offshore and working with them on development, Unit Testing and Implementation and making sure there are zero defects.
  • As a Lead Coordinator was working on Understanding the requirements, working on the High Level and Low Level Designs and working with off shore (Century Link India) on Implementing the projects
  • Provide comprehensive solution to all issues with a project plan and estimated time to deliver the solution.
  • Convert these as packets of work and get it completed through the Off-Shore maintenance and development teams.
  • Designed and Developed Mappings, sessions and workflows in Informatica for data migration
  • Provided support for the implemented code for defects and enhancements.
  • Worked closely with QA team during the testing phase and fixed bugs that were reported.
  • Created Reusable Transformations and Mapplets and used them in various Mappings to reduce the redundant work.
  • Created mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
  • Performed data validation, reconciliation and error handling in the load process.
  • Involved in the exception design and reprocessing the rejected rows to the target tables.
  • Involved in Exception handling and reprocessing in Informatica.
  • Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
  • Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
  • Implementing the scheduling by using Control-M.
  • Responsible for initiating meetings with the client for technical details Performing Software Configuration Management using PVCS Dimension
  • Raising Change Management Notice (CMNs) for implementation and creation of PVCS Package for Code Deployment.

Environment: Oracle 11g SQL, Informatica 9.1, UNIX Shell Scripts, Control-M

Confidential, Denver, CO

ETL Informatica Lead

Responsibilities:

  • Understanding the business user use-case documents and analyzing the Functional specification documents.
  • Involved in preparing Functional specification, High Level and Low Level Design document, test scenarios
  • Coordinating with offshore on project status and participating in all the projects review with offshore team (Century Link India). Have experience on providing the Project LOE’s and creating the project plan
  • Involved in creating the WBS and CBE for the project and maintaining all Engineering, Project Management Plan (PMP), Configuration Management Plan (CMP) and other artifacts.
  • Developed mappings, sessions and workflows in Informatica Power Center.
  • Implemented Type2 Dimension logic in mappings using Informatica Designer
  • Provided support for the implemented code for defects and enhancements.
  • Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
  • Provided support for migration of Informatica 8.6 to 8.6.1.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Independently perform complex troubleshooting, root-cause analysis and solution development.
  • Used Informatica reusability at various levels of development.

Environment: Oracle 10g SQL, Informatica 8.6, UNIX Shell Scripts.

Confidential, Denver, CO

Sr. ETL Informatica Lead /Developer

Responsibilities:

  • Created analysis of source systems, business requirements and identification of business rules.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter
  • Extensively used Control-M for Scheduling and monitoring
  • Designed and developed efficient Error handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.
  • 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.
  • Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads
  • Responsible for team members’ work assignment and tracking.
  • Responsible for Pre and Post migration planning for optimizing Data load performance, capacity planning and user support.

Environment: Oracle 11g, SQL, Informatica 9.1, UNIX Shell Scripts.

Confidential, Denver, CO

Sr. ETL Informatica Developer

Responsibilities:

  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Created complex mappings that involved implementation of Business Logic to load data in to staging area.
  • Used Informatica reusability at various levels of development.
  • Developed mappings/sessions using Informatica Power Centre 8.6 for data loading.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
  • Implemented slowly changing dimension methodology for accessing the full history of accounts.
  • Write Shell script running workflows in UNIX environment.
  • Optimizing performance tuning at source, target, mapping and session level
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Oracle 11g SQL, Informatica 8.6, UNIX Shell Scripts, UNIX, Windows-XP.

Confidential

Sr. ETL Informatica Developer

Responsibilities:

  • Extracted data from flat files and Oracle database using Informatica 8.5x and UNIX.
  • Created different jobs, workflows using Informatica to load fact tables.
  • Developed different workflows, worklets, sessions, mappings using Informatica power center to load data in datawarehouse.
  • Created Mappings corresponding sessions and workflows to load the data.
  • Running the workflows through the shell scripts
  • Raising the request for Control-M for scheduling the jobs.
  • Performed and written Unit Test Cases for mappings.
  • Involved in performance tuning of mappings and sessions.
  • Creating the release build packages by using the PVCS.
  • Unit and Integration testing has been extensively done at development level and coordinated with Quality team while performing System testing.

Environment: Oracle 10g SQL, Informatica 8.6, Dimension PVCS, Control-M, UNIX, Windows-XP

Confidential

Senior ETL Developer

Responsibilities:

  • Developed project that describes the high level requirements of the data warehouse systems.
  • Developed various mappings in efficient way using various transformations.
  • Designed system according to performance tuning of the mappings.
  • Developed mapping to load the data in slowly changing dimension tables.
  • Created mappings for loading the data for collection area, landing and adjustments and data mart, using CDC techniques.
  • Create and manage primary objects such as tables, views and indexes.
  • Used designer debugger to test the data flow and fix the mappings.
  • Postproduction support, enhancements and performance tuning.

Environment: Oracle 10g SQL, Informatica 8.6, UNIX, Windows-XP

Confidential

ETL Informatica Developer

Responsibilities:

  • Understanding the Functional specification, High level design document, test scenarios and expected results which will be used in system testing phase.
  • Involved in developing ETL Mappings.
  • Helping the AIP team for any production issue, analyzing the issues and giving permanent solutions.
  • Involved in helping production support team in Control-M.
  • Involved in system testing and integration testing phase and given support during UAT phase.
  • Responsible for forming SQL queries as per the criteria selected by user.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Monitored sessions using the workflow monitor which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
  • Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
  • Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
  • Involved in initiating the meetings with the client for technical details Performing Software Configuration Management using PVCS Dimension
  • Raising Change Management Notice (CMNs) for implementation and creation of PVCS Package for Code Deployment.

Environment: Oracle SQL, Informatica 7.1, UNIX Shell Scripts, UNIX, Windows-XP

Confidential

ETL Developer

Responsibilities:

  • Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
  • Implemented various mappings to load data from staging to target databases.
  • Developed change data capture solutions (CDC) for the project, which captures and analyzes changes from daily feeds to maintain history tables
  • Created different mappings to load data from Flat files to staging and assigning the segment values to Dim table
  • Developed mappings using SCD and inset/update logic to load data to dimension tables.
  • Developed sessions using Informatica power center for data loading.
  • Working with clients on any issues during the UAT phase

Environment: Oracle 10g SQL, Informatica 8.5, Serena Dimension PVCS, Shell Scripts, Control-M.

Hire Now