Ab Initio Developer

E-Solutions

Jacksonville, FL, United States

7 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Clean Code Principles Amazon Web Services Unit Testing Microsoft Azure Big Data Data Validation Data Integration Extract Transform Load (ETL) Data Mapping Data Transformation Data Mining Data Warehousing

+24 more

Relational Databases Database Queries Software Debugging Apache Hadoop PostgreSQL Microsoft SQL Server Oracle (Applications) Performance Tuning Shell Script Software Deployment SQL Databases Data Processing Freeform SQL Google Cloud Rollup Apache Spark Analytic Functions Ab Initio Git Integration Tests Software Coding Software Version Control Jenkins Control M

Job description

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., * 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.

Requirements

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 Google Cloud Platform 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. Ab Initio Developer with SQL-Onsite at Jacksonville,FL1SQL,etl,Ab Initio DeveloperN/AC2CUnited States