SSIS Expert/Integrations Engineer Job Description
Responsibilities:
1. Design and develop SQL Server Integration Services (SSIS) packages to extract, transform, and load (ETL) data from various sources.
2. Develop and maintain complex ETL processes to ensure data integrity and accuracy.
3. Develop T-SQL functions and stored procedures to support complex business needs.
4. Manage database artifacts and provide subject matter expertise on best practices for creation, deployment, and ongoing management of databases in a reporting/BI environment.
5. Monitor daily SSIS jobs and data loads, proactively resolving issues to ensure maximum uptime and availability of the database for reporting.
6. Communicate clearly and confidently with Business Analysts, Project Managers, Architects, and Infrastructure Engineers about the SSIS platform and the technical configuration of SSIS Interfaces, Packages, and Jobs.
7. Deputize for the Integrations Team line manager as needed.
Qualifications:
1. Experience designing, developing, supporting, and implementing integrations using Microsoft solutions (SQL Server and SSIS).
2. Demonstrated experience with SQL, proficiency in creating and maintaining complex MS SQL queries.
3. Knowledge of data formats and standards such as XML, JSON, and CSV.
4. Ability to work independently and as part of a team.
5. Ability to use Source Control using GIT and Azure DevOps.
6. (Bonus) Knowledge and understanding of Azure Integration Services (Logic Apps, Service Bus, API Management, Event Grid, Azure Functions, Azure Data Factory).
This role requires a blend of technical expertise, creativity, and problem-solving skills to effectively manage and utilize data for Business Intelligence and reporting purposes.
#J-18808-Ljbffr