We provide IT Staff Augmentation Services!

Sr Datastage Developer / Production Support Resume

3.00/5 (Submit Your Rating)

Jacksonville, FL

SUMMARY

  • Over 7 years of experience in the IT industry with extensive skill set dedicated to business and System Analysis, Data Modeling, Data warehousing on Client, Server and Web - Enabled Systems, which includes over 6 years of expertise in Development and Implementation of Data Warehouse applications using ETL tool IBM Information Server (IBM Websphere DataStage 8.1/8.0.1/7x/7.5 DataStage Enterprise Edition (Parallel Extender)).
  • Expertise in Development and Implementation of Data Warehouse applications using ETL tool IBM Websphere DataStage 8.1/8.0.1/7. 5.2/7. x.
  • Strong combination of business analysis, database and data warehouse (OLAP) technical experience and over six years of experience in IBM Websphere DataStage.
  • Involved in conducting design and review sessions with Consulting staff and Management.
  • Experience in design and implementation of Server and Parallel jobs including Batches and Job Sequencers.
  • Extensive experience in Database/Datawarehousing/Client/Server/Legacy applications for Banking, Reinsurance, Financial, Pharmaceutical and other industries using Data Analysis, Data Modeling, Data Extraction, Data Transformation and Data Loading.
  • Participated in all phases including requirements analysis, client interaction, coding, testing and documentation.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in Relational, Dimensional and Multidimensional modeling.
  • Comfortable in using ERwin 4.0/3.5 Tool for Logical and Physical data modeling.
  • Experience in writing Unix Shell programming/scripting for various purposes like file validation and job scheduling.
  • Extensive experience in Teradata 12.0, Oracle 10g/9i/8i, Database development experience using PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views and Oracle Objects.
  • Experience in Designing, Developing, Reengineering, Deploying and fine-tuning Oracle Stored Procedures.
  • Experience in HP Quality Center to manage manual and automated test cases and to track defects.

TECHNICAL SKILLS

ETL Tools: IBM Information Server (IBM Websphere DataStage 8.1/8.0.1/7. x/6.0/5.x, Parallel Extender (PX), IBM Websphere QualityStage)

RDBMS: Teradata 12.0, Oracle 10g, 9i, 8i (SQL Plus, PL/SQL, Forms, Report Writer), DB2 8.x, SQL Server 2005, MS Access

Development Languages: C, C++, SQL, PL/SQL, BASIC and PASCAL

Web Technologies: ASP, HTML, Macromedia Flash and Dream Weaver

Operating Systems: UNIX, Red Hat LINUX, Windows NT 4.0.,VISTA

Other: TOAD 9.5.0, SQL Developer, ERwin

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr Datastage Developer / Production Support

Responsibilities:

  • Understand business needs and implement the same into a functional database design.
  • Prepare the Mapping document for new development in DataStage jobs.
  • Work with Offshore team as on-site coordinator.
  • Design the DataStage Jobs & providing technical support to off shore team.
  • Use DataStage Manager utilities in designer for importing metadata from repository, creating new sequential file definitions and importing/exporting jobs.
  • Use DataStage Director to validate, run and monitor the DataStage jobs.
  • Use Parallel Extender Development/Debugging stages like Row generator, Column Generator, Head, Tail and Peek.
  • Use Lookup, Join and Merge stages for joining various information and also use Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator.
  • Responsible for performance tuning of the ETL process and upgrading the ETL best practices document.
  • Use both Pipeline and Partition Parallelism for improving performance.
  • Investigate data to identify errors and validate the contents of fields in a data file.
  • Tune the DataStage repository and jobs for optimum performance.
  • Develop multiple jobs using Teradata stages that include Teradata Connector, Teradata Enterprise, Teradata Multiload to connect to database, hashed file, aggregator and sequential file stages.
  • Create multiple shell scripts for cleaning and loading data and scheduling DS job process.
  • Design Autosys scheduling scripts to schedule DataStage jobs and run then through Autosys scheduler.

Environment: IBM Websphere Datastage 8.1,UNIX, Shell Scripting, Autosys 4.5, Teradata 12.0.

Confidential, Philadelphia, PA

Sr DataStage Developer

Responsibilities:

  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Used stages like Transformer, Complex flat file stage and DB2 load ready stage to write the data from the various sources into the target Data marts.
  • Identified other source systems like Oracle, SQL Server their connectivity, related tables and fields and ensure data suitably for mapping.
  • Developed Parallel jobs using stages Change Capture, Change Apply, Head and Surrogate Key Generator etc.
  • Developed Server jobs using stages ODBC, Link Partitioner, Aggregator, Transformer, Link Collector and Hash File etc.
  • Generated Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.
  • Created surrogate key tables to map the required dimensions.
  • Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
  • Used hash file look-up for better performance of jobs.
  • Created re-usable components using shared containers for local use or shared use.
  • Import and export of repositories across projects.
  • Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
  • Wrote routines for transforming Nulls to default values.
  • Troubleshoot the designed jobs using the DataStage Debugger.
  • Tuning DataStage transformations and jobs to enhance their performance.
  • Wrote PL/SQL stored procedures for writing data into date dimension.
  • Used the DataStage 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.
  • Created job schedules to automate the ETL process.
  • Involved in creating technical specifications, migration specification and unit tests.

Environment: Ascential DataStage 8.1 (Designer, Director, Manager, Debugger, DataStage BASIC language Expressions), Windows NT 4.0, IBM AIX 5, Oracle and MS Access.

Confidential, Princeton, NJ

ETL DataStage Developer

Responsibilities:

  • Analyzed, designed and developed ETL jobs for Vendor Feeds.
  • Encrypted files before sending to vendors.
  • Created shell scripts to integrate the process of Hashing, Encrypting and FTP.
  • Created Datastage jobs to load data to Internal data feeds.
  • Scheduled and monitored the HR HUB Vendor feed jobs in Production.
  • Reviewed the errors in Organizational Manager production jobs and apply fixes.
  • Documented the HR HUB InBound and OutBound process.
  • Created the logical and physical data model for HR Data Mart.
  • Implemented Slowly Changing Dimension Type2 process for HR Data Mart.
  • Developed jobs to load dimension and fact tables.
  • Maintained the DataMart database objects.
  • Documented the entire ETL Process in the ETL Design document.
  • Improved the run time for the process that loads the fact table.

Environment: IBM WebSphere DataStage 8.0.1, SQL Server 2005, Oracle 10g, Red Hat LINUX, TOAD 9.5.0, SQL Developer, ERwin.

Confidential, Wilmington, DE

ETL DataStage Developer/Analyst

Responsibilities:

  • Coordinated requirement gathering sessions with business analysts, end users and people from the involved departments.
  • Converted Functional Requirements into Technical Specifications, developed project management methodology, estimated storage requirements and identified information delivery strategy.
  • Designed and Developed ETL process to populate data mart using PL/SQL and Datastage.
  • Designed and developed Stored Procedures, Functions, Triggers and Sequence for business logic as required.
  • Convert server jobs into parallel jobs to increase the performance of server jobs when the data load increases.
  • Extensively worked on Parallel Extender PX using lookup, merge, join and change capture stages.
  • Created a job to fix historical bad data.
  • Used Control-M to schedule the jobs, Win CVS for version controlling and Microsoft Visio for creating technical drawings.
  • Worked with Business Analysts to prepare ETL Mapping Documents and design documents.
  • Extensively used Stage variables, Shared containers and Hash files.
  • Coordinated Post Implementation Analysis meetings for the manager to analyze what were the positive points learnt from the project, which can be used in the project management methodologies for future. And also to analyze what the reasons were causing delays in development and implementation phases.

Environment: IBM Datastage 7.5.2, Parallel Extender, Control-M, CVS, Erwin4.x, Oracle10g, Oracle 9i, KSH Scripts, pl/sql, SQL Plus, Toad, UNIX, SQL Navigator and Sun Solaris.

Confidential, Irvine, CA

ETL DataStage Analyst

Responsibilities:

  • Used Ascential DataStage Parallel Extender as an ETL to extract data from sources like DB2, XML and flat files and loaded to target tables.
  • Developed job sequences to run jobs in parallel and in series taking into consideration the interdependencies.
  • Developed Datastage Parallel jobs for various components and strings involved in the calculation of quotes and rates.
  • Monitored the performance of Parallel jobs by turning on various Environment Variables.
  • Utilized Datastage Parallel Extender PX, to optimize performance in this very large database environment.
  • Used Datastage Designer to design and develop jobs for extracting, transforming, integrating, and loading data into the Staging Area.
  • Used Version Control and segregated the latest versions of updated jobs and sequences.
  • Extensively developed Shared Container jobs for reusable code.
  • Developed HASH file stages to improve performance by reducing the reference lookup time.
  • Implemented the underlying logic for Slowly Changing Dimensions.
  • Extensively used Datastage Designer stages such as ODBC, Aggregator, Transformer, Join, Dataset, Lookup and Modify.
  • Extensively used Stage variables in jobs to take care of where clause before aggregations.
  • Created cron jobs to automate the various shell scripting functionality.
  • Used QualityStage Jobs to cleanse the data, by calling it from Datastage.
  • Worked with Business Analysts to prepare ETL Mapping Documents.
  • Implemented Best Practices of DataStage.

Environment: Ascential Datastage 7.5, Parallel Extender, QualityStage, Erwin, DB2 UDB, Oracle 9i, Shell Scripts, Version Control, Met broker, SQL loader and UNIX.

Confidential

ETL Developer/DataStage Analyst

Responsibilities:

  • Involved in Architecture, analysis and design of data model (Star Schema).
  • Prepared the requirements, design, mappings, unit & integration testing documents.
  • Developed SDLC technical documentation on the workflow and development process of universes and functional specifications of reports.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Involved in creating ER Diagrams, tables, views, table level constraints and triggers to enforce referential integrity.
  • Wrote SQL, PL/SQL, stored procedures, triggers and cursors for implementing business rules and transformations.
  • Worked on Ascential DataStage Designer, Manager and Director.
  • Analyzed quality of data from the vendors using SQL queries.
  • Loaded data into target, staging and lookup tables.
  • Created master controlling sequencer jobs using the DataStage Job Sequencer to Schedule, compile and run DataStage jobs.
  • Utilized DataStage Parallel Extender PX, to optimize performance in this very large database environment.
  • Designed and developed jobs using Parallel Extender for splitting bulk data into subsets and dynamically distribute to all available nodes to achieve best job performance.
  • Designed the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
  • Developing Architecture for building a Data mart by using data modeling tool Erwin.
  • Extensively coded PL/SQL writing Stored Procedures and packages including functions.
  • Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
  • Analyzed MS SQL Server databases to determine needed data.
  • Took logical Backups using Export, Import and performed Recovery when needed.

Environment: DataStage 7.X, Oracle 8i, SQL Server 2000, DB2 UDB, SQL, Erwin.

Confidential 

Analyst/Developer

Responsibilities:

  • Developed web pages using servlets and server side functionality.
  • Review meetings with manager while functionalities of the product.
  • Coordinate with team member for integration of modules.
  • Developed Shell Scripts for building and packaging application.
  • Design and develop the data entry screens.
  • Planning and Implementing Backup and Recovery processes.
  • Tested and debugged the modules along with the other modules to implement the business logic.
  • Implemented User security by creating User Profiles Roles.
  • Also involved in drawing the Data Flow Diagrams.

We'd love your feedback!