Senior DB Integration Engineer
About The Position
Responsible for designing, developing and maintaining integrations between business applications using SSIS, OIC and other ETL tools. Focus will be on application integration between SQL database and Oracle (SaaS), ERP, and 3rd party systems. This role works as part of a team supporting one or more business domains and partners with Product Owner, Technical Project Manager and other IT team members designing and developing SSIS / OIC / SQL ETL solutions to acquire and prepare data from numerous upstream systems. Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process. Debug and tune SSIS, OIC or other ETL processes to ensure accurate and efficient movement of data. Ensure changes and updates are fully documented and tested in pre-production environment for any new applications or changes. Troubleshoot system issues and provide technical resolution to support team and other stakeholders.
Responsibilities
- Designing, developing and maintaining integrations between business applications using SSIS, OIC and other ETL tools.
- Focus on application integration between SQL database and Oracle (SaaS), ERP, and 3rd party systems.
- Partner with Product Owner, Technical Project Manager and other IT team members designing and developing SSIS / OIC / SQL ETL solutions to acquire and prepare data from numerous upstream systems.
- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
- Debug and tune SSIS, OIC or other ETL processes to ensure accurate and efficient movement of data.
- Ensure changes and updates are fully documented and tested in pre-production environment for any new applications or changes.
- Troubleshoot system issues and provide technical resolution to support team and other stakeholders.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
