Job Description:
1. Use Microsoft Visual Studio to create and maintain SSIS packages and projects.
2. Extract data from various sources, such as databases, spreadsheets, flat files, or APIs.
3. Create and maintain database stored procedures and functions.
4. Contribute to the design of a data warehouse architecture that supports data storage, retrieval, and analysis.
5. Optimize query performance by creating indexes.
6. Diagnose and troubleshoot various rules, calculations, and data issues on application reports using Crystal Reports.
7. Report status of current tasks and outstanding issues to supervisor.
Mandatory Skills:
84 months ETL (Extract, Transform, and Load) experience creating SQL Server SSIS objects
84 months SQL Server Programming; views, stored procedures, and functions.
60 months of experience with Data Warehousing.
60 months experience with OLAP (On-line Analytical Processing).