Ab Initio Developer

Overview

This position focuses on software development and data engineering with an emphasis on ETL processes and Ab Initio technologies. The role involves designing, developing, testing, optimizing, and supporting complex data pipelines and transformation workflows across heterogeneous data environments. The candidate will contribute to building scalable and efficient ETL solutions while ensuring data quality, performance optimization, and production stability. Responsibilities include working extensively with Ab Initio GDE, Co>

Operating System, Enterprise Meta>

Environment (EME), relational databases, SQL development, and Unix/Linux scripting. The role also requires close alignment with SDLC and Agile methodologies, troubleshooting production issues, maintaining technical documentation, and supporting governance requirements. Candidates with exposure to cloud data platforms, Hadoop ecosystems, and financial services data environments will be considered advantageous.

• Design, develop, and test complex Ab Initio graphs using the Graphical Development Environment (GDE) to extract, transform, and load data from heterogeneous sources.
• Implement data quality checks, data cleansing, and complex transformation logic within the Ab Initio pipelines.
• Monitor graph performance, identify bottlenecks, and optimize Ab Initio components for maximum efficiency and parallel processing.
• Write Unix/Linux shell scripts for job automation, file manipulation, and scheduling integration (e.g., using Autosys or Control-M).
• Write and optimize SQL queries for relational databases (e.g., Oracle, Snowflake, PostgreSQL) to support data extraction and loading processes.
• Assist in troubleshooting and resolving data discrepancies, pipeline failures, and performance issues in UAT and production environments.
• Maintain technical documentation mapping data lineage, transformation logic, and architectural designs in compliance with data governance standards.

• 3-6 years of hands‑on software development and data engineering experience, with a heavy focus on ETL.
• Experience building data pipelines using Ab Initio GDE, Co>
  
  Operating System, and Enterprise Meta>
  
  Environment (EME).
• Strong proficiency in standard SQL and understanding of relational database concepts.
• Solid command‑line skills and experience writing shell scripts on Unix/Linux.
• Understanding of the Software Development Life Cycle (SDLC) and Agile methodologies.
• Strong problem‑solving abilities with a keen attention to detail and data accuracy.

• Experience with Ab Initio Continuous Flows, Express>
  
  It, or Control Center.
• Familiarity with the Hadoop ecosystem or cloud data platforms (AWS, Snowflake).
• Prior experience in the banking or financial services industry, particularly dealing with regulatory data or risk modeling.

Only those lawfully authorized to work in the designated country associated with the position will be considered. Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law.

Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

Rose International has an official agreement (), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E‑Verify). (Posting required by OCGA 13/10‑91.).