SQL Data Integration Engineer OpenGate ETL
SQL Data Integration Engineer OpenGate ETL
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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
Employment Type
Full Time
