What are the responsibilities and job description for the SQL Data Integration Engineer (OpenGate & ETL) position at Noblesoft Technologies?
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 data-related issues, including data inconsistencies, workflow failures, and performance bottlenecks.
Required Qualifications
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 data-related 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 problem-solving skills and attention to detail.
- Excellent communication skills, with the ability to work effectively with cross-functional teams.
- Experience with Google cloud-data platform.
- Meditech NPR
- Expanse
