Job Description :
Expert in Data Extract.
Create several data files (Members, Staff, Subscriptions, Employment, Clip cards, Postal Codes, etc sourced from different SQL Server databases.
Consolidate all data files into respective tables in a stand-alone SQL Server database.
Create a full Database back up BAK
SQL Skills: SELECT, LEFT/OUTER JOIN, DDL-create tables, Temp tables and/or WITH Clauses.
SSMS – Export, Import Data, DB Backup.
Understand importance of NULL handling, date formatting, and different data types among different data sources /databases.
Requirements gathering & documentation.
Coordinate data file load dependencies & sequencing.