Information message
Role Description:
The Data Integration Engineer would need to have at least 3-5 years of experience. In this role, you will be responsible for the analysis, design, documentation, development, unit testing, and support of Data Integration and database objects development for software applications. As the Data Integration Engineer, you will provide support and guidance regarding Data Integration and T-SQL best practices and development standards. You will follow approved agile methodologies, leading the design and development efforts for the agile team.
Responsibilities:
- Collaborates with stakeholders and development team members to achieve business results. Work closely with other engineers to integrate databases with other applications.
- Responsible for design, development, and implementation of database applications and solutions for managing and integrating data between operational systems, data repositories, and reporting and analytical applications. This includes but is not limited to ETL, stored procedures, views, and functions.
- Recommends and provides guidance regarding Data Integration and database development, T-SQL best practices, and standards to the development team members as needed.
- Create and propose technical design documentation which includes current and future functionality, database objects affected, specifications, and flows/diagrams to detail the proposed database and/or Data Integration implementation.
- Has an understanding of the business processes and the technology platform that enables it.
- Translates stakeholder’s requirements into a common language that can be adapted for use with Behavior Driven Development (BDD) or Test-Driven Development (TDD).
- Participates in industry and other professional networks to ensure awareness of industry standards, trends, and best practices in order to strengthen organizational and technical knowledge.
- Provides support for investigating and troubleshooting production issues.
- Participate in the establishment of group standards and processes. Participates in the Communities of Practice.
- Works continually on improving the performance of source code using industry-standard methodologies.
Qualifications/Education/Certifications:
- Bachelor's degree from four-year college or university (in Information Technology or Computer Science preferred), plus three to five years related experience and/or training; or equivalent combination of education and experience.
Required Experience:
- 3+ years of Data Integration technologies and principles
- Advanced knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practices
- Experience with index design and T-SQL performance tuning techniques
- Experience integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCEL
- Working knowledge and experience in online transactional (OLTP) processing and analytical processing (OLAP) databases and schemas
- Experience with TDD/BDD
Education: Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field