We provide IT Staff Augmentation Services!

Etl Informatica Tech. Lead Resume

4.00/5 (Submit Your Rating)

Philadelphia, PA


  • Over 10+ yearsof total IT experience in Business Requirements Analysis, Design, Development, Data Modeling of Data warehousing implementation across Insurance, Pharmaceuticals and Finance industries using Informatica PowerCenter 9.x/8.x/7.x.
  • 9+ years of strong Data Warehousing experience using Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Power plugs, Mapplet, Transformations). 3+ years of experience in Software Quality Assurance and Testing.
  • Extensively worked in designing and developing complicate ETL mappings using various sources into Data Warehouses and Change data Capture (CDC).
  • Experience on Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling. Entity - Relationship Modeling, ETL Process and reporting primarily using Informatica, working experience with Erwin 4.x/3.x, thorough understanding ofKimball and Inmonmethodologies.
  • Knowledge of OLAP concepts. Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Design, Development, Implementation and Testing.
  • Strong experience developing complex mappings using transformations likeSource Qualifier, Filter, Expression, Joiner, Router, Union, Unconnected / Connected Lookups & Aggregator, Data Extraction, Transformation and Lading with Oracle and Flat Files using Informatica.
  • Actively involved in Performance Tuning and Error Handling.
  • Data Modeler with strong Conceptual, Logical Data Modeling skills and experience in requirements gathering, source to target mapping, writing functional specifications, queries.
  • Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data Staging for operational sources using ETL and data mining features for data warehouses.
  • Extensive database experience using Oracle 10G/9i/8i, Netezza, SQL, PL/SQL, Stored Procedures, Packages, Database Triggers, SQL*Plus, SQL*Loader and OS like Win7/xp.
  • Strong experience in using Informatica mapping variables/parameters and session variables good in writing DOS commands, UNIX Shell scripting. scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Control-
  • Expertise in building Enterprise Data Warehouses (EDW), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
  • Experience on Quality Assurance Testing. Logging defects using the bug tracking database, providing verifications on fixes in multiple environments, and communicating fix success, failures, status updates as appropriate using Bug tracking tools like Test Director and Quality Center.
  • Proven ability to multi-task, team player and able to work with large or small teams and independently, Excellent communication, interpersonal and analytical skills. Strong team player


ETL: Informatica Power Center 8.6/8.1/8.0/7.1/7.0, Designer, Repository Manager, Repository Server, CDC, Workflow Manager & Workflow Monitor, Informatica Data Quality 8.5, Informatica MDM

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

BI: Business Intelligence experience in Business Objects 6.0/5.1/4.1, Retrieving data using Universes, Personal data files and Freehand SQL methods

Programming: SQL, PL/SQL, SQL Plus

OS: UNIX, LINIX, AIX, Windows XP/2007/2003/2000/NT

Testing tools: Quality Center/Test Director, Quick Test Pro

Database: Oracle 11g/10g/9i/8i/7.x, SQL Server 2008/2005, DB2 8.0/7.0, MS Access 7.0/2000


Confidential, Philadelphia, PA

ETL Informatica Tech. Lead

Roles & Responsibilities:

  • Worked extensively on Informatica tools - Designer, Workflow Manager, and Workflow Monitor.
  • Understanding present process flow and business functionalities of EUS model and prepare ETL process flow for predictive analysis.
  • Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, Router, Lookups and Stored procedure transformations.
  • Involved in designing Conceptual, Logical and Physical model for Staging and PA EUS Target database.
  • Created ETL Standards in naming conventions document.
  • Developed Mappings/Workflows/Scheduling ETL process.
  • Developed transformation logic and designed various Mappingsin theDesigner.
  • Worked on various transformations likeAggregator, Filter, Expression, Source Qualifier, Router, Lookup, Update Strategy, and Sequence Generator.
  • Worked extensively on slowly changing dimensions.
  • Involved in performance tuning and finding out the bottlenecks.
  • Involved in scheduling the job using JAMS.
  • Developed reusable transformations, mapplets and Worklets.
  • Involved in database tuning, ETL mapping tuning, and Report generation performance issues.
  • Worked cooperatively with the team members to identify and resolve issues relating to informatica and other database related issues.
  • Extensively worked with Informatica to load data from flat files, Oracle to target database.
  • Involved in performing unit testing and system integrated testing.
  • Maintained versions of mappings, Mapplet, workflows, sessions.

Environment:Informatica Power Center 9.1.5, SQL Server 2008, Linux, Microsoft Visio 2007, Windows XP

Confidential, Brea, CA

Informatica Developer

Roles & Responsibilities:

  • Involved in the requirement definition and analysis of Data Warehousing efforts.
  • Developed ETL mappings, transformations using Informatica Power Center.
  • Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet
  • Designer and Transformation Developer
  • Developed data Mappings between source systems and warehouse components using Mapping Designer.
  • Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator and Source Qualifier.
  • Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic
  • Coded into mappings.
  • Created and ran sessions and workflows using Workflow Manager.
  • Monitored the sessions and workflows using Workflow Monitor.
  • Involved in the Performance Tuning.
  • Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mapping.
  • Scheduled the ETL jobs daily. Weekly and monthly based on the business requirement.
  • Responsible for identifying and removing bottlenecks, fine-tuning the Mappings and Sessions, SQL queries for improved performance.
  • Generated completion messages and status reports using Workflow Manager.
  • Worked closely with business objects developer in identifying Dimensions and Facts.
  • Generated Adhoc report queries from business object universe and verified.
  • Extensively worked on prompts, calculations, filters based on the user needs and data relevancy.
  • Provided end-user training and support.

Environment: Informatica Power Center 7.1, Business Objects, Oracle 9i,, Windows XP, TOAD, Solaris8.

Confidential, Dallas, TX

ETL Informatica Developer

Roles & Responsibilities:

  • Analyzed the Business Requirement Document, Functional Specification documents to prepare Test Cases based on the Test Plans and Use Cases.
  • Involved in Test Plans and wrote Test Cases based on the requirement.
  • Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
  • Designed and developed a robust end-to-end ETL process for the efficient extraction, transformation and loading of source data to the staging and then to the data mart.
  • Created numerous Informatica mappings using XML files, Flat files, Oracle as sources and targets.
  • Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
  • Created source definitions from the operational sources and target definitions.
  • Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Data Warehousing system.
  • Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
  • Worked extensively on slowly changing dimensions.
  • Involved in performance tuning and finding out the bottlenecks.
  • Extensively usedSQLandPL/SQL scripts.
  • Done data validation for the Business Objects reports.
  • Analyzed and checked all test plans, test cases and provided the bug report to the management.
  • Conducted Regression Testing and interacted with developers to resolve the issues.
  • Effectively coordinated with the development team for closing a defect.
  • Prepared test cases to test the backend Oracle Database by retrieving the data from the tables using TOAD.
  • Participated in Functional Walk-through to validate the application design against the Test Cases.

Environment: Quality Center 9.2, SQL, UNIX, MS Office, DB2/AS400, Netezza, Informatica Power Center 8.6, Business Objects.


QA Tester

Roles & Responsibilities:

  • Identified the Test requirements based on business requirements.
  • Performed Manual Testing and maintained documentation on different types of Testing viz., Positive, Negative, System, User-acceptance, and Black Box.
  • Developed Test Objectives, Test Cases and Test Procedures after analyzing the applications.
  • Involved in system testing of the entire application along with team members.
  • Performed manual testing of applications.
  • Developed test scenarios and test procedures based on the test requirements.
  • Participated in preparing Test Plans.
  • Performed User Acceptance Testing (UAT) to test whether it meets the user requirement specification.
  • Performed data driven testing and regression testing using WinRunner and interacted with developers to resolve the issues.
  • Documented errors and implemented their resolutions.
  • Wrote SQL queries to validate data.
  • Participated in regular meetings with the development team and management to improve the testing effort of the application.
  • Participated in user training and submitted weekly status reports.

Environment: Test Director, Winrunner, Windows98, SQL, VB 6.0, UNIX and WINDOWS NT/2000.

We'd love your feedback!