We are seeking a highly skilled Ab Initio Developer with 5+ years of experience in designing, developing, and optimizing ETL workflows using Ab Initio software, including Graphical Development Environment (GDE) and Enterprise Metadata Environment (EME).
The ideal candidate will have expertise in API integrations, message queues, database management, and scripting.
Key Responsibilities:
- ETL Development: Design and develop ETL processes using Ab Initio GDE & EME.
- API Integration: Implement Kafka and Webservices endpoints, facilitating data exchange via message queues.
- Data Processing: Read and create JSON/XML files as input/output, and work with Multifile System (MFS) for efficient data handling.
- Database Management: Work with Oracle, MongoDB, Teradata using tools like Toad, MongoDB Compass, Teradata SQL Assistant.
- Job Scheduling: Configure and maintain job schedulers such as Autosys, Control Center, and Control-M.
- Version Control: Utilize GitHub and Ab Initio EME for version control and repository management.
- Scripting & OS Management: Develop scripts using Shell scripting, Perl, SQL, and PL/SQL in UNIX, Linux, and Windows environments.
- Agile Methodology: Collaborate with cross-functional teams in an Agile development environment to enhance ETL processes.
Required Qualifications:
- 5+ years of experience in Ab Initio GDE & EME development.
- Strong experience in API integration (Kafka, Webservices) and message queues.
- Expertise in JSON/XML processing and MFS for data processing.
- Proficiency in Oracle, MongoDB, and Teradata databases.
- Hands-on experience with job schedulers (Autosys, Control Center, Control-M).
- Strong knowledge of GitHub, Shell Scripting, SQL, PL/SQL, Perl, and UNIX commands.
Preferred Qualifications:
- Familiarity with Agile methodologies.
- Domain knowledge in Banking, Digital Channel Technologies (Email, Secure Messaging, SMS, Push Notifications), Credit Cards, Healthcare, and Life Sciences