We provide IT Staff Augmentation Services!

Sr. Etl Consultant Resume

0/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • 12+ years of IT experience in analyzing, designing, developing, migrating, utilizing, and maintaining applications involving complete project life cycle.
  • Proficient in multiprogramming skills.
  • Eight years of extensive experience in loading and maintaining Data Warehouses and Data Marts using Confidential Websphere DataStage 8.5/8.1/7.5/7.0/6.0 (Manager, Designer, Director, Administrator)
  • Architecture and Design Ability to provide Leadership in Technical Solutions Architecture in Design, development, Testing and Implementation of Large Scale Data Warehouse, Data Marts, Operational Data Store and Client Server applications.
  • Expertise in working wif Advanced Data Stage Enterprise Edition Parallel Extender Data Stage ETL Tool, Performance Tuning teh Parallel Extender DataStage ETL Jobs.
  • TEMPEffective Project Leader wif keen ability to identify goals, visualize teh solution, develop execution strategies, estimate resources and deliver projects on time and wifin budget
  • Expertise in working wif Oracle 11g, SQLServer, DB2.
  • Experience in Installing, configuring, Administrating and upgrading Datastage/ Infosphere
  • Involved in Analyzing Designs, Database Structures, Data Definitions, Data Models, Complex Business Requirements and creating teh ETL Process flows for teh Data warehouses and Data Marts.
  • Experience in Evolving Strategies and developing Architecture for building a Data warehouse, Star schema and Snow flak Schema by using data modeling tool Erwin.
  • Expertise in Documenting teh Program Specifications according to teh Process Flows.
  • Expertise in developing Unit Test Plans (UTP) and Unit Test Cases (UTC) in verifying teh program logic.
  • Hands on experience in Developing Triggers, UNIX Shell Scripting Procedures, Functions, SQL Loader Scripts.
  • Applied and Demonstrated Technical, Logical, Analytical and Problem solving skills.
  • Excellent Interpersonal, Planning, Organizational, Verbal and Written Communication skills.

TECHNICAL SKILLS

ETL: Confidential Websphere Data Stage EE Parallel Extender (6.0/7.1/7.5/8.1/8.5 Versions)

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, Physical and Logical Data Modeling, ERwin 4.1/3.5/3.x

Languages: C, COBOL, ASP, Visual Basic, Perl, SQL, T-SQL, PL/SQL, SQL*Loader, Toad

Databases: Oracle 7.X/8i/9i/10g/11g, SQL Server 6.5/7.0, DB2 UDB 8.1,Teradata

Applications and Tools: Microsoft Office (Excel, Word, PowerPoint, Microsoft Visio Standard 2002, Microsoft Visio Standard 2003)

Operating Systems: Windows XP, NT, 2000,2003, MS-DOS, AIX 5.2, Sun Solaris 2.6/2.8, HP-UX 11.11i

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. ETL Consultant

Responsibilities:

  • Design and buildTEMPeffectiveData Integration solutionsdat can make migration process an efficient and TEMPeffective from performance and costperspective.
  • Analyze teh artifacts, procedures and complexities of teh existing mainframe components and prepare teh feasibility report for migration.
  • Provide comparative analysis of teh files structures and source and target data from Mainframe and DataStage requirements perspective.
  • Design and build ETL solutions according to teh DI development standards to meet teh metadata requirements and data lineage.
  • Capture or define Business terms and metrics in Business Glossary, create data stewards,convert these business requirements into technical requirements or DataStage jobs in a common format using FastTrack and store all dis information in Metadata Repository for Data Lineage.
  • Lead teh development activity and provide teh advisory services to teh team.
  • Responsible for code reviews-to verify teh functionality and to check if teh code confirms to teh performance and development standards.
  • Define teh technical architecture andprepare HLD and LLD documents toprovidea better understanding of teh requirements and design.
  • Create DataStage components efficiently and make them reusable and restartable.
  • Build NDM scripts to move files between Mainframe &Linux serversand failover nodes.
  • BuildAutoSys Jils toschedule teh jobsand make them compatible across all environments.
  • Define thetest cases to test teh DS jobsin lowertestenvironmentsanddocument teh test results.
  • Educate/Trainproduction support and testing teams wif right information andknowledgetomake teh testing and support activities more TEMPeffective and less confusing.

Environment: Infosphere Information Server 8.5, Linux, Clearcase,Windows XP,DB2 V9.1, Autosys

Confidential, Harrisburg, PA

Production Support

Responsibilities:

  • Work wif teh Business analysts, process teams and data team to better understand teh Business requirements and hence determine teh appropriate data source and conversion approach.
  • Created UNIX wrapper scripts to validate all teh source files and reject teh files based on teh business needs.
  • Created DataStage jobs, batches and job sequences and tuned them for better performance.
  • Worked wif Datastage administraor/webconsole to set teh user privilege and project level administration.
  • Worked wif DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
  • Written Korn scripts for Scheduling DataStage server jobs.
  • Used Job Control routines and Transform functions in teh process of designing teh job.
  • Responsible for Defects Tracking using ClearQuest.
  • Responsible for creating DS job run scripts and scheduling them using dollar universe

Environment: Ascential DataStage Enterprise Edition 8.1,AIX 6.1, Clearcase, ClearQuest,Windows7

Confidential, Ashburn, VA

Sr. Datastage Consultant

Responsibilities:

  • Responsible for documenting, Design Specifications or Approach, Source to Target Mapping, Table Level Metadata, Column Level Metadata, and Transformation Rules.
  • Create High Level, Low Level data conversion design documents based on teh inputs from teh technical and non-technical teams.
  • Lead teh onshore-offshore teams on teh development of teh components.
  • Involved in analyzing teh daily defects of teh production support and finding teh root cause.
  • Created DataStage jobs, batches and job sequences and tuned them for better performance.
  • Used Job Control routines and Transform functions in teh process of designing teh job.
  • Responsible for Unit Test Plans.
  • Responsible for Defects Tracking using Test Director
  • Provided post-production support to teh project.
  • Responsible for creating DS job run scripts and scheduling them in using Cron jobs

Environment: Ascential DataStage Enterprise Edition 8.5, Sun Solaris 5.10, CVS, Test Director,Windows7

Confidential, Mechanicsburg, PA

Datastage Team Lead

Responsibilities:

  • Work wif teh Business analysts, process teams and data team to better understand teh Business requirements and hence determine teh appropriate data source and conversion approach.
  • Designing teh architecture of dataflow from Source to Target.
  • Data conversion from Legacy system to new modernization system.
  • Participated throughout teh project life cycle from requirements to production implementation wif emphasis on development.
  • Coordinated wif teh team members to translate business requirements into data mart design.
  • Created transformation jobs to create load ready files.
  • Created UNIX wrapper scripts to validate all teh source files and reject teh files based on teh business needs.
  • Created DataStage jobs, batches and job sequences and tuned them for better performance.
  • Worked wif Datastage administraor/webconsole to set teh user privilege and project level administration.
  • Worked wif DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
  • Written Korn scripts for Scheduling DataStage server jobs.
  • Used Job Control routines and Transform functions in teh process of designing teh job.
  • Responsible for Defects Tracking using ClearQuest.
  • Provided post-production support to teh project.
  • Responsible for creating DS job run scripts and scheduling them using dollar universe

Environment: Ascential DataStage Enterprise Edition 8.1,AIX 6.1, Clearcase, ClearQuest,Windows7

Confidential, Minneapolis, MN

Sr. Datastage Consultant

Responsibilities:

  • Participated in Business and technical requirements.
  • Facilitate group sessions to clarify business rules and data design requirements whenever necessary.
  • Responsible for documenting, Design Specifications or Approach, Source to Target Mapping, Table Level Metadata, Column Level Metadata, and Transformation Rules.
  • Participated throughout teh project life cycle from requirements to production implementation wif emphasis on development.
  • Coordinated wif teh team members to translate business requirements into data mart design.
  • Created transformation jobs to create load ready files.
  • Used Configuration files to distribute load among different processors by implementing pipeline and partitioning of data in enterprise edition.
  • Used Operators like Look-up stages, File stage, Funnel Stage, Data Set stage and Merge Stage
  • Created DataStage jobs, batches and job sequences and tuned them for better performance.
  • Worked wif DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
  • Used teh Data Stage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions (on an ad hoc or scheduled basis).
  • Written Korn scripts for Scheduling DataStage server jobs.
  • Used Job Control routines and Transform functions in teh process of designing teh job.
  • Responsible for Unit Test Plans.
  • Responsible for Defects Tracking using ClearQuest.
  • Provided post-production support to teh project.
  • Responsible for creating DS job run scripts and scheduling them in Autosys

Environment: Ascential DataStage Enterprise Edition 7.5.1A, Parallel Extender 6.0, DB2 UDB 8.2, UNIX, Korn Shell, ClearCase, ClearQuest Windows NT 4.0/2000.

Confidential, Minneapolis, MN

Sr. Datastage Consultant

Responsibilities:

  • Participated in Business and technical requirements.
  • Responsible for documenting, Design Specifications or Approach, Source to Target Mapping, Table Level Metadata, Column Level Metadata, and Transformation Rules.
  • Responsible for creating load ready files
  • Working on Multiple Maintenance Request.
  • Tracking teh changes and preparing teh checklist for implementation.
  • Coordinated wif teh team members to translate business requirements into data mart design.
  • Created transformation jobs to create load ready files.
  • Used Configuration files to distribute load among different processors by implementing pipeline and partitioning of data in enterprise edition.
  • Created DataStage jobs, batches and job sequences and tuned them for better performance.
  • Worked wif DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
  • Used teh Data Stage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions (on an ad hoc or scheduled basis).
  • Written Korn scripts for Scheduling DataStage server jobs.
  • Used Job Control routines and Transform functions in teh process of designing teh job.
  • Responsible for Unit Test Plans.
  • Responsible for Defects Tracking using ClearQuest.
  • Provided post-production support to teh project.
  • Responsible for creating DS job run scripts and scheduling them in Autosys

Environment: Ascential DataStage Enterprise Edition 7.5.1A, Parallel Extender 6.0, DB2 UDB 8.2, Teradata, UNIX, Korn Shell, ClearCase, ClearQuest Windows NT 4.0/2000.

Confidential, Minneapolis, MN

Datastage Consultant

Responsibilities:

  • Involved in development phase for Business Analysis and Requirements Gathering.
  • Coordinated wif teh team members to translate business requirements into data mart design.
  • Involved in logical and physical models using Erwin data modeling tool.
  • Responsible for designing teh mappings between sources (external files and databases) to operational staging targets.
  • Responsible for creating extract jobs from Oracle database.
  • Created transformation jobs to create load ready files.
  • Used FTP plug-in to transfer data between teh servers.
  • Used Configuration files to distribute load among different processors by Implementing pipeline and partitioning of data in enterprise edition.
  • Used Operators like Look-up stages, File stage, Funnel Stage, Data Set stage and Merge Stage
  • Created DataStage jobs, batches and job sequences and tuned them for better performance.
  • Developed various jobs using different Built-in and Custom defined transformations such as Date and String.
  • Worked wif DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
  • Used teh Data Stage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions (on an ad hoc or scheduled basis).
  • Written Korn scripts for Scheduling DataStage server jobs.
  • Creating and loading data warehouse tables like dimensional, fact and aggregate tables using Ascential Data Stage.
  • Used Job Control routines and Transform functions in teh process of designing teh job.
  • Responsible for Unit Test Plans.
  • Responsible for Defects Tracking using Test Director. Involved in teh System Testing of 110 Datastage jobs and 17 sequencers for teh Merge and Acquisition Subject Areas and fixed any defects in System Test phase.
  • Reviewed existing jobs and made fixes for better performance.
  • Provided post-production support to teh project.

Environment: Ascential DataStage Enterprise Edition 7.5.1A, Parallel Extender 6.0, SQL*Loader, Oracle 9i, ERWIN 4.0, UNIX, Korn Shell, Windows NT 4.0/2000.

Confidential

Application Developer

Responsibilities:

  • Preparation of program specifications / Low level design
  • Front end and Database Design.
  • Development of teh school asset management, time table allocation for teachers, students.
  • Code developing as per teh standard
  • Conducting assigned test and removing bugs identified.

Environment: Visual Basic 6.0, Oracle 8, Windows NT 4.0/2000.

Confidential

Application Developer

Responsibilities:

  • Requirement Analysis, Database design
  • Preparation of program specifications / Low level design
  • Development and Integration
  • Scheduling teh project and allocating teh necessary resources
  • Conducting assigned test and removing bugs identified.

Environment: Visual Basic 6.0, MySQL, Windows NT 4.0/2000.

Confidential

Application Developer

Responsibilities:

  • Preparation of program specifications / Low level design
  • Design and development
  • Development of teh Purchase Order processing, Bill of Material calculation, Personnel management system.
  • Integration
  • Conducting assigned test and removing bugs identified.

Environment: ASP 3.0, Oracle 8, Windows NT 4.0/2000.

Confidential

Application Developer

Responsibilities:

  • Involved in development phase for Business Analysis and Requirements Gathering.
  • Created Design Specification in High/Low Level.
  • Design of Database, studying teh System Specification.
  • Setting up teh test environment and test data.
  • Unit Testing.

Environment: ASP, Oracle 8i, Java Script Windows NT 4.0/2000.

We'd love your feedback!