Job Description :
Job Description (SSIS & SQL Server)
Advanced experience with SQL Server 2008R2/2012/2014/2016, including T-SQL, SSIS
Proficient in OLTP, OLAP and Data Warehousing Design concepts.
Proficient on ETL/DW development using SSIS & XML as source • Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
Expertise in creating SSIS packages, jobs . Strong communication skills
Familiarity with JIRAand Confluence is a plus
Excellent problem-solving, analytical and critical thinking""
Knowledge of Dimensional modeling, star schema, snowflake
Strong at developing SSIS,& DTS packages. • Strong knowledge in T-sql • Knowledge MS SQL administration like installation & Configu
Strong in Jobs schedule , Profiler ,operators , alerts in MS SQL .
Basics of Windows , Task scheduler jobs"