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