C

.NET Development, SSIS Expert

codersbrain Verified employer

Actively hiring · Posted today · JEV2611ED9B1DF15C

Salary₹6,00,000 – ₹10,00,000 per year
Experience4–6 yrs
LocationGurugram, Haryana
Work modeOffice · Full time
Openings1

Job description

Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.Create routines for importing data utilizing XML, CSV and comma delimitate files.Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.Extract the data from XML and load it to dimensional model.Maintain SQL scripts, indexes, complex queries for data analysis and extraction.Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.Develop T-SQL functions and store procedures to support complex business requirements.Create and configure an OLTP replication database for disaster recovery purpose.Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

Key skills

How to apply

  1. Sign in or create your free profile — takes about two minutes.
  2. Apply with one tap — your profile is shared directly with codersbrain.
  3. Track your application and get updates by email and WhatsApp.
Apply now
You may also like

Similar jobs

More jobs
Salary not disclosed 3–7 yrs Ahmedabad, Gujarat Hybrid · Full time
B2B salesbusiness developmentclient engagementDigital Transformation
Today · JEV2611C52464FFDEView & apply
.NET Development, SSIS Expert₹6,00,000 – ₹10,00,000 /year · Gurugram
Apply