Ab Initio Developer with SQL-Onsite at Jacksonville,FL
esolutionsJacksonville (FL)
Ab Initio Developer with SQL-Onsite at Jacksonville,FL
Posted 7 days ago
esolutionsJacksonville (FL)
SENIORITY
Senior
About the role
Ab Initio Developer with SQLWe are looking for an experienced Ab Initio Developer with strong SQL skills to design, develop, and maintain ETL/data integration solutions. The ideal candidate will have hands-on experience with Ab Initio components, data processing, data warehousing, and complex SQL queries.
Key Responsibilities:
Design, develop, test, and maintain ETL workflows using Ab Initio.
Develop and optimize Ab Initio graphs using components such as Rollup, Scan, Join, Reformat, Sort, Partition, Lookup, and Normalize.
Write complex and optimized SQL queries for data extraction, transformation, validation, and reconciliation.
Work with relational databases such as Oracle, SQL Server, or PostgreSQL.Develop data integration and data transformation processes for large-volume datasets.
Perform data mapping, data validation, reconciliation, and troubleshooting.
Analyze performance issues and optimize Ab Initio graphs and SQL queries.
Work with business analysts and data teams to understand requirements and translate them into technical solutions.
Participate in unit testing, integration testing, production deployment, and post-production support.
Troubleshoot ETL failures, data quality issues, and production incidents.
Maintain technical documentation for ETL processes and workflows.
Follow coding standards, version control, and development best practices.
Required Skills:
Strong hands-on experience with Ab Initio development.
Strong knowledge of Ab Initio Co>Operating System and GDE.Good understanding of ETL concepts and data warehousing.
Strong SQL skills, including complex joins, subqueries, CTEs, analytical functions, and performance tuning.
Experience working with Oracle / SQL Server / PostgreSQL or similar relational databases.
Good understanding of data modeling, data transformation, and data quality.
Experience with Unix/Linux commands and shell scripting.
Strong debugging and problem-solving skills.
Experience working in Agile/Scrum environments.
Preferred Skills:
Experience with Ab Initio Control Center (EME).Knowledge of Unix/Linux shell scripting.
Experience with scheduling tools such as Control-M.Knowledge of Git, Jenkins, or other CI/CD tools.
Experience with cloud platforms such as AWS, Azure, or GCP is a plus.
Exposure to Big Data technologies such as Hadoop/Spark is a plus.
Experience3–8+ years of experience in Ab Initio development, ETL, and SQL, with strong hands-on experience in enterprise data integration projects.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.