part time typist jobs from home

• an introduction of data warehousing
• purpose of data warehouse
• data ware architecture
• oltp vs data warehouse applications
• data marts
• data warehouse lifecycle
• sdlc

part time typist jobs from home

• introduction of data modeling
• entity relationship model
• dimensions and fact tables
• logical modeling
• physical modeling
• schemas like star schema & snowflake schemas
• fact less fact tables

part time typist jobs from home

• introduction of extraction , transformation and loading
• types of etl tools
• key tools in the market

differenttypes of testing techniques in etl

part time typist jobs from home

• purpose of testing
• how to maintain quality & standards
• responsibilities of a etl tester

part time typist jobs from home

• analysing thepart time typist jobs from homebusiness requirement documents
• understanding mapping sheets
• following job dependency

part time typist jobs from home

• basic select statements
• creating sub queries
• using different type of joins

part time typist jobs from home

• etl testing work flow process
• how to prepare the etl test plan
• how to design the test cases in etl testing.
• how to reporting the bugs in etl testing?
• etl testing responsibilities in datastage, informatica, abinitioetc;
• how to detect the bugs through database queries
• etl testing & performance tuning

part time typist jobs from home

• what is unix?
• how to create, list files and directories
• displaying or searching the contents of a file
• moving files from one directory to another