We provide IT Staff Augmentation Services!

Sr. Datastage Developer Resume Profile

GA

Professional Summary

  • Over 8 years of professional experience in Extraction, Transformation and Loading ETL .
  • Expert Level experience in DataStage Client components DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator
  • Expert in Complete Source System Profiling and Analysis using IBM InfoSphere Information Analyzer and Quality Stage to easily apprehend and classify data, exhibit data using various semantics such as format, classification, or value in order to allow the customer to quickly identify data anomalies, validate column/table relationships and drill down to exception rows for further analysis.
  • Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.
  • Expertise in writing UNIX shell scripts and hands on experience with scheduling of shell scripts using AUTOSYS. Knowledge in UNIX shell and have written shell scripts for automation of Job Flow, Scheduling Jobs.
  • Optimized DataStage job utilization Parallelism, Partitioning and Pipelining features of Parallel Extender.
  • Advance Knowledge, excellent concepts and experienced in decision support system DSS , querying and analysis, Extraction Transformation Loading ETL Data Stage and Data Warehousing.
  • Worked with DB-admin to create appropriate Indexes on tables for better performance of Data Stage queries.
  • Strong Knowledge of Data Warehouse architecture in Designing Star Schema, Snow Flake Schema, FACT and Dimensional Tables. Physical and Logical modeling using Erwin.
  • Extensive experience in developing strategies for Extraction, Transformation, Loading ETL data to various sources into data warehouse and Data Marts using Data Stage.
  • Basic expertise in using ERWIN for data modeling.
  • Extensively involved in Performance Fine Tuning of ETL programs. Tuned DataStage and Stored Procedures Code.
  • Excellent experience in Relational Database RDBMS , Oracle 11g,10g,9i, Microsoft SQL Server, Teradata Load and MultiLoad, SQL, PL/SQL, TOAD
  • Involved in Logical and Physical Design, Backup, Restore, Data Integration and Data Transformation Service and Creating Database Objects Tables, Index, Triggers, Views, Stored Procedures .

Technical Skills

ETL

IBM Ascential DataStage 8.x/7.5x2/7.x EE SE Adminstrator, Designer, Director, Manager , Parallel Extender, IBM WebSphere Information Server 8.0.1, IBM InfoSphere Information Server 8.1, QualityStage

Data Modeling

Dimensional, Logical Physical Data Modeling, Star Schema, Snow-Flake Schema, ERwin 3.x

RDBMS

Oracle 11g/10g/9i, DB2 9.x/7.x, SQL Server 2008/2005/2000

Programming

SQL, PL/SQL, Shell Scripting,VB Script,Java

Reporting

IBM Cognos, Crystal Reports, IReport

Operating System

Unix, Linux, Windows NT/XP/2000/2003 Server, Solaris

Scheduling Tools

Autosys, Crontab Utility

Agile Software Team Techniques Confidential

This course was like workshop to provide practical knowledge of modern software engineering methods, especially agile development methods. We studied and practiced Agile techniques are studied and practiced in the perspective of developing software for robotics and embedded systems. Software team techniques from extreme programming, such as refactoring and pair programming, were also practiced.

Control and Systems Theory Confidential

In this course I recaptured some of the fundamentals and added some special, currently applied mathematical procedures from control and systems theory. In this course, I was also capable to grasp mathematical foundations required for research work including state of the art theorems and applied software MATLAB

Hardware/Software Co-design of Embedded Systems Confidential

  • Through this Graduate certification I was able to encompass advanced knowledge in the areas of sensors, signal processing, microcontrollers and hardware design. HW/SW co-design made me proficient in making decision that an algorithm should go into software and which parts of it into hardware.
  • Bachelors in Communication Systems Engineering Institute of Space Technology Islamabad, Pakistan

Experience

Confidential

Sr. Datastage Developer

Confidential., formerly NOVA, is a major processor of credit card transactions and a subsidiary of U.S. Bancorp. Elavon offers merchant processing in more than 30 countries and supports the payment needs of more than 1,000,000 merchant locations across the globe. Elavon is the 4th largest U.S. credit card processor and is a top 6 acquirer in the European marketplace.

Roles Responsibilities:

  • Responsible for support of all development and production data integration points for applications
  • Creates functional specifications, interfaces, using preferred best practice techniques
  • Use DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data.
  • Use DataStage Director to schedule running the server jobs, monitoring scheduling and validating its components.
  • Import and export items between different Datastage systems.
  • Parameterized DataStage jobs to allow portability and flexibility during runtime.
  • Involved in identifying the data inputs from various source systems depending upon the business requirement.
  • Responsible for Preparation of Design Documents / Test Case Specifications / Performance Review and Coding.
  • Performs Quality Assurance, unit and system testing and created complete documentation of deliverables.

Environment: IBM InfoSphere Information Server v8.5 Suite DataStage and QualityStage, Information Analyzer , Oracle 11g, SQL, PL/SQL, UNIX, SunOS 5.10 sun4u, Toad for Oracle Version 12.1.1, Autosys CA Workload Control Center r11.1 SP1 . SSH Tectia Client

Confidential

DataStage Developer

Responsibilities:

  • Managed the DataStage repository using DataStage Manager.
  • 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.

Enviroment: DataStage 8.7, Windows 7, Linux, DB2i, UNIX, SQL Server 2000, , Metastage, Flat Files, Sequential files,.

Confidential

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.
  • 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.
  • 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.
  • Developed Server side functionality by using PL/SQL and UNIX shell programming.
  • Constructed SQL Scripts to validate the data after loading process.

Environment: DataStage EE 7.5/8.1 ERwin 4.1.5, SQLServer 2005, Oracle10g/9i, PL/SQL, AutoSys, TOAD, UNIX, Shell scripting

Confidential

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.
  • Loaded data into Load, Staging and Lookup tables.
  • Performance tuned DataStage to reduce batch run time.
  • Extensively used Built-in Sort, Merge, Oracle, Aggregator, DB2 Stages , Plug-in Stages for extraction, transformation and loading of the data.
  • 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 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 7.5, Oracle and MS SQL Server 2005, UNIX and shell scripts, Erwin, SQL Loader.

Confidential

DataStage Developer

Responsibilities:

  • Using IBM Infosphere 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 Cincinati Financial Corporation.
  • 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 Dublicates, Filter, Lookup, Modify, Aggregator and Funnel stages.
  • Using DataStage Software Development Kit, Functions like DSJobInfo, ICOV and OCONV, Transformers like Data Transform.
  • Developed Test Cases and Performed Unit Testing, System, Integration Testing, UAT Testing.
  • Used AUTOSYS to Schedule the DataStage ETL batch jobs on a daily, weekly and monthly basis.
  • 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 Standartization using Quality Stage.
  • Used DataStage Director for Executing, Monitoring, Analyzing logs and Scheduling the jobs.

Environment: IBM InfoSphere Information Server v8.1 Suite DataStage and QualityStage, Information Analyzer and Metadata Server , DB2UDB9.1, Oracle 10g, SQL, PL/SQL, UNIX, IBM-AIX, Erwin 4.5, MS Visio and Autosys.

Confidential

Sr. DataStage Developer

Responsibilities:

  • Used various sourced and designed and developed jobs in order to facilitate the integration process of the expenditures.
  • Analyzed reports made by business user to extract data to effectively integrate expenditures from various sources.
  • Developed number of staging jobs to load the data into target table, created number of complex jobs in the life cycle and also was involved in migration, error management, reporting, and data quality issues.
  • Worked with widely used stages like Flat File, Lookup, Join, Pivot, Transformer, Sort, Aggregator, Merge, Row Generator, and Column Generator and also troubleshooted the designed jobs and tested the jobs for all logical errors.
  • Evaluated the Data extraction from source to confirm for data irregularities and classify corrupt data to apply suitable transformation in the mappings in the jobs.
  • Used diverse partitioning methods like Auto, Hash, Same, Entire etc. and were also involved in preparation of Test Cases concerned with Unit testing, System testing to check data reliability.
  • Involved in Data Extraction, Transformation and Loading ETL process from Source to target systems using Data stage.

Environment: IBM InfoSphere DataStage 8.1 Designer, Director, Administrator , Oracle 10g/9i, UNIX, Shell Scripting, Erwin 7.0, Qualitystage, Metastage, TOAD, PL/SQL, Autosys, MS Access.

Confidential

DataStage Developer

Responsibilities:

  • Managed the DataStage repository using DataStage Manager.
  • 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.

Enviroment: DataStage7.5, Windows NT 4.0, Linux, Oracle 8i, UNIX, SQL Server 2000, Qualitystage, Metastage, Flat Files, Sequential files, MS Access, XML files.

Hire Now