Ab Initio Developer

AB Initio Developer – HYBRID (JACKSONVILLE, FL)

ARC Group has an immediate opportunity for an Ab Initio Developer! This is starting out as a 12 month contract position with potential to extend longer or possibly convert to FTE. The position is hybrid, with a couple of days per week onsite in Jacksonville, FL. This is a fantastic opportunity to join a dynamic and well-respected organization offering tremendous career growth potential.

Reference # 19407-1
Hybrid role in Jacksonville, FL

Ab Initio Developer – Onsite (JACKSONVILLE, FL)
Ideal Candidate Profile
A Senior Ab Initio Developer with:
Strong Ab Initio & ELT Conversion Expertise

NO H1B, EAD, GC EAD Please.

Job Description:

Must-Have Skills:

• Strong hands-on experience with Ab Initio (GDE, Co>Operating System, EME)
• Experience converting existing Ab Initio ETL processes to Stored Procedure–based ELT architecture
• Writing highly complex SQL queries (joins across large fact tables, window functions, performance tuning)
• Strong stored procedures development experience
• Experience with:
• IBM Netezza (Preferred)
• Microsoft SQL Server
• Oracle Database
• Handling large-scale batch processing (10TB+ datasets preferred)
• Experience working with very large, high-volume enterprise databases
• Indexing, partitioning, query performance optimization
• Strong Unix/Linux Shell Scripting experience

Core Skills:

• Developing and maintaining Ab Initio graphs for batch and continuous processing.
• Writing complex SQL queries for ELT/ETL pipelines in Netezza (preferred) or similar RDBMS (SQL Server, Oracle).
• Designing optimized data models (fact/dimension tables) for analytics.
• Handling high-volume batch jobs (e.g., nightly healthcare claims processing).
• Tools: Ab Initio, Netezza, SQL Server, SSIS, or similar ETL tools.
• Unix/Linux Scripting for Automation.
• Automating data pipelines (e.g., cron jobs, error handling, file transfers).
• Example: “Scripted automated batch ingestion for multi-terabyte healthcare datasets using Bash.”

Stored Procedure Development.
Building reusable, efficient stored procedures for data transformations and batch workflows.
Example: “Converted Ab Initio transformation logic into optimized stored procedures, reducing runtime by 30%.”

Data Quality & Governance.
Creating data profiles, writing scripts, and developing workflows to support the data quality program.
Performing data analysis to identify data quality issues for relational and non-relational data sources.

Healthcare Data Experience (Nice-to-Have)
Familiarity with healthcare datasets (claims, EHR, HL7) and compliance (HIPAA, PHI).
Understanding of healthcare analytics use cases (risk modeling, population health).

Interested?

Email your most updated resume to Suresh at [email protected], or apply online and explore other opportunities at www.arcgonline.com.

ARC Group is a Forbes-ranked top 20 recruiting and executive search firm, connecting top technical talent with clients nationwide. We pride ourselves on understanding both candidates’ and clients’ goals and serving both with integrity and excellence.

ARC Group is an equal opportunity workplace, committed to building a diverse workforce.