Ab Initio Developer

A-Line Staffing Solutions; Jacksonville (FL); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading staffing solutions company in Jacksonville is seeking an experienced Ab Initio Developer to design and maintain ETL workflows for data integration and quality initiatives. This role requires strong hands-on skills in Ab Initio, complex SQL, and UNIX scripting, along with a solid grasp of data governance. Candidates will work on moderately complex project developments, ensuring data quality standards and supporting key data initiatives. A collaborative approach is essential for interaction with various IT and business stakeholders.

Qualifications

• Strong hands-on experience with Ab Initio required.
• Proficiency in complex SQL development and stored procedures.
• Experience with UNIX shell scripting.

Responsibilities

• Design and develop Ab Initio ETL workflows for data integration.
• Implement data quality rules and standards across data sources.
• Support application transitions during the Product Development Life Cycle.

Skills

Ab Initio

Complex SQL

UNIX scripting

Data governance

Data quality standards

Data profiling

Tools

Netezza

SQL Server

Linux (RHEL)

Job description

Ab Initio Developer / Data Quality Engineer

Position Overview

We are seeking an experienced Ab Initio Developer to support enterprise data integration and data quality/governance initiatives. This role is responsible for designing, developing, and maintaining ETL workflows, profiling large datasets, enforcing data quality standards, and ensuring data is fit for analytical and operational consumption.

The ideal candidate has strong hands-on experience with Ab Initio, complex SQL, and UNIX scripting, along with a solid understanding of data governance, testing methodologies, and enterprise data environments. This role supports moderately complex development projects and requires close collaboration with IT and business stakeholders.

Key Responsibilities

Data Integration & Quality

• Design and develop Ab Initio ETL workflows to support data ingestion, transformation, and integration.
• Create data profiles, write scripts, and implement workflows to support enterprise data quality programs.
• Perform data analysis to identify and remediate data quality issues across relational and non-relational data sources.
• Develop and contribute to data quality rules and standards across key data quality dimensions.

Development & Coding

• Write code for moderately complex system designs, including cross-platform integrations.
• Enhance existing programs and develop new ETL components as required.
• Review peer code and contribute to programming standards and best practices.
• Write detailed technical specifications and identify subsystem integration points.

Testing, Deployment & Support

• Perform unit testing, debugging, and validation based on code specifications.
• Support application transitions throughout the Product Development Life Cycle, including documentation for migrations.
• Research vendor products and conduct gap analysis to support technology decisions.
• Work closely with Developers, Business Analysts, Systems Analysts, Project Managers, and vendors.
• Identify gaps in system and functional requirements and communicate impacts clearly.
• Ensure adherence to IT controls and corporate security practices to protect data confidentiality, integrity, and availability.

Required Qualifications

Technical Skills

• Strong, hands-on experience with Ab Initio (required).
• Advanced SQL development, including complex queries and stored procedures.
• Experience with UNIX shell scripting (existing and new scripts).
• Experience with at least one major RDBMS: Netezza or SQL Server (both preferred).
• Experience working with large-volume datasets and enterprise databases.
• Familiarity with data quality processes and data governance frameworks.

Additional Technical Experience

• Experience with testing methodologies for ETL and data applications.
• Exposure to NoSQL databases, messaging engines, or cloud platforms (preferred).
• Experience with Linux environments (RHEL preferred).