We provide IT Staff Augmentation Services!

Datastage Architect/tech Lead/sr Datastage Developer Resume

TX

SUMMARY

  • Over 11 years of experience in the field of Information Technology, with extensive experience in designing, developing and implementing Data Warehouses and DataMart for Retail and Financial Industries.
  • Extensive experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using ETL Tools DataStage EE (Manager, Designer, Director, Administrator), Parallel Extender, Teradata, Informatica, Modeling Tool Erwin, ETL, OLAP and OLTP
  • Experienced in Database design using Teradata, Oracle 9i, SQL Server 2000, with knowledge of ER - Diagrams, Entities, Granularity, Cardinality, Entity and Associations.
  • Highly motivated, result oriented professional with a short learning curve and excellent communication skills.

TECHNICAL SKILLS

ETL: IBM DataStage 11.3/9.1/8.7/8.5/8.1/8.0/7.5/7.0/6.0/5.2 (Manager, Administrator, Designer, Director, Parallel Extender, Business Glossary), IBM Pack for SAP BW 4.0.1 and Ascential Pack for SAP R/3 5.0,Informatica, Data Warehousing, Metadata, DataMart, OLAP, OLTP, SQL*Plus

Reporting: Oracle SQL, PL/SQL, Teradata, SAP Business Objects

Databases: Oracle 10g/9i/8i/8.0.3/7.3, Teradata v12.0, SQL Server 2000, DB2, MS Access

Data Modeling: Erwin 4.0, Designer 2000, Star Schema, Snowflake Schema

Others: Visual SourceSafe, Clear Case, Korn Shell, Control-M and AutoSys

Programming: UNIX Shell Scripting, SQL, PL/SQL, C, C++, CGI/PERL, Java

Environment: Win 3.x/95/98/2000, UNIX, MS-DOS, and Red Hat Linux.

PROFESSIONAL EXPERIENCE

Confidential, TX

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

  • Worked on multiple projects to accommodate specific data delivery needs
  • Implemented solution architecture for wealth management scorecard and financial advice groups
  • Performed data discovery, analysis to provide support to business users on current state situation
  • Designed reusable artifacts for data processing
  • Supported business users on different business objects reports data drills and associated issues
  • Supported UAT environment for verification of data loaded for major high priority fixes
  • Involved in planning and effort estimates for different tasks
  • Worked on data validations and reconciliations efforts
  • Worked on scheduling ETL jobs through control-m for overall integration
  • Worked on Hadoop to archive source data and core tables

Environment: IBM InfoSphere Information Server V 9.1/11.3 DataStage, Oracle, IBM Netezza, LINUX, SAP Business Objects,Hadoop, IBM BigInsights and Control-M

Confidential, NJ

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

  • Worked on data delivery of different replication efforts
  • Assisted in Setting up application specific UAT environments
  • Designed ETL framework for DR solution copy the production data to backup database
  • Supported QA and UAT environments for different data needs
  • Worked on Involved in planning and effort estimates for different tasks
  • Assisted in infrastructure setups required for environment setups
  • Worked on data validations and reconciliations efforts
  • Worked on scheduling ETL jobs through autosys for overall integration
  • Involved in production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 9.1 DataStage, Oracle, Green Plum, UNIX and Autosys

Confidential

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

  • Involved in planning and effort estimates for different tasks
  • Gathered requirements for both data and reporting layers
  • Assisted in infrastructure setups required for data extraction
  • Worked as a data modeler for the datawarehouse build
  • Created Mapping document to build the datawarehouse
  • Designed ETL framework for to load data from different source systems
  • Worked on production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 8.5 DataStage, DB2, IBM Netezza, Red Hat Linux

Confidential, NY

DataStage Architect/Tech Lead/Sr Datastage Developer

Responsibilities:

  • Involved in planning and effort estimates for different tasks
  • Designed ETL solution for HR Workday integration
  • Analyzed workday extracts to gather requirements
  • Created design and mapping documents for different efforts on multiple tasks
  • Worked as SME for different key Subject areas
  • Worked extensively with XML stage to parse the Workday source data
  • Designed data integration pattern for extracting Workday data which includes public API, Custom reports extract from HR Workday to HR Data Warehouse using XML integration with Datastage Web service method.
  • Developed and tested the Workday Web service job using SOAP UI and optimized the Workday data extract performance using Webservice Client stage
  • Coded and unit tested the complex components to meet the business specific requirements
  • Validated the data loaded through datastage programs using sql
  • Interacted with business users and OBIEE reporting team on validation issues for bug fixes
  • Worked on Performance tuning of datastage designs for faster availability of critical data for reporting
  • Proactively interacted with infrastructure team to address capacity management issues
  • Worked with team on different phases to ensure application data quality and in-time delivery of the data
  • Worked on production support activities on a rotation basis

Environment: IBM InfoSphere Information Server V 9.1 DataStage, SQL Developer, ORACLE 11i/10g, OBIEE, XML, Workday, Red Hat Linux

Hire Now