We provide IT Staff Augmentation Services!

Senior Datastage Consultant Resume

Southbury, CT

SUMMARY

  • Over 10+ years of experience in Systems Analysis, Design, Development, Testing and implementation of Data Warehouse applications.
  • Extensive ETL tool experience using Confidential InfoSphere / WebSphere DataStage and Quality Stage
  • Worked on Datastage client tools like Datastage Designer, Datastage Director and Datastage Administrator.
  • Good Knowledge about Data Warehouse, Data marts, OLTP, OLAP, Dimensional Modeling, Fact tables, Dimension tables and Star/Snowflake schema modeling.
  • Excellent in using highly scalable parallel processing infrastructure using parallel jobs with multi - node configuration files.
  • Experienced in scheduling sequence, parallel and server jobs using Datastage Director, UNIX scripts and Autosys scheduling tools.
  • Designed and developed parallel jobs, server and sequence jobs using Datastage Designer.
  • Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, Sort, Copy, Remove duplicate, Funnel, Filter, Pivot, Shared containers for developing jobs.
  • Worked and extracted data from various data sources such as Oracle, DB2, Teradata, XML and Flat files.
  • Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing and Performance Testing.
  • Created local and shared containers to facilitate ease and reuse of jobs.
  • Proven track record in addressing production issues like performance tuning, enhancement and memory issues.
  • Imported the required Metadata from heterogeneous sources at the project level.
  • Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
  • Experience in Production Support, extensively worked on production support issues.
  • Giving the value additions to the project by preparing the understanding documents and providing Knowledge transfer to the new resources in the project regarding the functional and technical aspects of the project flows
  • Quick learner and adaptive to new and challenging technological environments.
  • Project Management experience with excellent problem-solving, organization and leadership skills.

TECHNICAL SKILLS

 

ETL Tools: Confidential InfoSphere Datastage 11.5/9.1/7.5.2/7.1.1 , Parallel Extender

Reporting Tools: Oracle Essbase, Business Objects

Databases: Teradata, SQL Server, Oracle, DB2 on Mainframe

Operating Systems: Windows, Confidential AIX, SUSE Linux

Data Modeling Method: Logical, Physical Data Modeling, Star-Schema Modeling

Languages: SQL, PL/SQL, C, C++, Korn/Bash Shell Scripting

Scheduler: Autosys, Cron, Control M.

PROFESSIONAL EXPERIENCE

Confidential, Southbury, CT

Senior DataStage Consultant

Responsibilities:

  • Analyze and provide ETL architecture for all Invoices stream processing that runs periodically.
  • Design and develop reusable components for data sourcing, cleansing, and integration related to all ETL processes.
  • Define programming standards, procedures and best practices in support of ETL processes.
  • Assist the business analyst in mapping the data from source to target and prepare prototype models to support the development efforts
  • Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
  • Implemented data staging, cleansing and transformation mechanisms, normalized databases, Star/ Snowflake schemas, and Business Intelligence delivery mechanisms as required, including loading of data marts.
  • Develop complex ETLs by using DataStage parallel extender parallel processing capabilities.
  • Help team members in tuning and improve performance for handling high-volume ETL jobs
  • Extensive working experience in various industries like TAX Invoice Auditing.
  • Experienced in scheduling sequence, parallel and server jobs using DatasStage Director, UNIX scripts and scheduling tools.
  • Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
  • Experienced in creating Sequence files and XML Files as outputs for submissions.
  • Experience in integration of various data sources like DB2, MS Excel and Flat files into the Staging Area.
  • Imported the required Metadata from heterogeneous sources at the project level.
  • Experienced in scheduling Jobs using AutoSys.
  • Resolve technical and functional issues with the design through test phase of development
  • Help team members in tuning and improve performance for handling high-volume ETL jobs .
  • Work closely with project management, analysts, data modelers and the existing ETL Developers and Designers and to understand project requirements and contribute to the project solution
  • Experience in resolving Data Transformation, Cleansing and Capturing rejects and Exception and Error reporting.
  • Good experience in Transforming Business specific rules into functional Specs.
  • Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs.
  • Ability to work autonomously and as part of a team under tight deadlines to meet any project expectations.
  • Co ordinating with Offshore teams for getting the Business requirements and Deliverables as well to be completed timely.

Environment: Confidential Infosphere Data Stage and Quality Stage 11.5, DB2, Java, MS-Access, Unix Shell scripts, PUTTY, WinSCP, ERwin R8.1, HP Quality Center, AutoSys, QMF Work Station, Eclipse.

Confidential, Boston, MA

Senior Datastage Consultant

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) of various projects, including requirements gathering, system designing, data modeling, ETL development, production enhancement, support and maintenance.
  • Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
  • Experience with Star and Snowflake Schema, Data Modeling, Fact and Dimensional Tables and Slowly Changing Dimensions.
  • Experience includes working in various industries like Financial, Supply chain management, Healthcare, Insurance and Retail.
  • Experienced in scheduling sequence, parallel and server jobs using Datastage Director, UNIX scripts and scheduling tools.
  • Extensively worked on performance tuning and backup on databases like Oracle 11g/10g/9i/8i.
  • Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter.
  • Experience in integration of various data sources like Teradata, Oracle, DB2, SQL Server, MS Access, Sybase, Informix, MS Excel and Flat files into the Staging Area. Extensively worked with materialized views and TOAD.
  • Imported the required Metadata from heterogeneous sources at the project level.
  • Good experience in scheduling Jobs using AutoSys, Tivoli, Zeke and Crontab.
  • Knowledge in using PL/SQL to write stored procedures, functions, and triggers.
  • Generated Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.
  • Created local and shared containers to facilitate ease and reuse of jobs.
  • Experience in resolving Data Transformation, Cleansing and Capturing rejects and Exception and Error reporting.
  • Extensively worked on SAP MDM Pack to deliver data to online analytical processing (OLAP).
  • Good knowledge on reporting tools like, Business Objects, and Oracle Oracle Essbase.
  • Good experience in Transforming Business specific rules into functional Specs.
  • Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs.
  • Working experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
  • Ability to work autonomously and also as part of a team under tight deadlines so as to meet any project expectations.

Environment: Confidential Infosphere Data Stage 11.5/9.1, Microsoft SQL 2012/2008, AIX6.0, Oracle 11g, Toad 9.5, Java, MS-Access, shell scripts, PUTTY, WinSCP, ERwin R8.1, HP Quality Center, AutoSys

Confidential

Senior Datastage Consultant

Responsibilities:

  • Involved in data profiling, modeling, planned and designed the batch/runs as per requirements.
  • Designed and developed the ETL jobs using Parallel Edition, which distributed the incoming data concurrently across all the processors, to achieve the best performance.
  • Preparation of technical specification for development of Extraction, Transformation and loading (ETL) jobs to load into various tables in DataMart.
  • Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture (CDC), Modify, Row Generator and Aggregator.
  • Involved in development of UNIX shell script for Batch jobs run.
  • Responsible for generation of DDL statements, which are executed, for database creation.
  • Designed the ETL jobs using Confidential InfoSphere DataStage 8.5 to extract, Transform and load the data into staging, ODS and EDW.
  • Responsible for preparing Physical/logical data models.
  • Responsible for data analysis, requirements gathering, report analysis, source-to-target mapping, frequency analysis, process flow diagrams, and documentation.
  • Handled Performance Tuning of Jobs to ensure faster Data Loads.
  • Designed sequence jobs using the activities such as Job Activity, Nested Condition, Notification Activity, Sequencer Activity, Terminator Activity and Execute Command.
  • Used Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
  • Effectively worked on Quality Stage for standardization and cleansing the data.
  • Performed the Integration and System testing on the ETL jobs.
  • Responsible for preparing ad hoc jobs.
  • Used Teradata PMON to monitor the performance by using explain plan by tuning many SQL queries.
  • Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Datastage ETL tool.
  • Migrated projects from development to QA to Production environments.
  • ETL code peer review.
  • Assisted operation support team for transactional data loads in developing SQL & UNIX scripts.
  • Imported the required Metadata from heterogeneous sources at the process level.
  • Created Job Parameters and Environment variables to run the same job for different sources and targets.
  • Designed a job template that provides the Environmental parameters for the subsequent use in the projects.
  • Created Shared Containers for Re-using the Business functionality.
  • Collaborated with BO team to design Crystal Reporting and reports for enterprise reporting applications.
  • Worked with Developers to troubleshoot and resolve issues in job logic as well as performance.

Environment: Confidential Infosphere Datastage 9.1/8.5 (Administrator, Designer, Director), Microsoft SQL 2008, Oracle 10g, Teradata, MS-Access, shell scripts, Putty, WinSCP, Quality Center, Confidential Rational Rose, AutoSys

Hire Now