Datastage Developer

DATASTAGE DEVELOPER

Datastage developer is urgently required for a contract positon with major blue chip client in a great location

Key skills

- Data Warehouse(Datastage) development, experience in developing DataStage jobs
- Experience in DW/BI technologies & experience in ETL DataStage tool.
- Will Use ETL Tool, to create jobs for extracting the data from different databases, flat files & Mainframe files.
- Will lead overall ETL process and architecture, perform build, testing and deploy activities related to BI and data warehouse implementations
- Worked extensively in parallel jobs, sequences and preferably in routines. Good conceptual knowledge on data-warehouse and various methodologies
- Strong knowledge and experience in SQL programming, DB procedures, tuning and optimization experience
- Good experience in designing, building and optimizing data marts
- Should have very good knowledge & hands-on experience of Teradata database
- Should have Data Modeling experience
- Good knowledge on Teradata Architecture, data ware housing concept and relational data bases.
- Working knowledge on creation of database objects like tables, views, joins and indexes

BACKGROUND AND SKILLS

- Good conceptual knowledge on Financial data-warehouse and various methodologies
- Experience in Requirements Analysis, Design, Development, Testing and Implementation of Data warehouses and Database business systems.
- Strong knowledge and experience in ETL development
- Exposure to reporting tools such as Microstrategy.
- Excellent Communication skills
- Able to work effectively with remote locations including onsite/offshore stakeholders/teams

SHOULD HAVE HANDS-ON WORKING KNOWLEDGE OF FOLLOWING DWH ENVIRONMENT-

- Database - Teradata (SQL/Views/Database Modeling)
- ETL Tool - Datastage
- Reporting - Microstrategy & Cognos