We provide IT Staff Augmentation Services!

Sr. Etl Lead / Datastage Consultant Resume

Murray Hill, NJ

SUMMARY

  • 8 plus years of IT experience in developing Business Intelligence (BI) solutions including building Data Warehouses, Data marts and ETL for clients in industry sectors like Retail/Manufacturing Industry, Financial Investment, Health Care, Hospital Management and Educational Institutions.
  • Involved in all phases of Software Development life cycle (SDLC) of implementing an Enterprise Data Warehouse (EDW).
  • 7 plus years of experience in building Data Warehouse using IBM Information Server DataStage and Quality Stage 9.1, 8.7, 8.5, 8.1/7.5.1, Ascential DataStage 7.xin design, develop and testing ETL jobs.
  • Extensively worked on identifying dependencies and creating sequencer jobs to schedule server and parallel jobs.
  • Experienced in writing system specifications, translating user requirements to technical specifications, ETL Source - Target mapping document and testing documents.
  • Strong understanding of the principals of Data Warehouse, Dimension modeling, star and snowflake schema modeling, Ralph-Kimball approach, Bill Inmon approach.
  • Hands on experience interfacing desperate data from heterogeneous source systems into Enterprise data warehouse on variety of Data Base systems such as IBMDB2, Oracle, Teradata, and SQL Server.
  • Extensively worked on extracting data from SAP using ABAP Extract Stage.
  • Worked on integrating data from flat files and XML files.
  • Experience in integration of various data sources like Oracle, IBM DB2, Teradata and SQL Server into staging area.
  • Extensively used XML stages to read and write XML files.
  • Good understanding of SAP architecture and SAPT-Codes and SAP GUI tools, ABAP Programs, IDocs and BAPI.
  • Worked on performance tuning ETL jobs to improve the overall performance.
  • Good working knowledge in UNIX shell scripting, VI editor and file handling on UNIX file system.
  • Good working knowledge of Client-Server Architecture
  • Articulate wif excellent written and verbal communication and interpersonal skills wif the ability to work in a team as well as individually.
  • Influencing, leading, and delegating abilities.
  • Ability to initiate/manage cross-functional teams and multi-disciplinary projects.
  • Critical thinking, decision making and problem solving skills.
  • Result oriented Ability to achieve the target wifin given time
  • Efficient under pressure, always meet deadlines.
  • Ability to maintain and build client relationships.
  • Involved in interaction wif users and creating specifications.
  • TEMPEffective communication skills and coordination between onsite/offshore teams.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere DataStage 9.1, 8.7, 8.5, 8.1/7.5.1 (DataStage Administrator, DataStage Designer, DataStage Director, DataStage Manager Parallel Extender/Orchestrate, Quality Stage)

BI Reporting Tool: Micro Strategy 10.2/9.1

Data Modeling Tools: Erwin 4.1/3.5

Databases: Oracle 11g/10g/9i, MS SQL Server 2008 R2/2005, DB2 9.1Teradata V2R5, V2R6

Operating Systems: IBM AIX 5.1, Windows 2000/XP/7

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++

PROFESSIONAL EXPERIENCE

Confidential, Murray Hill, NJ

Sr. ETL Lead / DataStage Consultant

Responsibilities:

  • Used the IBM Info Sphere DataStage 9.1 to develop processes for extracting, cleansing, Transforming and loading data into data warehouse database.
  • Worked on MicroStrategy 10.1/9.2 Desktop to create Applications Objects, Reports and Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
  • Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
  • Designed and developed template jobs to maintain standard common format (SCF) file dat we receive from different divisions of Bard across the world.
  • Implemented logical and physical data modeling wif Star and Snowflake techniques using Erwin in Data warehouse.
  • Developed Parallel jobs using stages like Dataset, Sequential file, Funnel, Filter, Join, Lookup, Merge, Aggregator, Peek, Pivot, Transformer, External Source Stage and Remove Duplicate Stage.
  • Used stages like Oracle Connector, Odbc Connector and DRS stage to extract data from Oracle, SQL Server 2008 R2 and IBM DB2 databases.
  • Used XML stages to read and write XML files.
  • Extensively used Job Parameters, and Stage Variables in developing jobs
  • Used DataStage Director to validate schedule run and monitor the data stage jobs.
  • Created Sequence jobs to control the flow of jobs and their dependencies.
  • Designed Job sequencers to automate the process and Created sessions and batches to run the mappings and set the session parameters to improve the load performance.
  • Designed Job Documentation and Installation and Back out Documentation.
  • Involved in unit, performance testing of data stage jobs and prepared technical design documentation.
  • Responsible for analyzing and preparing dependencies and sequence in which processes should be scheduled in Control-M scheduler.
  • Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
  • Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
  • Created Ad-hoc reports by gathering specific requirements from the different users.
  • Responsible to track, log all support issues to significantly reduce the amount of time needed for support issues.

Environment: IBM InfoSphere DataStage 9.1 (Designer, Directory and Administrator), MicroStrategy 10.1/9.2, Oracle 11g, SQL Server 2008 R2, IBM DB2 9.1, AIX 5.1, K-Shell Scripting, SQL, PL/SQL, Toad for Oracle 12.6.0, Control - M, Erwin 4, Microsoft Visio.

Confidential, New York

Sr. DataStage Consultant

Responsibilities:

  • Used the IBM Info Sphere DataStage 8.1 to develop processes for extracting, cleansing, Transforming and loading data into data warehouse database.
  • Worked closely wif Business Analysts (BA) and Business/End users to understand the requirements and to write the technical specs.
  • Involved in business meetings to understand the Claims, Patient, Subscriber, Pharmacy and Enrollees data.
  • Day-to-day responsibilities include data profile, design, develop and build ETL programs.
  • Responsible to create Source to Target (STT) mappings.
  • Developed and supported the Extraction, Transformation and Load process (ETL) to build data warehouse from disparate data sources using DataStage Parallel and server jobs.
  • Extensively worked on DataStage Designer to develop Parallel and server jobs to extract data, clean, transform and load the target system.
  • Experience in design and develop job sequential jobs to schedule and run multiple jobs, define checkpoints and to build restart ability.
  • Worked extensively on XML Input and XML Output Stages.
  • Developed Parallel jobs using Parallel stages like: Join, Lookup, Sort, Transformer,
  • Funnel, Remove Duplicates, Aggregator, Datasets, Sequential Files, Filter, External Source Stage, Oracle OCI and ODBC stages.
  • Good understanding Data Warehouse concepts and Star Schema and Snowflake Schema models techniques.
  • Responsible for Unit test and integration testing, Data Validations and preparing test plans and test cases.
  • Used the DataStage Director to run, monitor, and test jobs on development and to obtain the performance statistics.
  • Used Autosys Enterprise scheduling tool to schedule and define dependency across the enterprise.

Environment: IBM Information Server DataStage and Quality Stage Suite 8.1(Designer, Directory and Administrator), Ascential DataStage 7.5.1.A (Designer, Director and Administrator), AutoSys 11.0, AIX 5.1, SQL Server 2005, Oracle 11g/10g, Windows XP, Microsoft Visio, WinScp, Toad for Oracle.

Confidential, Murray Hill, NJ

Sr. DataStage Developer

Responsibilities:

  • Used the IBM Info Sphere DataStage 8.7 to develop processes for extracting, cleansing, Transforming and loading data into data warehouse database.
  • Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
  • Designed and developed template jobs to maintain standard common format (SCF) file dat we receive from different divisions of Bard across the world.
  • Prepared Technical Specification Documents for DataStage Jobs.
  • Implemented logical and physical data modeling wif Star and Snowflake techniques using Erwin in Data warehouse.
  • Developed Parallel jobs using stages like Dataset, Sequential file, Funnel, Filter, Join, Lookup, Merge, Aggregator, Peek, Pivot, Transformer, External Source Stage and Remove Duplicate Stage.
  • Used stages like Oracle Connector, Odbc Connector and DRS stage to extract data from Oracle and IBM DB2 databases.
  • Extracted data from XML files using XML Input Stage.
  • Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
  • Used DataStage Director to validate schedule run and monitor the data stage jobs.
  • Created Sequence jobs to control the flow of jobs and their dependencies.
  • Designed Job sequencers to automate the process and Created sessions and batches to run the mappings and set the session parameters to improve the load performance.
  • Designed Job Documentation and Installation and Back out Documentation.
  • Involved in unit, performance testing of data stage jobs and prepared technical design documentation.
  • Responsible for analyzing and preparing dependencies and sequence in which processes should be scheduled in Control-M scheduler.
  • Responsible to track, log all support issues to significantly reduce the amount of time needed for support issues.

Environment: IBM Information Server DataStage & Quality Stage 8.7 (Designer, Directory and Administrator), Oracle 11g, IBM DB2 9.1, AIX 5.1, K-Shell Scripting, SQL, PL/SQL, Toad for Oracle, Control - M, Clear Case, Erwin, Microsoft Visio.

Confidential, Minneapolis, MN

Sr. DataStage Developer

Responsibilities:

  • Identified business needs, evaluated business and technical alternatives, recommended solutions and participated in their implementation.
  • Adapt ETL processes to accommodate changes in source systems and new business user requirements.
  • Used the IBM Information server 8.5 to develop processes for extracting, cleansing, Transforming, integrating, and loading data into data warehouse database.
  • Used DataStage Parallel Extender parallel jobs for improving the performance of jobs.
  • Implementing Industry ETL standards and standard practices, performance tuning during designing the DataStage Jobs.
  • Extensively worked on building ETL interfaces to read and write data from DB2 database and SQL Server database using ODBC Stage.
  • Extensively worked on Connector Migration Tool to convert 8.1 jobs to 8.5.
  • Extensively worked on IBM Info Sphere Connector migration tool.
  • Developed Parallel jobs using Parallel stages like: Dataset, Sequential file, FTP, Funnel, Filter, Modify, Merge, Join, Lookup, Transformer, Remove Duplicate Stage.
  • Extensively used processing stages like the Join and Lookup stages to perform lookup operations based on the various target tables.
  • Worked on Change Data Capture (CDC) stage.
  • Used DataStage Director to validate schedule run and monitor the data stage jobs.
  • Used Before/After Job-Subroutines in Job Properties.
  • Designed Job sequencers to automate the process and Created sessions and batches to run the mappings and set the session parameters to improve the load performance.
  • 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.
  • Resolved issues occurred during regular testing and BLT Testing.
  • Modified the DS jobs to improve performance.
  • Used Autosys scheduling tool to automate the ETL jobs.
  • Involved in unit, performance, Regression and integration testing of data stage jobs and prepared technical design Documentation.

Environment: IBM Information Server DataStage & Quality Stage 8.5.1, 8.1.1(Designer, Directory and Administrator), IBM DB2 9.1, SQL Server 2005 9.0, AIX 5.1, K-Shell Scripting, SQL, PL/SQL, WinSql for DB2, Autosys 11.0, Clear Case, Microsoft Visio.

Confidential, Boston, MA

DataStage Developer

Responsibilities:

  • Involved in all phases of Software Development Life Cycle of building Data Warehouse.
  • Worked wif BA to understand the Student, Course details and fee structures, Semester, Professor and financial information.
  • Responsible for creating detailed design documents and source to target mappings.
  • Responsible to communicate wif business users and project management to get business requirements and translate to ETL specifications.
  • Used DataStage/Quality Stage Designer to import/export jobs, table definitions, Custom Routines and Custom Transformations.
  • Created Extract Transform and Load (ETL) interfaces and gateways for backend database.
  • Good knowledge of PeopleSoft tools and modules. Hands one experience loading PeopleSoft EPM modules from disparate source systems.
  • Hands on experience on design and developing Parallel and server jobs.
  • Extensively worked on building data stage jobs using various stages like Oracle OCI Stage, Transformer stage, Sequential file stage, LookUp, Join and Peek Stages.
  • Extensively used Sort, Merge and Aggregator, Peek, DataSet and Remove Duplicates stages.
  • Involved in the migration of DataStage jobs from development to QA and then to production environment.
  • Developed shared container jobs to use in multiple jobs.
  • Hands on experience upgrading DataStage from v7.5 to Information Server 8.1.1.
  • Imported and exported Repositories across DataStage projects using datastage designer/Manager.
  • Extensively worked on DataStage Job Sequencer to Schedule, define dependency/checkpoints Jobs to run jobs in Sequence.
  • Worked Control-M enterprise scheduling tools to define dependency across the enterprise.

Environment: IBM Information Server8.1.1DataStage and Quality Stage(Designer, Directory and Administrator),Ascential DataStage 7.5 (Manager, Designer, Director and Administrator),PeopleSoft Student Admin, PeopleSoft EPM 8.9, Oracle 10g, Control-M 6.3.01, PL/SQL, HP-UNIX 11,Toad for Oracle, Microsoft Visio.

Confidential, Sacramento, CA

DataStage Developer

Responsibilities:

  • Facilitated Business Process and coordinated wif Business-users to get specific user requirements to build the Data Marts.
  • Developed star schema data model using suitable dimensions and facts.
  • Analyzed scope of application, identifying the relationship wifin and between the groups of data.
  • Developed the data models based on Kimball’s Warehousing Methodology.
  • Used DataStage Designer in the development process for extracting, cleansing, transforming, integrating, and loading data into target data marts.
  • Used DataStage Manager involving functions like importing metadata into the DataStage repository, creating new table definitions and job categories.
  • Generated Surrogate Keys for the Dimensional tables using the DS Functions.
  • Developed various DataStage jobs using Teradata Enterprise Stage, Teradata Multi Load to build data warehouse system.
  • Used Link Collector, Link Partitioner for performing data collection and data partitioning Operations.
  • Used Hashed file stage for faster look-ups of data in server jobs.
  • Used DataStage Director to validate, run, view/print logs, schedule, run, and monitor DataStage jobs.
  • Extensively worked on extracting SAP data using SAPABAP Extract stage.
  • Worked on customizing ABAP programs and well versed wif SAPT-Codes and SAP GUI tools, ABAP Programs and BAPI.
  • Implementing performance-tuning techniques along various stages of the ETL process.
  • Performed the Unit testing and Integration testing of the jobs to check the compliance of the ETL to the requirements documents.

Environment: Ascential DataStage 7.5 (Designer, Manager, Director and Administrator), Orchestrate, SAP R/3 (MM, PP, SD, FI-CO), DataStage Extract PACK for SAP R/3, ABAP Extract Stage, Oracle 9i,Teradata V2R6,Model-N Azerity POS System, Windows NT, Sun Solaris 8, SQL, PL/SQL, K-Shell Scripts, TOAD for Oracle, SQL Assistant, Erwin 4.0

Confidential

Jr. Oracle/ ETL Developer

Responsibilities:

  • Design, Development, Deployment and Reengineering of Oracle SQL Scripts and Stored Procedures.
  • Installed of the Oracle Software and Creation of the Databases.
  • Created different Master Tables and Transaction Tables and Views.
  • Created Indexes, Database Triggers on various tables, Created different backend Functions, Procedures, and packages.
  • Optimized SQL Queries for maximum performance.
  • Dynamic Query processing.
  • Designed and Developed Stored Procedures.
  • Performed Systems Study and Analysis.
  • Populated the table from the text file using SQL LOADER.
  • Trained on Ascential Data Stage Enterprise Edition 7.5.1 to develop various Parallel/Server jobs to extract, cleanse, transform, integrate and load data into Enterprise Data Warehouse tables.
  • Involved in Design, Source to Target Mappings between sources to operational staging targets.
  • Worked closely wif other Development team members to improve quality and consistency of all deliverables.

Environment: Oracle 9i, Ascential Data Stage Enterprise Edition 7.5.1, SQL, PL/SQL, Oracle SQL Developer, SQL*LOADER

Hire Now