Hi Professionals,
Position: Ab Initio Developer with SQL-Onsite at Jacksonville,FL
Location: Jacksonville,FL(Onsite)
JD:

We 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.
Experience

3 8+ years of experience in Ab Initio development, ETL, and SQL, with strong hands-on experience in enterprise data integration projects.

Similar jobs

Ab Initio Developer with SQL-Onsite at Jacksonville,FL

Apply Now
Back to search page