We provide IT Staff Augmentation Services!

Etl Developer Resume

Caremark, RI

SUMMARY OF QUALIFICATIONS:

  • Over Eight (8+) years of IT experience in Data Warehouse/ETL procedures, loading data from various sources into DW using Power Center Designer, Workflow Manager and Workflow Monitor
  • Expertise in developing Complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool for data extraction from various sources and loading into target tables
  • Experience in performance tuning of mapping and workflow to reduce the data load and process time
  • Worked and Implemented Pushdown Optimization (PDO) to optimize performance issues of complex mappings involving numerous transformations and hence degrading the performance of the session
  • Experience in creating various transformations using Aggregator , Look Up , Update Strategy , Joiner , Filter , Sequence Generator , Normalizer , Sorter , Router , Stored Procedure in Informatica Power Center Designer
  • Involved in data migration and data quality check through ETL processes
  • Expertise in DW concepts like Star Schema, Snowflake Schema, Fact Tables and Dimension Tables
  • Hands on Experience in ERWIN Data Modeling tool
  • Experience in understanding the Physical and Logical Data Models and assisting the modeling team in restructuring the Data Model
  • Experience using Teradata utilities (SQL, FastLoad, MultiLoad, TPump, and TPT).
  • Experience in gathering business requirements, establishing functional specifications and translating them to design specifications
  • Experience in creating sessions in Workflow Manager and running the workflows in Workflow Monitor and analyzing them. Hands on experience in various Active and Passive Transformations
  • Worked with re - usable objects like Re-Usable Transformation and Mapplets
  • Extensively used SQL Override function in Source Qualifier Transformation
  • Extensive ETL Testing experience using Informatica Power Center 8.6/7.1 components (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Sound Knowledge & Profound Experience in various phases of Software Development Life Cycle (SDLC)
  • Expertise in writing UNIX Shell Scripts for scheduling session for Work Flow
  • Experience in Production Support post implementation
  • Experience working with TOAD Querying Tool

TECHNICAL COMPETENCIES:

Tools: Informatic7.X/8.6/9.x, Informatica IDQ, PowerExchange, Toad, SQL Developer, SQL Assistant, Putty, Cygwin, OBIEE

Database: Oracle 11g/10i/9.x, DB2, Teradata V2R6

Methodologies: Data Modeling - Logical, Physical, Dimensional Modeling Star/Snowflake

Programming: UNIX Shell Scripting, SQL, T-SQL, C, C++

Operating Systems: UNIX, Windows XP/NT/2000/7

Functional Experience: Banking, Pharmacy, Insurance

PROFESSIONAL EXPERIENCE:

Confidential, RI

ETL Developer

Roles and Responsibilities:

  • Created design pattern templates for deliverable objects
  • Strong working experience with Informatica Power Center
  • Experience in wrapping the Informatica Workflows and UNIX scripts with Control framework
  • Involved in designing the process flow for extracting data across various interacting systems
  • Involved in extracting the data from Flat Files and loading into staging tables
  • Experience with SQL Override and source filter usage in Source Qualifiers and data flow management using Filter Transformation
  • Created and used reusable transformations for Data type conversions
  • Experience with transformations including complex Lookups, Stored Procedures, Update Strategy, etc.
  • Expert in designing and developing the reusable sessions and Worklets
  • Debugging the Informatica mappings and validating the data in target tables once it got loaded
  • Involved in performance tuning by identifying and optimizing source, target, mappings and session bottlenecks
  • Fine tuning Informatica mappings for Performance Optimization
  • Problem solving and troubleshooting design and development issues and providing appropriate solutions
  • Involved in deploying/migrating Informatica Workflows, Database Objects and Metadata within UAT and Production environment
  • Expert in switching the Metadata between different schemas in various environments like UAT and Production
  • Involved in deploying the Informatica Workflows using Subversion and Quick-build process.
  • Troubleshoot the issues by checking sessions, workflow logs and metadata
  • Actively participated in database activities like checking the Primary Indexes, correctness of the data and field size validation, etc.
  • Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
  • Worked closely with Production Control team to schedule Informatica Workflows and Shell Scripts (for Archive and Purge) in Control M
  • Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application

Environment: Informatica 9.5, DB2, UNIX, Control M

Confidential LA

ETL Developer

Roles and Responsibilities:

  • Requirement analysis, Impact Analysis and Preparing detailed design
  • Requirement gathering and detailed design walkthroughs for the team members, Coding and Testing of ETLs, Co-ordination of deployment activities with other teams, Data validation, Preparing Unit Test cases, Triaging of defects, Conducting code review sessions
  • Interacting with senior peers or subject matter experts to learn more about the data
  • Designing and creation of complex mappings using SCD Type II involving transformations such as Expression, Joiner, Aggregator, Lookup, Update Strategy, and Filter
  • Defined Target Load Order Plan for loading data into Target Tables
  • Used Informatica Power Center Workflow manager to create sessions, batches and workflows to run the logic embedded in the mappings
  • Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability
  • Performed functionality, Integration, positive and negative testing
  • Worked on issues with ETL and DB migration from development to SIT, SIT to Pre-Production and Pre-Production to Production environments
  • Reviewed ETL Mappings, Sessions, Unix Scripts, Test Results, Parameter Files, Test Cases, Mapping Specification Documents etc developed by team members
  • Assisted/groomed team members and provided guidance during ETL development
  • Check project progress, status reporting, risk identification and communicating to proper channel
  • Writing UNIX Shell Scripts for Informatica ETL tool to run the Sessions and also for job scheduling
  • Integrated Data Cleansing processes within the Mappings
  • Ensuring the SLA during production support during the release cycles

Environment: Informatica 8.6, Oracle DB, UNIX

Confidential LA

ETL Developer

Roles and Responsibilities:

  • Requirement gathering-analysis and detailed design walkthroughs for the team members, Coding and Testing of ETLs, Co-ordination of deployment activities with other teams, Data validation, Preparing Unit Test cases, Triaging of defects, Conducting code review sessions
  • Interacting with senior peers or subject matter experts to learn more about the data
  • Designing and creation of complex mappings using SCD Type II involving transformations such as Expression, Joiner, Aggregator, Lookup, Update Strategy, and Filter
  • Defined Target Load Order Plan for loading data into Target Tables
  • Used Informatica Power Center Workflow manager to create sessions, batches and workflows to run the logic embedded in the mappings.
  • Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability
  • Performed functionality, Integration, positive and negative testing
  • Worked on issues with ETL and DB migration from development to SIT, SIT to Pre-Production and Pre-Production to Production environments
  • Reviewed ETL Mappings, Sessions, Unix Scripts, Test Results, Parameter Files, Test Cases, Mapping Specification Documents etc developed by team members
  • Assisted/groomed team members and provided guidance during ETL development
  • Check project progress, status reporting, risk identification and communicating to proper channel
  • Writing UNIX Shell Scripts for Informatica ETL tool to run the Sessions and also for job scheduling
  • Integrated Data Cleansing processes within the Mappings
  • Ensuring the SLA during production support during the release cycles

Environment: Informatica 8.6, Oracle DB, UNIX, SQL Developer

Confidential CA

ETL Developer

Roles and Responsibilities:

  • Participated in the Data Model design according to the Business Requirements
  • Created Design Specification Documents including Source Target
  • Translated Business Requirements into Informatica mappings to build Data Warehouse using Informatica Designer which populated the data into the Target Star Schema on Teradata
  • Extensively used Router, Joiner, Lookup, Aggregator, Expression and Filter transformations in mappings
  • Extensively worked with performance tuning of the mappings by implementing the Hash Key Algorithms for the Flat Files
  • Debugged and resolved load failures by verifying the log files. Supported QA-Testing in fixing the bugs and also helped to resolve various data issues
  • Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
  • Maintained a very good interaction with Analysts, Project Managers, Architects and Testers to have efficient and better results
  • Partially Involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Data Warehouse

Environment: Informatica 8.x, Teradata V2R6

Confidential NY

ETL Developer

Roles and Responsibilities:

  • Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Worked with Data modeler, according to changes in the model worked on changes in the Informatica.
  • Imported the source definition into source analyzer from oracle
  • Imported the Target definitions into Target Designer from oracle and DB2
  • Working with Business Analyst, Translating Business requirements into Functional requirements.
  • Developed and Tested new mappings.
  • Created and configured the sessions for work flow.
  • Created and maintained parameter files for workflows in the UNIX and CVS.
  • Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup (static and Dynamic), Sequence Generator, Filter, Sorter, Source Qualifier.
  • Implemented slowly changing dimensions - Type I, II & III in different mappings as per the requirements.
  • Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
  • Created connections for relational, Non-relational and applications in the workflow manager.
  • Created mappings using Reusable Transformations.
  • Migrating mappings, workflows and parameter files from development to production.
  • Developed PL/SQL scripts line packages and store procedures for data updates.

Environment: Informatica 8.x, DB2, Flat files, UNIX, SQL Developer, OBIEE, HP QUALITY CENTER.

Confidential

Roles and Responsibilities:

  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
  • Tuning Informatica Mappings and Sessions for optimum performance.
  • Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
  • Extensively worked on the Repository Manager to create/modify/delete users/group/roles
  • Provided technical support to Quality Assurance team and Production group.
  • Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
  • Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
  • Created new mappings and updated old mappings according to changes in Business logic.
  • Created and monitored workflows and tasks using Informatica Power Center workflow manager

Environment: Informatica 8.x, ORACLE DB, Flat files, UNIX, SQL Developer, OBIEE, HP Quality Center

Hire Now