SQL & Ab Initio ETL Specialist — Data Pipelines

E-Solutions INC; Jacksonville (FL); On-site; USD 90,000 - 150,000; Full time

Job summary

Unknown in Florida is seeking an SQL Expert with Ab Initio ETL expertise to join onsite. The role focuses on developing complex SQL queries and ETL processes, translating business requirements into robust database solutions, and optimizing performance.

You will support Ab Initio ETL jobs, graphs, workflows, and data pipelines, while monitoring batch processing and ensuring data integrity through validation and troubleshooting.

Qualifications

• Strong SQL skills including complex queries, procedures, functions, views and triggers.
• Translate business requirements into efficient database solutions.
• Experience with SQL tuning and performance optimization.
• Proficient in designing and supporting ETL processes and data pipelines.

Responsibilities

• Develop and maintain complex SQL queries, stored procedures, functions, views, and triggers.
• Convert business requirements into efficient database solutions.
• Perform SQL query tuning, indexing, and database performance optimization.
• Develop and support ETL processes, including data extraction, transformation, and loading.
• Perform data validation, reconciliation, troubleshooting, and issue resolution.
• Support Ab Initio ETL jobs, graphs, workflows, and data pipelines.
• Monitor and troubleshoot Ab Initio batch/data processing issues.
• Participate in ETL design, testing, deployments, and performance tuning.
• Collaborate with Business Analysts, Application Teams, and Data Engineers.
• Support production deployments and application maintenance.
• Maintain technical documentation for database and ETL processes.

Skills

SQL Expertise

Stored Procedures & Functions

ETL Development

Query Tuning

Data Validation

Tools

Ab Initio

ETL Workflows

Job description

Unknown in Florida is seeking an SQL Expert with Ab Initio ETL expertise to join onsite. The role focuses on developing complex SQL queries and ETL processes, translating business requirements into robust database solutions, and optimizing performance.

You will support Ab Initio ETL jobs, graphs, workflows, and data pipelines, while monitoring batch processing and ensuring data integrity through validation and troubleshooting.