Full Time Only: Ab Initio Developer

Visionary Innovative Technology Solutions LLC; Jersey City (NJ); On-site; USD 90,000 - 140,000; Full time

Job summary

Visionary Innovative Technology Solutions LLC in Jersey City, NJ seeks an experienced Ab Initio Developer to design, develop, and maintain ETL processes and data integration solutions.

You will work with complex SQL queries on Oracle/DB2/Teradata, optimize workflows, and collaborate with analysts, architects, and QA to ensure data quality and performance. 5+ years of hands-on Ab Initio experience preferred; banking experience and scheduling tools like Control-M are a plus.

Qualifications

• Experience with Ab Initio development and ETL processes.
• Strong SQL knowledge and database concepts.
• Experience in Unix/Linux shell scripting.
• Knowledge of data warehousing and data integration concepts.
• Experience with production support and performance tuning.

Responsibilities

• Develop and maintain ETL workflows using Ab Initio GDE and related tools.
• Design and implement data extraction, transformation, and loading processes.
• Work with complex SQL queries on Oracle, DB2, or Teradata.
• Perform data mapping, validation, debugging, and performance tuning.
• Troubleshoot production issues and optimize data workflows.
• Collaborate with business analysts, data architects, and QA teams.

Skills

Ab Initio

SQL

Unix/Linux shell scripting

Data warehousing concepts

Production support & debugging

Job description

We are looking for an experienced Ab Initio Developer responsible for designing, developing, and maintaining ETL processes and data integration solutions.

Key Responsibilities:

• Develop and maintain ETL workflows using Ab Initio GDE, Co>Operating System, and related tools.
• Design and implement data extraction, transformation, and loading processes.
• Work with complex SQL queries and relational databases such as Oracle, DB2, or Teradata.
• Perform data mapping, data validation, debugging, and performance tuning.
• Troubleshoot production issues and optimize existing data workflows.
• Collaborate with business analysts, data architects, and QA teams.

Required Skills:

• Strong hands-on experience with Ab Initio development and ETL processes.
• Proficiency in SQL and database concepts.
• Experience with Unix/Linux shell scripting.
• Knowledge of data warehousing and data integration concepts.
• Experience with production support, debugging, and performance optimization.

Preferred Qualifications:

• Experience in banking or financial services.
• Familiarity with Control-M or other scheduling tools.
• Experience with Agile methodologies and version control tools.

Experience: 5+ years preferred, depending on project requirements.