Hands-on experience in developing ETL processed in MS SQL environment using SSIS, SQL and stored procedures.
Experience using MS SQL Server for DDL/DML/DCL, specifically as it relates to database design, implementation, efficiency and performance.
Hands-on SQL programming experience is required
Experience in programming SSIS packages using SQL Server Agent
Experience with developing data models for database schemas, stored procedures, functions, views, triggers in OLTP and OLAP based environments
Experience with fundamental administrative performance and design capabilities including indexing, data partitioning, creating and restoring backups, jobs, etc.
Knowledge of relational database concepts - SQL.
Fundamental knowledge and exposure to data management capabilities.
Knowledge of .NET, C# and a proficiency in programming in C#, ASP.NET is a plus
Ability to test scripts and review and document results