SQL Data Integration Engineer OpenGate ETL

OpenGate with SQL

Location: Nashville TN (Onsite)

Project duration: 1 year

Primary skills: OpenGate and SQL.

Secondary skills: SSIS/ETL

Key Responsibilities:

Stored Procedures Development: Design write and optimize complex stored procedures to support data processing reporting and application functionalities.

Data Workflow Automation: Develop and maintain automated data workflows to ensure efficient data movement and transformation across various systems and databases.

ETL Process Design: Design implement and manage ETL (Extract Transform Load) processes to support data integration from various sources into data warehouses or other centralized systems.

Data Standardization: Establish and enforce data standards to ensure data consistency accuracy and quality across the organization. Develop data transformation rules and procedures to standardize incoming data.

Performance Tuning: Monitor and optimize database performance including query tuning and indexing to ensure efficient data processing and retrieval.

Collaboration: Work closely with data analysts database administrators and other stakeholders to understand data requirements and deliver solutions that meet business needs.

Documentation: Create and maintain comprehensive documentation for all developed processes including stored procedures data workflows ETL processes and data standardization protocols.

Troubleshooting: Diagnose and resolve datarelated issues including data inconsistencies workflow failures and performance bottlenecks.

Required Qualifications:

• Must Have 5 years of experience in database development with a focus on writing stored procedures in SQL
• Must Have Excellent knowledge on writing OpenGate queries for Meditech
• Strong experience in developing and managing ETL processes using tools like SSIS
• Proficiency in data workflow automation tools and platforms like Power automate
• Deep understanding of data standardization techniques and best practices.
• Experience with performance tuning and optimization of databases and queries.
• Strong problemsolving skills and attention to detail.
• Excellent communication skills with the ability to work effectively with crossfunctional teams.
• Experience with Google clouddata platform.

Preferred Experience

• Meditech NPR
• Expanse