Develop, test, and maintain data interfaces and integrations using SSIS, T-SQL, managed file transfer tools, and business integration platforms. Translate business requirements into technical designs, build and optimize database objects, troubleshoot interface issues, document solutions, and support customer integrations.
Responsibilities
- Develop, test, document, and maintain inbound and outbound data interfaces.
- Create and modify SSIS packages and processes using managed file transfer and business integration platforms.
- Translate functional specifications into technical designs with analysts and business users.
- Develop reusable database objects and improve SQL query and stored procedure performance.
- Monitor interface environments, troubleshoot data issues, and implement solutions to prevent recurrence.
- Maintain documentation and tickets, communicate with clients, and participate in the on-call rotation.
Required Skills
- T-SQLSQL Server
- SSIS package development
- Relational database design
- Database objects
- Stored procedures
- Views
- Triggers
- Indexes
- Data interface and integration development