• Citizen

• Full Time

• Direct Hire

• UG :- Any UG

• PG :- Any PG

• No of position :- ( 1 )

• Post :- 30th Sep 2021

Key Skill : Microsoft SQL Server

Mandatory Skills : MSSQL, Azure SQL, SSIS

Job Description:

- Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages

- Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer

- Installed and configured Master Data Services (MDS) and Data Quality Services (DQS)

- Created Data quality projects using data quality client to cleanse the address information of all the domains of MDM hub

- Cleansed master data using DQS cleansing component, TF replace unwanted character data cleansing transform, multicast, fuzzy lookup, and lookup transformations in SSIS packages. Managed indexes, statistics, and tuned queries by using an execution plan for optimizing the performance of the databases

- Wrote efficient stored procedures for the optimal performance of the system

- Created Tables, Cluster/Non-Cluster Index, Covering Index, Unique/Check Constraints, temp tables, table variable, CTE, and Stored Procedures

- Good working knowledge and experience of Jira for Requirements/ Story management and work management tools (Eg:- Kanban or Scrum)

- Good to have SQL, SSIS, and Azure Data Factory experience

- Writes technical documentation and troubleshoots complex problems.

- Communicates with technical management and other departments, reporting statuses and risks.

- Works effectively with internal and external partners.

- Works under minimal supervision.

RoleNetwork (Support) Engineer

Industry TypeIT Services & Consulting

Functional AreaEngineering - Hardware & Networks

Employment TypeFull Time, Permanent

Role CategoryIT Network

Education

UG :B.Sc in Any Specialization, B.Tech/B.E. in Any Specialization, BCA in Computers

PG :Any Postgraduate

Doctorate :Doctorate Not Required