Data Engineer

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