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