Datastage Lead Resume
Phoenix, AZ
SUMMARY
- Primary Core competency, Experience in IBM Information Server and IBM Datastage V8.0.1, V8.1 & V8.7 with Mapping architecture, System Analysis and Design, Business Process Analysis and system design(Datastage Job design), database design, coding, testing, debugging, implementation, training, and maintenance.
- Good knowledge of scheduling tools like Control - M, Auto Sys and Tivoli.
- Have a good exposure in IBM DB2 9.0, Netezza, Oracle 11g, Sybase and Teradata.
- Strong knowledge in Salesforce.
- Also have strong knowledge of UNIX Shell scripting.
- Excellent Communication Skills. Regularly interact with Customers and client managers.
- Good experience in Quality Center for recording and updating defects.
- Good Understanding of Datawarehouse and Datamart systems which includes physical and logical Data models.
- A strong foundation in Software Development Life Cycle (SDLC).
- Hands on experience with relational databases including Oracle, SQL Server and MySQL involving stored procedures, triggers, functions, indexes, and packages.
- Strong in solving problems of diverse scope where technical analysis and evaluation is required.
- A self-motivated, responsible and reliable team player with a set of strong technical skills.
TECHNICAL SKILLS
Operating Systems: Windows, UNIX
Programming Languages: C, C++
Databases: Salesforce, Oracle, MySQL, IBM DB2 and Teradata
Scheduler: Control-M, Tivoli and Auto Sys
Scripting Languages: Shell Script
ETL Tool: IBM DataStage, Informatica Cloud and Quality Stage
PROFESSIONAL EXPERIENCE
Confidential, Phoenix, AZ
DataStage Lead
Environment: IBM Datastage, Oracle, Sybase,UNIX, Tivoli.
Responsibilities:
- Code/Design reviews
- Guided team on various solution part as part of implementation
- Preparing Test case Document.
- Promoting the jobs to production environment & schedule them in AutoSys ( Scheduling tool for DataStage jobs)
- Monitoring of the ETL batch processing to ensure population of the data warehouse within the defined SLA. This involves reject analysis and quick fixes also.
Confidential, Boston, MA
DataStage Lead
Environment: IBM Datastage, Oracle, UNIX, Auto Sys
Responsibilities:
- Involved in the requirement analysis with the client.
- Involved in preparation of Mapping Document.
- Preparing High Level Design Document (which includes preparing Flow chart and Visio) & Technical Specification document by analyzing Business Requirement Document (BRD)
- Code/Design reviews
- Guided team on various solution part as part of implementation
- Preparing Test case Document.
- Promoting the jobs to production environment & schedule them in AutoSys ( Scheduling tool for DataStage jobs)
- Monitoring of the ETL batch processing to ensure population of the data warehouse within the defined SLA. This involves reject analysis and quick fixes also.
Confidential, Boston, MA
DataStage Lead
Environment: IBM Datastage, Salesforce, Oracle, UNIX, Auto Sys, Teradata, DataLoader,Quality Center
Responsibilities:
- Preparing High Level Design Document (which includes preparing Flow chart and Visio) & Technical Specification document by analyzing Business Requirement Document (BRD)
- Code/Design reviews
- Component identification for reuse
Confidential, Boston, MA
DataStage Lead
Environment: IBM Datastage, IBM Quality Stage, Salesforce, Oracle, UNIX, Auto Sys, Teradata, DataLoader, Cognos,, Quality Center
Responsibilities:
- Involved in the requirement analysis with the client.
- Involved in preparation of Mapping Document.
- Coding and design reviews.
- Involved in Standardization and De-duplication of data.
- Preparing Test case Document.
- Creation of Auto Sys jobs.
- Promoting the jobs to production environment & schedule them in AutoSys ( Scheduling tool for DataStage jobs)
- Monitoring of the ETL batch processing to ensure population of the data warehouse within the defined SLA. This involves quick fixes also
