Data Engineer

Data Engineer experience in SSIS, SSRS

Location: Columbia, TN

Long Term Project

Please drop for the profiles

Roles and Responsibilities:

. Design and develop database solutions - Creating and maintaining databases in

Microsoft SQL Server.

. ETL Development - Create and maintain appropriate packages and stored

procedures in SSIS to pull data from various source systems and load into

destination databases on SQL Server

. MDM Master Data Management Development - Create and maintain scripts in

MDM Tool Semarchy xDM

. Optimize database performance - Ensuring that the database performs optimally

by tuning queries, indexes, and other database objects.

. Monitor and troubleshoot database issues - Monitoring the database for

performance issues, errors, and other issues, and troubleshooting those issues as

they arise.

. Maintaining database security - Work with DBAs and team to ensuring that the

databases are secure by implementing and maintaining appropriate security

measures, such as access controls, encryption, and auditing/logging.

. Develop DevOps for Data - Work with the DevOps group to help set up

appropriate procedures and pipelines for data packages.

Qualifications:

. Bachelor"s or master"s degree in technical or business discipline or equivalent

experience.

. 8+ years of professional experience as a Data Engineer.

. Hands on Experience with any MDM Tool preferably Semarchy Xdm.

. Proven experience as a SQL Database Developer.

. Expert in writing complex SQL queries and stored procedures using Microsoft SQL

Server.

. Experience with database design, optimization, and performance tuning.

. Designing, developing, and maintaining ETL process using SQL server Integration

services (SSIS).

. Extracting data from various data sources, transforming, and loading it into target

systems