Ab Initio Engineer

Ab Initio Engineer

Charlotte, NC

We are seeking an experienced Ab Initio Engineer to design, develop, and support enterprise-scale data integration solutions. The ideal candidate will have strong expertise in Ab Initio ETL development, data warehousing, and SQL, with experience working in complex data environments. Banking or Financial Services domain experience is highly preferred.

Responsibilities:

Design, develop, enhance, and maintain ETL workflows using Ab Initio.

Develop and optimize complex ETL processes for large-volume data loads.

Perform data analysis, data mapping, profiling, transformation, and validation activities.

Create and maintain source-to-target mapping documents and technical specifications.

Troubleshoot performance issues and optimize ETL jobs for efficiency and scalability.

Collaborate with business analysts, data architects, and application teams to gather requirements and deliver solutions.

Support data warehouse and reporting initiatives across multiple business functions.

Participate in code reviews, testing, deployment, and production support activities.

Ensure adherence to data governance, security, and compliance standards.

Requirements:

Strong experience with Ab Initio ETL Development.

Advanced SQL skills with experience in Oracle, SQL Server, Teradata, Snowflake, or PostgreSQL.

Strong understanding of data warehousing concepts, ETL architecture, and data modeling.

Experience in data migration, data quality, and reconciliation processes.

Strong knowledge of Unix/Linux scripting.

Experience with job scheduling and workflow orchestration tools.

Familiarity with version control systems and SDLC methodologies.

Experience working in Agile development environments.

Preferred:

Banking, Financial Services, or Capital Markets experience.

Experience with cloud data platforms such as AWS, Azure, or Snowflake.

Knowledge of data governance and regulatory reporting requirements.

Exposure to Python or automation scripting is a plus.

Strong analytical, problem-solving, and communication skills.