We provide IT Staff Augmentation Services!

Etl Specialist Resume

Columbus, OH

SUMMARY:

  • Over 11 years of progressive experience in the IT industry with focus on analysis, modeling, design, development, implementation, testing, documentation, and maintenance of various Business Applications in an effective way to deliver leading edge software solutions.
  • Well versed with Data Warehousing Architecture on Design, Development and Extraction, Transformation and Loading of Data using ETL tools.
  • Extensive experience in designing and creating data marts using ETL tools Informatica Power Center Informatica 8.6.1, 9.0,9.1,9.6 and 10.1.
  • Extensive knowledge on SSIS, Informatica MDM, Informatica IDQ.ESP Scheduling.
  • Extensive experience in Informatica, Oracle 10g/9i/8.x/7.3, Teradata V2R5, SQL Server, DB2, UNIX, Linux Shell scripting, Perl, Ruby, Jenkins, Windows 2008/Vista/NT/XP/2000.
  • Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance. Experienced in using TOAD and SQL Developer.
  • Knowledge in designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.
  • Data processing knowledge in designing and implementing Data Warehouse applications, mainly Transformation processes using ETL tool Informatica.
  • Exposure to working in Onsite - Offshore model with daily co-ordination

TECHNICAL SKILLS:

ETL Tools: Informatica 6.2, 7.1.3, 7.1.5, 8.1, 8.6, 9.1.4, 9.6 and 10.1

Query Tools: TOAD, SQL*PLUS, SQL Developer and SQL Loader

Databases: Oracle 11g/10g, SQL Server 2005/ 2008, Teradata v2R5, v2R6, DB2

Ticketing Tools: Remedy, HP Quality center, Service now

Scheduling Tools: Cron, ESP, Jenkins, Informatica Scheduling

Testing Tools: Unit, System, Performance, Smoke testing, Functionality. User Acceptance

Others/ Languages: SQL, PL/SQL, RSPEC Ruby

Operating Systems: Windows NT/XP/2003 Server, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL Specialist

R esponsibilities:

  • Identified different source definitions to extract data from various input sources and load into various targets using Informatica.
  • Worked on Variables and parameters.
  • Designing of the ETL processes
  • Used different types of transformations such as Joiner, Lookup, Expression, Filter, Router, update strategy, Union, XML Parser, Normalizers, SQL Transformation,
  • Sorter, Aggregator etc...
  • Used UNIX shell script to ftp the reports to the clients’ servers.
  • Involved in Unit testing Functional testing.
  • Scheduled the Workflows in ESP.
  • Involved in Test Driven Development.
  • Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
  • Prepared Documents like Technical Design Doc, Production Support Doc, Deployment Doc
  • Documented Mappings, Transformations and Informatica sessions.
  • Involved in Performance tuning by determining bottlenecks in sources, mappings and sessions.
  • Coordinating the team in resolving technical/non-technical issues.

Environment: Informatica 9.6, Oracle SQL, UNIX, Oracle 11g, Teradata

Confidential, Columbus OH

ETL Specialist

R esponsibilities:

  • Identified different source definitions to extract data from various input sources and load into target Teradata and oracle databases tables using Informatica.
  • Worked on Variables and parameters.
  • Designing of the ETL processes
  • Used different types of transformations such as Joiner, Lookup, Expression, Filter, Router, update strategy, Union, XML Parser,
  • Sorter, Aggregator etc...
  • Used UNIX shell script to ftp the reports to the clients’ servers.
  • Involved in Unit testing Functional testing.

Environment: Informatica 9.1.4, Oracle, UNIX, Oracle 11g, Teradata

Confidential, New York

Senior Developer

R esponsibilities:

  • Load the data projections data in to CCAR Plot form.
  • Co-ordination with other teams like Java UI team and Spot fire team.
  • Designed the Mappings and sessions work lets and workflows.
  • Tested the Mappings in Development and SIT Environments
  • Prepared the migration check list.
  • Attended the daily Status calls

Environment: Informatica 9.1.4, Oracle SQL/ PL/SQL, UNIX, Oracle 11g

Confidential, New Jersey

Senior ETL Developer

R esponsibilities:

  • Converting High level design documents to low level design documents,
  • Designed the Mappings and sessions work lets and workflows.
  • Tested the Mappings in Development and SIT Environments
  • Prepared the migration check list.

Environment: Informatica 9.1.4, Windows 2003 Server, Oracle 11g.Linux, SQL Server

Confidential

ETL Delivery Lead

Responsibilities:

  • Requirements gathering and Designing source to target Mapping Documents.
  • Designed and Developed Mappings, Mapplets, Sessions, Worklets, Workflows, to extract,
  • Transform and Load the Data in the Data Warehouse.
  • Created Unit testing, Functional Testing Documents and Promotional Checklists, rollback Plan and Implementation Plan etc.
  • Preparing SMTDs for new on boarded Projects.
  • Assigning tasks to the team members.
  • Monitoring the production jobs.
  • Bug Fixing and break fix
  • Scheduling the workflows.
  • Conducting the weekly status calls.
  • Attending Operative forum meetings with Clients
  • Involved in Informatica tool migration 8.1 to 9.1.4
  • Involved Data migration from Oracle to SQL Server.
  • Actively involved in Administrative tasks.
  • Cleared the unwanted logs and files from UNIX server.
  • Creating the user folders for the new joiners and give the appropriate permissions.
  • Informatica server Up and Down whenever it is required.
  • Informatica Code migration from Dev to Test and Production.

Environment: Informatica 9.1.4, Windows 2003 Server, Oracle 11g.Linux, SQL Server

Confidential

ETL Delivery Lead

R esponsibilities:

  • Creating Technical design documents, Operations documents, Project estimation documents and enhancement related documents.
  • Developing Informatica 8.6 objects / Oracle 10g objects.
  • Preparing low level design documents and Unit test cases
  • Estimating the efforts and delegating work to team members accordingly.
  • Providing technical support to team members in resolving issues in coding.
  • Performing Gate review for the project deliverables
  • Taking calls with onshore in case of any issues/challenges related to day to day deadlines.

Environment: Informatica 8.6, Windows 2003 Server,Oracle 9i. Linux

Confidential

ETL Delivery Lead

Responsibilities:

  • Developed Mappings, Mapplets, Sessions, Worklets, and Workflows, to Extract, Transform and Load the Data in the Staging Tables
  • Involved in system testing
  • Involved in integration testing
  • Supporting the Developed Workflows

Environment: Informatica 8.6, Windows 2003 Server, Oracle 9i. Linux

Confidential, Ohio

ETL Project Lead

Responsibilities:

  • Requirements gathering and Designing source to target Mapping Documents.
  • Designed and Developed Mappings, Mapplets, Sessions, Worklets, Workflows, to extract,
  • Transform and Load the Data in the Data Warehouse.
  • Created Unit testing, Functional Testing Documents and Promotional Checklists, rollback Plan and Implementation Plan etc.
  • Preparing SMTDs for new on boarded Projects.
  • Assigning tasks to the team members.
  • Monitoring the production jobs.
  • Scheduling the workflows
  • Informatica administration.
  • Executing the manual month end loads.
  • Bug fixing and break fix.
  • Attending SRT calls.
  • Coordinating with onsite/offshore.
  • Coordinating with various teams.
  • Attending weakly status calls and capturing individual efforts.

Environment: Informatica 7.1.3 AS-400, HP-Unix, Teradata V2R6 Windows 2003 Server, Oracle 9i. Clarify 6

Confidential

ETL Developer

Responsibilities:

  • Identified different source definitions to extract data from various input sources and load into target tables (flat files) using Informatica.
  • Worked on Variables and parameters.
  • Designing of the ETL processes
  • Extract, cleanse, transform, integrate, and load data into flat files.
  • Used different types of transformations such as Joiner, Lookup, Expression, Filter, Router,
  • Sorter, Aggregator etc...
  • Used UNIX shell script to ftp the reports to the clients’ servers.
  • Involved in Unit testing Functional testing.

Environment: AS-400, HP-Unix, Oracle9i, Teradata V2R5, Informatica 7.1.3

Confidential

ETL Developer

Responsibilities:

  • Understanding the Requirement Analysis for the operations data warehouse project.
  • Used the Informatica to develop process for extracting, cleansing, transforming, integrating and loading the data into Teradata Data warehouse.
  • Involved in unit testing, functional testing.
  • Extract, cleanse, transform, integrate, and load data into oracle, flat files, Teradata.
  • Implemented change data capture techniques like SCD-1, SCD-2.
  • Worked with various tasks such as session task, command task, email task, event wait task etc.

Environment: AS-400, HP-Unix, Oracle9i, Teradata V2R5, Informatica 7.1.3

Hire Now