DataStage Developer Resume Profile , Oakland, CA

Reference Id: 81526     Posted on Wednesday 16th September 2015      Big Data/Hadoop



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

DataStage Developer  Resume Profile , Oakland, CA

 

                                            

Tools/Methods

Web Sphere 8.7/8.5/8.1/8.01

Data stage, Information Server Quality stage, Metadata Server Ascential DataStage7.5/7.0

Quality Stage 7.x, 8.0

Oracle 11g/10g/9i/8i, DB2,

Tera Data,

SQL Server2000/2005, PL SQL

Scripts, C Shell, K-Shell Scripts, AWK, VI-editor, Perl Scripting,

COBOL, C, C++, JAVA,

SQL, PL/SQL, Linux/Unix,

IBM AIX 4.3,

Win XP/NT 6.0/5.0/4.0,

FrontPage 98/2000,

Excel, Power Point,

Visual Interdev 6.5/6.0,

Visual Age 3.5,

Cognos, AUTOSYS

 

 

clients

UCOP

Wells Fargo

Bank of America

Wells Fargo

NetApp

Safeway

Hermes Technologies.    

 

 

 

 

relevant Experience

§  Venkat is an IBM Certified Professional with 8+ years of IT experience, with special expertise in Development, Analysis and Design of ETL methodologies in all the phases of the Data Warehousing life cycle. He has extensive experience IBM Web Sphere 8.5/8.1.0/8.01 (Data stage, Information Server, Quality Stage, Information Analyzer, Metadata Server) and experience in Ascential DataStage 7.5, 7.0 using components like DataStage Designer, DataStage Manager, DataStage Director, DataStage Administrator and Parallel Extender. Expert in all the stages of Software Development Life Cycle.

 

Skills Inventory

§  Strong Decision Support Systems experience using Business Intelligence tool Business Objects.

§  Expert in developing DataStage jobs using star schema and snowflake schema modeling and conversant with Data Warehouse concepts like fact tables and dimension tables.

§  Created and implemented common UNIX shell scripts to FTP the files from/to different servers, validate, process the Flat Files for different projects.

§  Strong understanding of the principles of Data Warehouse using Fact Tables, Dimension Tables, Star Schema modeling and Snowflake Schema modeling.

§  Extensive experience in using highly scalable parallel processing infrastructure using DataStage Enterprise Edition.

§  Expert in writing, testing and implementing triggers, functions and procedures at database level using PL/SQL.

§  Experienced in incorporating various data sources like Oracle, MS SQL Server, DB2, Teradata, XML and flat files into the staging area.

§  Experienced in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.

§  Having good experience in the preparation of JIL scripts to schedule the jobs through Autosys.

§  Expertise in data migration projects with (target – source) same database as well as with heterogeneous databases.

§  Strong analytical, organizational, presentation and problem solving skills.

 

 

       

Senior DataStage Developer

Confidential                                                                                     

The Confidential is a public university system in the U.S. state of California. Under the California Master Plan for Higher Education, the University of California is a part of the state's three system public higher education plan, which also includes the California State University system and the California Community Colleges System. As of fall 2011, the University of California has 10 campuses, a combined student body of 234,464 students, 18,896 faculty members, 189,116 staff members, and over 1.6 million living alumni. This is conversion project from Legacy system to People Soft. In this whole conversion process we are using 30 years of old data. In this conversion process DataStage is one of the ETL tool & loading all the data into ETL_STG schema, made transformations and finally load in to target database.

 

  • Reviewed the Functional Design Specification (FDS) provided by the Business Team, Raised concerning issues present in the FDS by understanding the functionality illustrated to do the conversion.
  • Extensively used IBM DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Marts and Involved in preparing of High Level, Low Level Design Documentation.
  • Developed and loaded data warehouse tables such as dimension, fact and aggregate tables using IBM DataStage.
  • Developed DataStage jobs to implement complex business rules and transformation logic using lookup, join, modify, filter, copy, aggregator, sequence stages like job activity, exception handler, execute command, wait for file activity and Used job sequences to automate the ETL process.
  • Exclusively used transformer stage to do data validation, cleansing, converting as per business requirements.
  • Implemented SCD's using CDC Stage, surrogate key generator.
  • Created re-usable components using shared containers for local use or shared use.
  • Developed simple UNIX scripts to do file transfers, file archiving and file maintenance and have good work experience with UNIX commands.
  • Wrote PL/SQL statements and Stored Procedures in Oracle for extracting data as well as for writing data into tables.
  • Performed the unit testing for various conditions as per data quality and business requirements.
  • Responsible for performance tuning of DataStage code to increase the performance and throughput.
  • Provided support to the QA team to run all the respective objects in DEV, QA and PRD environments   during scheduled Cut-over’s at various phases of the project.
  • Documented all the implementation process in detail describing the overall DataStage process and Part of the Production Support team to monitor and fix any production issues/failures and making sure that the SLA’s are being met on a timely manner.
  • Created Autosys jils for scheduling and running DataStage jobs.

 

Environment: IBM WebSphere DataStage 8.7 (Designer, Director, Administrator, Quality Stage, MetaStage), Oracle 10g, DB2,Toad, DB2 Visualizer, SQL Developer, Autosys, AIX UNIX,K-Shell scripts, MS Visio.

 

Senior DataStage Developer

Confidential

 

 

Wells Fargo & Company is a bank holding company. It has three operating segments: Community Banking, Wholesale Banking and Wealth, and Brokerage and Retirement. It provides retail, commercial and corporate banking services through banking stores and offices, the Internet and other distribution channels to individuals, businesses and institutions in all 50 states and in other countries. The purpose of this document is to describe the EDA - Caspr data store scope and new functionality behind the new customer acquisition strategy which include sending customer information for product sold within caspr to CRM and receive the status back from CRM and then tracking client at transaction level and award appropriate credit to acquisition banker and creating the necessary summarization.

 

 

  •  Communicated with business users and management to get business requirements and translate to ETL specifications.
  •  Developed Full Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, implementation and Project documentation.
  • Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions (SCD).
  • Developed jobs for handling different data transformations as per specified requirements using stages like Join, Merge, Lookup, Transformer and Aggregator etc.
  • Extensively used SCD, Sort, Merge, Aggregator, Peek, Dataset, Funnel and Remove Duplicates stages.
  • Designed the Unit testing and integrated testing process and necessary documentation.
  • Used DataStage Manager for importing and exporting jobs into different environments and projects.
  • Used UNIX scripts to execute jobs and also used the DataStage Director for scheduling, executing and monitoring jobs.
  • Used shared containers to reuse the specific business logic in various jobs to eliminate redevelopment.
  • Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.
  • Experienced in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
  • Experience with Scheduling tool Autosys for automating the ETL process.

 

Environment: IBM Information Server 8.7 (Designer, Director, Manager and Administrator), QualityStage, AutoSys, K-Shell Scripts, Win SCP, Oracle 10g, PL/SQL, Toad 7, SQL Developer.

 

 

Senior DataStage Developer

Confidential

Confidential is one of the nation’s leading financial institutions that offers a wide range of Checking, Savings, debit cards, credit card services and all come with many free services including online banking, convenient account access, and 24/7 support. The main aim of the project was to migrate customer’s data from databases, flat files to a centralized data ware house for better analysis and decision making.

 

§  Involved in understanding business processes and coordinated with business analysts to get specific user requirements to build Data Marts.

§  Designed and developed the DataStage server as well as parallel jobs for extracting, cleansing, transforming, integrating and loading data using DataStage designer.

§  Developed DataStage jobs to load the data into tables using fast load utility.

§  Worked with DataStage director to schedule, monitor and analyze performance of individual stages and run DataStage jobs.

§  Imported and exported repositories across project using DataStage manager.

§  Set various environment variables and parameters in DataStage administrator and also used them in managing the projects.

§  Used several stages like sequential file, hash file, aggregator, funnel, change capture, change apply, transformer, merge, join and lookup during the development process of the DataStage jobs.

§  Involved in the preparation of ETL documentation by following the business rule, procedures and naming conventions.

§  Used shard containers for reusability and reducing job complexity.

§  Responsible for unit, system and integration testing. Development test scripts, test plan and test data. Participated in UAT (User Acceptance Testing).

§  Analyzed data with discrepancies through error files and log files for further data processing and cleansing.

§  Responded to user request on queries on the enterprise data warehouse and creation of reports using cognos 8.

§  Created Autosys jils for scheduling and running DataStage jobs.

§  Used UNIX commands like awk, sed, and cat.

 

 Environment: Data Stage 8.5 (Designer, Director and Administrator), Oracle 8i/10g, IBM AIX, MS SQL Server, Flat files, Oracle 10g, TOAD, Windows XP, MS Word, Excel, Autosys.

 

Senior DataStage Developer

Confidential

 

Confidential is a nationwide, diversified, community-based financial services company. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, insurance, investments, mortgage, and consumer and commercial finance through more than 9,000 stores, 12,000 ATMs, the Internet (wellsfargo.com), and other distribution channels across North America and internationally. ETL designed to populate the data into Oracle warehouse, which is a reporting data repository data mart to calculate the risk analysis of the Wells Fargo Bank caused by the mortgage company customers.

 

§  Involved in understanding Business Process and coordinated with Business Analysts to get specific user requirements to build the Data Marts.

§  Involved in preparing the source to target data mapping for ETL design and development.

§  Developed DataStage ETL jobs and Data Loader definitions in the Enterprise Warehouse based on the client’s requirements.

§  Used Oracle PL/SQL for writing stored procedures, packages for extracting the data.

§  Developed DataStage jobs using star schema and snowflake schema modeling and conversant with Data Warehouse concepts like fact tables and dimension tables.

§  Created Shared Containers to increase Object Code Reusability and to increase throughput of the system.

§  Developed jobs in Parallel Extender PX using different stages like Transformer, Aggregator, Lookup, Join, Merge, Modify, Remove Duplicate, Oracle Stage, Sort, Peek, Row Generator, Column Generator, Sequential File, and Data Set.

§  Performed the Unit testing for jobs, sequencers and services, developed to ensure that it meets the requirements.

§  Highly involved in Performance enhancement of the process as the batch window to load the data was very small. Using various performance improvement techniques to achieve the target.

§  Extensively worked with Job sequences using Job Activity, Email Notification, Wait for File activities to control and execute the DataStage Parallel jobs.

§  Created Autosys jils for scheduling and running DataStage jobs.

 

Environment: IBM Websphere Information Server 8.1/7.5.2(Designer, Quality Stage, Director, Administrator) Teradata, Oracle 9i/10g, TOAD 9.5, Win SCP, Windows XP,UNIX- AIX, XML,  MS Word, MS VISIO, Excel, Autosys.

 

 

Confidential

Senior DataStage Developer

 Confidential  is the one of the world`s largest storage company, NetApp storage security systems deliver non disruptive, comprehensive protection for sensitive data across your enterprise. The objective of this project is to provide a dashboard with Channel Stickiness integrated with EBI. Then identify a series of high value and unique NetApp features to that application type to define a stickiness level. 

 

§  Involved in Analysis, Requirements gathering, function/technical specification, development and testing.

§  Involved in Design and Data Modeling using Star schema.

§  Created snapshot for the transactional tables in distributed databases.

§  Utilized Data stage Parallel Extender PX, to optimize performance in this very large database environment.

§  Involved in critical multiple instance DataStage jobs which will send the outbound files for different Lobs (line of business) at the same time and monitored the jobs accordingly.

§  Scheduled the parallel jobs using DataStage Director, which is controlled by DataStage engine and also for monitoring and performance statistics of each stage.

§  Created Error Tables containing data with discrepancies to analyze, re-process the data.

§  Extensively used Parallel Stages like Join, Transformer, Merge, Lookup, Filter, Aggregator, Modify, Copy, Sort, Funnel, Remove Duplicates, Surrogate key Generator, Row Generator, Column Generator, and Peek for development and de-bugging purposes

§  Used DataStage Manager to Import and Export DataStage components and Import table definitions from source databases.

§  Developed Fact Tables, Dimension Tables, Star Schema modeling and Snowflake Schema modeling.

§  Used Teradata Bulk Load stages to Load the data into Teradata Database.

§  Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers for the ETL processes.

§  Written SQL scripts to create and drop the indexes those are passes as parameters in the pre & post sessions.

§  Developed shell scripts for job scheduling and logging.

§  Involved in performance tuning of SQL queries by providing hints, obtaining Explain Plan, Analyzing tables and adding indexes.

§  Involved in full integration test and code reviews of all jobs within each sequence before migrating the jobs and sequencers from the Development environment (Dev) to the QA environment, and from the QA environment to the Production environment.

 

Software Environment: IBM Information Server 8.1/8.0.1, Ascential DataStage 7.5, Oracle 10g/11g, SQL, PL/SQL, SQL Loader, Teradata, UNIX Shell Script, TOAD , ERWIN 4.2, Win XP and AIX UNIX, Autosys.

 

 

 

 

 

 

DataStage Developer

Confidential

 

Safeway maintains operations in 27 countries and continues to expand the breadth of its offering through strategic research, development, manufacturing, sales and distribution. Through a commitment to ethics, integrity and sound business practices, Safeway remains a global leader in its markets. Worked for project-PDW (Purchasing and Manufacturing) development, maintenance, daily load and trouble shooting.

 

§  Developed DataStage Parallel & Server jobs for extraction transformation and loading of the data from source systems.

§  Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs.

§  Extensively used all activities like Routine Activity, Wait for File Activity, Exception Handler and Notification Activity.

§  Worked extensively on different types of stages like  Sequential file, Lookup File set, ODBC Stage, Aggregator, Transformer, Copy, Merge, Join, Filter, Column Generator, Funnel, Peek, Change Capture, Change Apply Stage, and several other stages for developing Parallel Jobs.

§  Implemented the Slowly Changing Dimension, SCD Type-II strategy in DataStage, for the OLAP Dimension tables storing history data.

§  Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.

§  Created job sequencers using DS parameters.

§  Coding Data Correction Utilities on the Corporate Data Warehouse (CDW)

§  Created batch files to archives the production files and cleans from production once it’s archived.

§  Created Test Plans and Test Scripts for Unit and Integration Testing for designed jobs.

§  Loading data into warehouse environment, monitoring certain automatic loads, correction reloads, all in support of an existing environment.

§  Worked with others- onsite team and offshore team, in a supporting role, to ensure ongoing quality of and availability of data warehouse environment.

 

Environment: DataStage 7.5 Parallel Extender (Designer, Manager, Director, Administrator), DataStage BASIC language Expressions, Windows NT 4.0, PL/SQL, Oracle 9i, MS SQL Server, UNIX, Sequential files, MS Access.

 

Confidential

 

Confidential is a global service provider which has done multiple prestigious projects across the globe. They were on project which is responsible for providing integrated business, technology and process solutions.

 

§  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 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.

§  Wrote PL/SQL stored procedures, functions and packages and triggers to implement business rules into the application.

§  Developed shell scripts to invoke back end SQL and PL/SQL programs

§  Performed Unit Testing to check the validity of the data at each stage.

§  Used Datastage Director to debug the jobs, to view the error log to check for errors.

§  Implemented best practices in the development environment (code standards, code migration).

 

Software Environment:

DataStage 7.0, Windows NT 4.0, Oracle 8i, UNIX, Sequential files, MS Access 2000.

 

Search Resumes

Looking for I.T Professionals on a Contract basis?