We provide IT Staff Augmentation Services!

Etl- Developer Resume

PROFESSIONAL SYNOPSIS:

  • Informatica Certified professional having around 8 years of experience in Data Warehouse/Data mart implementations teamed with Analysis, requirements gathering, Effort Estimation, ETL Design, development, System Integration testing, Implementation and production support
  • In - depth hands on experience in ETL/ELT architecture and development .
  • Worked on Administrative activities like creating deployment groups, assigning privileges and code migrations.
  • Experienced in performance tuning by implementing pipeline partitioning, push down optimization, persistence cache etc.
  • Experience in resolving on-going maintenance issues, bug fixes and bottlenecks at various levels like sources, targets, mappings and sessions.
  • Implemented audit and alert strategies throughout ETL processes.
  • Good Knowledge in implementing Slowly Changing Dimensions SCD (Type1 and Type 2).
  • Strong in Data Warehousing concepts as well as methodologies, Star Schema and Snowflake Schema dimensional models .
  • Experience in integration of various data sources like Oracle, xml, Excel, Teradata, DB2, Vsam, .csv, Text files and web services.
  • Experience in creating reusable transformations and complex mappings, sessions, and workflows for high volume and high complexity processing.
  • Capable of analyzing the business requirements and creating technical specification documents.
  • Hands on experience in using IDQ; used various Informatica Data Quality transformations like Parser, address validator, standardizer, labeller, Match, case, Merger and Exception transformation.
  • Experience in parsing Cobol copy books thru Informatica.
  • Worked on Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load, TPT to export and load data to/from different source systems including flat files.
  • Extensive experience of using Informatica PowerCenter 9.5.1/8.6.1/7. x and Tableau.
  • Hands on experience in Data profiling and Unix shell scripting.
  • Good knowledge on OBIEE/Siebel Analytics Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer
  • Experience in scheduling Informatica Jobs using DollarU and have good knowledge on Autosys.
  • Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes success / failure rates for analysis as maintenance part.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, Teradata, DB2, SQL Server

Tools: TOAD, Putty, Power Term, Harvest and HP-QC

Kintana, Toad, SQL: Assistant. DollarU, DACAutosys, Tidal, PVCS

Business Intelligence: OBIEE 11g/10g, Tableau, P6 Analytics

ETL Tools: Informatica Power Center 9.5.1/9.1/8.6/7. x/6.XAbintio, IDQ 9.5.1

Operating Systems: Windows NT/XP, UNIX AIX, AS400

Languages: C, SQL and PL/SQL, COBOL, Java, JCL

PROFESSIONAL EXPERIENCE:

Confidential

ETL- Developer

Environment: Informatica Power Center 9.5, Tableau, COBOL, Oracle11g, Teradata, SQL Server

Responsibilities:

  • Translated the business processes/SAS code into Informatica mappings for building the data mart.
  • Used Informatica powercenter to load data from different sources like flat files, COBOL files and Oracle, teradata into the Oracle Data Warehouse.
  • Implemented pushdown, pipeline partition, persistence cache for better performance.
  • Developed reusable transformations and mapplets to use in multiple mappings.
  • Implementing Slowly Changing Dimensions (SCD) methodology to keep track of historical data.
  • Assisted the QC team in carrying out its QC process of testing the ETL components.
  • Created pre-session and post-session shell scripts and email notifications.
  • Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
  • Involved in data quality checks by interacting with the business analysts.
  • Performing Unit Testing and tuned the mappings for the better performance.
  • Maintained documentation of ETL processes to support knowledge transfer to other team members.
  • Created Tableau extracts and developed reports by using Tableau.
  • Created sites and assign privileges to them on tableau.

Confidential

IT-Engineer

Environment: Informatica Power Center 9.5.1, OBIEE, Oracle10g/11g, TERADATA, TOADSQL-Assistant, Unix, PVCS, Kintana, Dollar Universe.

Responsibilities:

  • Designed the ETL architecture.
  • Implemented pushdown optimization (PDO), pipeline partition, cache techniques for efficient loading.
  • Used Informatica Data Quality (IDQ) transformations like Parser, address validator, standardizer, labeler, Match, case, Merger and Exception transformation for data quality.
  • Implemented automation, audit and alert strategies throughout ETL processes.
  • Implemented Java Transformation logic to transform the data.
  • Designed restart-ability through ETL processes.
  • Identify the data cleansing elements and prepare the specifications for data cleansing.
  • Extensively used Informatica to extract wide range of data from different sources like flat files, XML, Excel spread sheets, Teradata and Oracle into the Data Warehouse.
  • Performed Unit Testing and tuned the mappings for the better performance.
  • Coordinated with business analysts to gather the new requirements and to work with the existing issues.
  • Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
  • Involved in data quality checks by interacting with the business analysts.
  • Developed complex mappings to load Dimension & Fact tables.
  • Assisted the QC team in carrying out its QC process of testing the ETL components.
  • Created documents for complex transformations in ETL process to support knowledge transfer to other team members.
  • Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Scheduled the ETL Jobs using Dollar Universe.
  • Created pre-session and post-session shell scripts and email notifications.

Confidential

Project Lead

Environment: Informatica Power Center 8.6.1, OBIEE, Oracle9i/10g,DB2, TOAD 9.1 Windows XP, UNIX AIX, IBM Mainframe, Harvest, HP-QC, Autosys

Responsibilities:

  • Involved in Extraction, Transformation and Loading of data using Informatica.
  • Translated the business processes/requirements into Informatica mappings for building the data mart.
  • Involved in Unit, System integration and User Acceptance Testing for the project.
  • Extensively used Informatica to extract wide range of data from different sources like flat files, Excel spread sheets, and Oracle into the Oracle Data Warehouse.
  • Performed Unit Testing and tuned the mappings for the better performance.
  • Assisted the QC team in carrying out its QC process of testing the ETL components.
  • Maintained documentation of ETL processes to support knowledge transfer to other team members.
  • Used the Debugger to debug the mappings by setting Breakpoints across instances to identify the root cause of errors.
  • Developed simple & complex mappings to load Dimension & Fact tables.
  • Worked on different tasks in Workflow Manager like Sessions, Event raise, Event wait, Decision, Email, Command, and Worklets.
  • Communicate with the client for updating weekly status reports.

Confidential

Senior Developer

Environment: Informatica 8.1, Business Objects 6.1/XI, Oracle9i, TOAD 8.0, Windows XP, HP UNIX, IBM Mainframe

Responsibilities:

  • Parsing high-level design spec to simple ETL coding.
  • Translated the business processes into Informatica mappings for building the data mart.
  • Using Informatica to load data from different sources like flat files, Excel spreadsheets, Mainframe COBOL files and Oracle into the Oracle Data Warehouse.
  • Creating reusable transformations and mapplets to use in multiple mappings.
  • Implementing Slowly Changing Dimensions (SCD) methodology to keep track of historical data.
  • Assisted the QC team in carrying out its QC process of testing the ETL components.
  • Created pre-session and post-session shell scripts and email notifications.
  • Utilising TOAD to run SQL queries to validate the data.
  • Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
  • Involved in data quality checks by interacting with the business analysts.
  • Performing Unit Testing and tuned the mappings for the better performance.
  • Maintained documentation of ETL processes to support knowledge transfer to other team members.
  • Participated in performance tuning efforts.

Confidential

Senior Developer

Environment: Informatica Power Center 7.1.1/ 8, Business Objects 6.1/XI, Oracle9i, TOAD Windows XP, UNIX, IBM Mainframe, Harvest

Responsibilities:

  • Using Informatica to extract wide range of data from different sources like flat files, Excel spreadsheets, Mainframe COBOL files & Oracle into the Oracle Data Warehouse.
  • Creating reusable transformations and mapplets to use in multiple mappings.
  • Implementing transformations like Connected/Unconnected Look-up, Filter, Router, Update Strategy, Aggregator, Normalizer, Expression, Joiner & Stored Procedure.
  • Mapping for the implementation of type 2 slowly changing dimensions.
  • Working on different tasks in Workflow Manager like Sessions, Event Raise, Event Wait, Decision, Email.
  • Creating pre-session and post-session shell scripts and email notifications.
  • Using TOAD to run SQL queries to validate the data.
  • Handling the ETL process under development and testing environments.
  • Performing unit testing and tuning the mappings for the better performance.
  • Modifying the existing Informatica ETL Mappings and Workflows to work with modified database and source structures.
  • Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.
  • Modifying the overrides in sessions and mappings and validating them.
  • Involved in Unit, System, Integration and User Acceptance Testing for the project.
  • Modified the UNIX scripts used in the Informatica ETL process and in calling the SQL scripts. Updated the logic to in corporate these changes the scripts.
  • Reused the single workflow for loading data from various regions' files with similar file structure using indirect loading as source type in session properties.

Confidential

Developer

Environment: Informatica Power Center 7, Business Objects 6.1, Oracle, TOAD, Windows XP, HP UNIX, IBM Mainframe

Responsibilities:

  • Modifying the existing Informatica ETL Mappings and Workflows to work with modified database and source structures.
  • Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.
  • Modifying the overrides in sessions and mappings and validating them.
  • Involved in Unit, System, Integration and User Acceptance Testing for the project.
  • Modified the UNIX scripts used in the Informatica ETL process and in calling the SQL scripts. Updated the logic to in corporate these changes the scripts.
  • Reused the single workflow for loading data from various regions' files with similar file structure using indirect loading as source type in session properties.
  • Developed Unix Shell scripts and used them in Informatica Pre- & Post- Session command tasks and Standalone Command tasks.
  • Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

Hire Now