We provide IT Staff Augmentation Services!

Sr. Etl Consultant Resume

Chicago, IL

Skills

  • Enterprise Data Warehouse/Data Mart environment utilizing DataStage 7.x, 8.s and Business Objects XI
  • Experience with ETL and Business Intelligence development in an Enterprise Data Warehouse environment, including identifying user requirements.
  • Experience in using Ascential Data Stage Server and Enterprise Edition in an Oracle hosted Data Warehouse
  • Experience in developing and maintaining of dependent and independent data marts.
  • Experience in using Data Stage Basic (DSBASIC) language and Extensible Markup Language (XML)
  • Experienced in sourced to target mapping between Data Warehouse and target data mart universal databases.
  • Experienced using Business Objects Designer and Web Intelligence including universe and report design, construction and documentation.

Employment History

Confidential
Chicago, IL
Sr. ETL Consultant

Responsibilities

  • Test the parallel runs for deployment by using the comparing utilities.
  • Scheduling the jobs in the control-m, by promptly placing the DataStage jobs instead of main frame jobs.
  • Used Information Analyzer to provide complete analysis of source systems and target systems, and assesses the structure, content, and quality of data.
  • Used Quality Stage which standardizes stage to reformat data from multiple systems for effective matching and output formatting.
  • Used Quality Stage investigation stage to create input into cleansing process.
  • Created new data models and data marts dependent on Enterprise Data Schema and data staging.
  • Involved in the design of an efficient, reliable ETL mechanism for updating the Data Warehouse, Data Marts and downstream systems.
  • Processed Cleansing, Purging and Optimizing the data in warehouse.
  • Developed and implemented all ETL (Extract, Transform and Loading) Components based on the filter rules to obtain needed data from different source systems for calculating required metrics using PL/SQL.
  • Used Resource Registry extensively to improve system portability
  • Involved in creating logical and physical data model with use of Oracle Designer
  • Used ROLAP to work with relation database.
  • Created DataStage Basic routines for custom transformations.
  • Used Parallel Extender for splitting the data into subsets and flowing of data concurrently across all available processors to achieve job performance.
  • Worked extensively on different types of stages like Transformer, Sorter, Aggregator, Lookup, folder, Joiner, OCI, Flat file and ODBC.
  • Designed and developed mappings between sources systems (external files and databases) to operational staging targets and Data marts.
  • Extracted data using DataStage from Oracle Database and Enterprise Data Warehouse Teradata Database.
  • Created/Modified Universes by Adding objects, Tables/Derived tables with Oracle and as Backend Databases.
  • Designed and constructed automated universe and report documentation with Business Objects Designer.
  • Involved in performance tuning of Business Objects reports. Using hints/ aggregate aware, index aware and other optimizing techniques to improve performance.

Environment: DataStage Enterprise Edition 8.0.1/7.5.2 (Manager, Designer, Director, Administrator), Quality Stage, Ascential DataStage 7.5.2, Information Analyzer, UNIX, MVS, Db2, UDB, Oracle, JCL, SAS, PL/SQL, SQL Server, HTML, XML.

Confidential
Harrisburg, PA
DataStage Developer

Responsibilities

  • Participating on Business Analysis Development Phase and Gathering Requirements. Working with Developer Department team for translating business requirements into Data Mart Design.
  • Working with Database team for creating logical and physical Data Modeling process using Erwin and guide business group and users session.
  • Developed new data models and data marts dependent on Enterprise Data Schema and data staging
  • Taking part in planning and management of all Data Warehouse migration process.
  • Involved in creating strategy for Star Schemas with Fact and Dimension Tables.
  • Translating Business requirements into Data Mart design coordinating with team members Creating Fact, Dimensional and Aggregate Tables and Loading Data Warehouse tables.
  • Implemented the Surrogate Key by using Key Management functionality for newly inserted rows in Data Warehouse
  • Developed Shell Scripts for taking backup and recovery of database. Performed physical and logical backup.
  • Used Autosys to schedule the DataStage ETL batch jobs on daily, weekly and monthly basis.
  • Performed data manipulation using Basic functions and DataStage transforms.
  • Used DataStage manager to import, create and edit the metadata.
  • Used the DataStage Administrator to assign privileges to users or users groups, move, rename or delete projects and manager or publish jobs from development to production status.
  • Extracted data using DataStage from Oracle Database and Enterprise Data Warehouse Teradata Database.
  • Collaborated with Business Intelligence and Business Objects teams to find how reports are affected by a change to the corporate data model.
  • Designed and constructed automated universe and report documentation with Business Objects Designer.
  • Developed Server side functionality by using PL/SQL and UNIX shell programming.
  • Designed and developed mappings between sources systems (external files and databases) to operational staging targets and Data marts.
  • Constructed SQL Scripts to validate the data after loading process.

Environment: DataStage Enterprise Edition 7.5/8.1 ERwin 4.1.5, SQLServer 2005, Oracle10g/9i, PL/SQL, Autosys, TOAD, UNIX, Shell scripting, HTML, XML.

Confidential

Kansas City, KS
DataStage Developer

Responsibilities:

  • Involved in status meetings, and interacted with the Business Analyst to get the business rules.
  • Design and development Sprint PCS source system data and finally make the data available to satisfy the reporting and analytical requirements of the long distance entry effort.
  • Developed new data models and data marts dependent on Enterprise Data Schema and data staging.
  • Loaded data into Load, Staging and Lookup tables.
  • Performance tuned DataStage to reduce batch run time.
  • Designed exception logging framework, operational statistics capturing framework and DataStage Basic (DSBASIC) routine to log exceptions and log statistics to database
  • Taking part in planning and management of all Data Warehouse migration process.
  • Extensively used Built-in (Sort, Merge, Oracle, Aggregator, DB2 Stages), Plug-in Stages for extraction, transformation and loading (ETL) of the data.
  • Collaborated with Business Objects team to design Crystal reporting and reports for enterprise reporting applications.
  • Collaborated with Business Intelligence and Business Objects teams to find how reports are affected by a change to the corporate data model.
  • Designed the DataStage jobs to Extract the data from Text files, Transform the data according to the business requirements and load them into Oracle tables. As per the data volume, presented the size requirements and partitioning requirements for ODS tables in Oracle.
  • Designed and constructed automated universe and report documentation with Business Objects Designer.
  • Extracted data using DataStage from Oracle Database and Enterprise Data Warehouse Teradata Database.
  • Designed and developed mappings between sources systems (external files and databases) to operational staging targets and Data marts.
  • Designed Parallel jobs using various stages like Join, Merge, Remove Duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator and Funnel stages
  • Wrote Oracle stored procedures and called the Stored Procedures in Data Stage.
  • Create and enhance the existing process of the PL/SQL Procedures and Packages.

Environment: DataStage Enterprise Edition 7.5, Oracle and MS SQL Server 2005, UNIX and shell scripts, ERwin, SQL Loader, HTML, XML.

Confidential
Cincinnati, OH
Data warehouse Developer

Responsibilities:

  • Using IBM Info sphere DataStage software, extracting data from DB2, Oracle and Flat File and Load to target tables.
  • Participated in Business Analysis and technical design meeting with business and technical staff to develop Entity Relationship / Data Models, requirements document, and ETL specifications.
  • Creating and maintaining DataStage Parallel Jobs for every policy holders from Cincinnati Financial Corporation.
  • Create new data models and data marts dependent on Enterprise Data Schema and data staging
  • Extracted data from text files, using FTP Stage and loaded into different databases.
  • Developed Parallel Jobs using various Development / Debug Stages (Peek Stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample stage) and Processing Stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Merge, Funnel Remove Duplicate Stage).
  • Designed Parallel jobs using various stages like Join, Merge, Remove Duplicates, Filter, Lookup, Modify, Aggregator and Funnel stages.
  • Using DataStage Software Development Kit, Functions like DSJobInfo, ICOV and OCONV, Transformers like Data Transform.
  • Designed and constructed automated universe and report documentation with Business Objects Designer.
  • Designed exception logging framework, operational statistics capturing framework and DataStage Basic (DSBASIC) routine to log exceptions and log statistics to database.
  • Developed Test Cases and Performed Unit Testing, System, Integration Testing, UAT Testing.
  • Extracted data using DataStage from Oracle Database and Enterprise Data Warehouse Teradata Database.
  • Collaborated with Business Intelligence and Business Objects teams to find how reports are affected by a change to the corporate data model.
  • Used AUTOSYS to Schedule the DataStage ETL batch jobs on a daily, weekly and monthly basis.
  • Designed and developed mappings between sources systems (external files and databases) to operational staging targets and Data marts.
  • Designed the DataStage Integrity check jobs which check each Dimension ID and Fact table that has a corresponding ID in a Dimension table.
  • Involved in developing and rewriting Investigation, Matching, Survivors rules and Standardization using Quality Stage.
  • Used DataStage Director for Executing, Monitoring, Analyzing logs and scheduling the jobs.

Environment: IBM Info Sphere Information Server v8.1 Suite (DataStage and Quality Stage, Information Analyzer and Metadata Server), DataStage Enterprise Edition 7.51 A, DB2UDB9.1, Oracle 10g, SQL, PL/SQL, Business Objects 6.5, UNIX, IBM-AIX, Erwin 4.5, MS Visio and Autosys, HTML, XML.

Confidential
SQL Developer

Responsibilities:

  • Suggested various changes in the physical model to support the business requirements.
  • Developed server jobs to load the data from flat files, text files, tag text files and MS SQL.
  • Set various parameters in DataStage Administrator for performance tuning.
  • Used DataStage Designer to develop various jobs.
  • Utilized shared containers for code reusability and for implementing the predefined business logic.
  • Created and scheduled the job sequences by checking job dependencies.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries.
  • Performed Unit Testing to check the validity of the data at each stage.
  • Used DataStage Director to debug the jobs and to view the error log to check for errors.
  • Implemented best practices in the development environment (code standards, code migration).
  • Wrote PL/SQL stored procedures, functions and packages and triggers to implement business rules into the application.

Environment: DataStage Enterprise Edition7.5, Windows NT 4.0, Linux, Oracle 8i, UNIX, SQL Server 2000, Quality stage, Meta stage, Flat Files, Sequential files, MS Access, HTML, XML

Hire Now