Information Technology Developer

Technical Skillset :

 SQL Development• Stored Proc, User-Defined Functions• Temp Table: different types and usage• In-Memory Tables• SQL Queries Performance Tuning and handling complex scenarios• Transaction Isolation and avoiding deadlocks

 Data Modeling• different levels of Normalization• different types of Index and usage scenarios• Analyze and decide on the structure of data for both reporting and data lake requirements

 SSIS• Load from CSV, Excel, ORACLE Tables, and Other ODBC Sources• Copy files from SFTP Locations• Connecting to Sharepoint List (Office365 & OnPremises)• Using Configuration File for Connection Strings• Handling delimiter issues while loading CSV/flat files

 SSAS• Build/deploy/debug SSAS Cubes• Programmatic processing of Dimensions/measures using XMLA• Troubleshoot issues in Processing and Query Errors• Calculated Measures• Build MDX to query and validate data

Qualification :

 BE/B.Tech/MCA (or equivalent) 5+ years of relevant Technical Experience

Key Skills Required: MSBI Skills Mandatory SSAS and SSIS

Key Skills

• SQL