We provide IT Staff Augmentation Services!

Sr. Data Stage Developer Resume

SUMMARY

  • Over 8 Years experience using DataStage 11.3/8.5/8.1/8.0/7.5 .1 (Datastage Manager, Datastage Designer, Datastage Administrator and Datastage Director) and developing Datastage Parallel Extender jobs using various Datastage stages such as Lookup, Join, Merge, Funnel, Remove duplicates, Aggregator, DB2 Connector, Oracle Connector, Teradata Connector .
  • Working with DB2, Teradata, Mainframe sources, Oracle feeds, Flat files, datasets operational sources.
  • Expertise in data warehousing concepts, ETL programming using Ascential Datastage Parallel Extender 7.x, Server jobs, Job Sequencers, Batch Jobs and other data warehouse lifecycle tasks such as data analysis, cleansing, transforming, debugging/testing, and data loading across source systems.
  • Extensive experience developing Unix Shell Scripts for automating Extract, Transform, Loading process for various feeds and enabling the execution of jobs in Production environment using scheduler ESP,CAWA.
  • Developing user - defined Transforms and Routines in Datastage Server job Edition to solve complex business logic. Optimizing job performance with various partitioning techniques in the parallel processing environment.
  • Performance tuning of ETL applications using configuration file tuning in areas involving processes such as I/O, scratch space optimization, sort, lookup, join and memory configuration.
  • Strong knowledge of database querying using Oracle and Teradata Databases
  • Excellent experience in TERA DATA Utilities: BTEQ, Fastload, Multiload, Fastexport
  • Expertise in UNIX Shell Scripting, SQL.
  • Experience in using of migration strategies and methods.
  • Assisted in logical, physical data modeling and conceptual data modeling and performance tuning of IBM DB2 database, SQL, ETL processes.
  • Good understanding of Data Warehouse and Business Intelligence concepts and fundamentals e.g. schemas, keys, OLTPs. Vs. DW structures, normalization, fact and dimensional tables etc.
  • Experience in working in Agile Development environment with Scrums and Sprint Cycles
  • Working experience of Performance Testing
  • Skilled in using Test Management Tools like Quality Center and Jira.

TECHNICAL SKILLS

ETL/Reporting Tools: Datastage 11.3/8.5/8.1/8.0/7.5 x2 EE & SE (Administrator, Designer, Director, Manager), Parallel Extender, Server & Parallel Jobs

Data Modeling: Dimensional, Logical & Physical Data Modeling, Star Schema, Snow-Flake Schema, Erwin 3.x

Databases: Teradata V2R5/R6/R7, Oracle 10g/9i/8i, DB2 8.0/7.0, Toad,SAP R/3, SQL Server

Programming: SQL, UNIX Shell Scripting

Operating Systems: Unix(AIX,SOLARIS,HP-UX), Linux, Windows NT/XP/2000/2003

Middleware: MQ-Series, WebSphere MQ.

Supply Chain: JDA

CI Integration: Chef, Github and EC

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Stage Developer

Responsibilities:

  • Responsible for coordinating with Business Analysts and Business users to understand the new proposals and their impact.
  • Involved in the Analysis and Effort estimation for various levels (complexity) of Data Stage jobs.
  • Preparation of Detail Design document based on the Business requirement.
  • Analysis, design and review of the Data Stage Jobs and SQL scripts.
  • Reviewing of Unit Test and System Test Cases and creation of UTR for the executed Unit Test Cases and deliver the Test results.
  • Developing ETL jobs in Data Stage Designer 11.3 and debugging the jobs using Director.
  • Involved in System testing and Integration testing.
  • Exporting and Importing of the jobs into System Test environment and preparation of the Implementation Plan for deployment into various environments.
  • Configure and test the ODBC connection for Data Stage with the Database connection credential.

Confidential

Sr. Data Stage Developer

Responsibilities:

  • Responsible for coordinating with Business Analysts and Business users to understand the new proposals and their impact.
  • Involved in the Analysis and Effort estimation for various levels (complexity) of Data Stage jobs.
  • Preparation of Detail Design document based on the Business requirement.
  • Analysis, design and review of the Data Stage Jobs and SQL scripts.
  • Reviewing of Unit Test and System Test Cases and creation of UTR for the executed Unit Test Cases and deliver the Test results.
  • Developing ETL jobs in Data Stage Designer and debugging the jobs using Director.
  • Involved in System testing and Integration testing.
  • Exporting and Importing of the jobs into System Test environment and preparation of the Implementation Plan for deployment into various environments.
  • Configure and test the ODBC connection for Data Stage with the Database connection credential.

Confidential

Sr. Data Stage Developer

Responsibilities:

  • Developing ETL jobs in Data Stage Designer and debugging the jobs using Director.
  • Involved in Unit Testing/Functional Testing in Data Stage.
  • Involved in writing shell scripts in UNIX.
  • Validating data from the corresponding tables using Toad.
  • Logging the defects in Quality Center.
  • Retesting and closing the defects.
  • Consolidated daily system test will be sent to the client on daily basis
  • Coordinate with the team to keep track the tasks assigned to individuals.
  • Creating and executing the jobs through ESP session.

Environment: Datastage 8.5,Oracle 10G,Quality Center 9,TOAD, Windows XP

Hire Now