Ab Initio Administrator

TechDigital Group; Chicago (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology solutions provider is seeking an experienced Ab Initio Administrator to manage the ETL environment. Responsibilities include installation and configuration of software, performance monitoring, user access management, and collaboration with development teams. The ideal candidate has strong skills in Ab Initio products and ETL concepts, along with problem-solving capabilities. This role is crucial for ensuring efficient data processing within the organization.

Qualifications

• Strong knowledge and hands-on experience with Ab Initio products.
• Familiarity with Linux/Unix operating systems, including shell scripting.
• Understanding of ETL concepts and data warehousing principles.

Responsibilities

• Installing, configuring, and maintaining Ab Initio software.
• Monitoring ETL job performance and troubleshooting issues.
• Managing user access and implementing security protocols.

Skills

Ab Initio expertise

Shell scripting

ETL concepts

Database knowledge

Problem-solving

Tools

Ab Initio products

Linux/Unix

SQL

Job description

Overview

An Ab Initio Administrator manages and maintains the Ab Initio ETL environment, ensuring efficient and reliable data processing. This includes tasks like user access management, performance tuning, job scheduling, and troubleshooting. They also support development teams by optimizing workflows and maintaining data integrity within large-scale data processing systems.

Responsibilities

• Environment Management: Installing, configuring, and maintaining Ab Initio software and related components (Co-Operating System, EME, Control Center, etc.).
• Performance Monitoring: Monitoring ETL job performance, troubleshooting issues, and optimizing workflows to ensure efficient data processing.
• User Access and Security: Managing user access, implementing security protocols, and maintaining user accounts within the Ab Initio environment.
• Job Scheduling and Automation: Scheduling and automating ETL jobs using tools like Control Center or Autosys, and potentially developing automation scripts using languages like Python or Shell.
• Troubleshooting and Support: Resolving issues related to ETL jobs, Ab Initio components, and data processing workflows.
• Collaboration and Communication: Working with developers, data engineers, and other stakeholders to implement changes, upgrades, and resolve issues.
• Documentation: Creating and maintaining technical documentation related to Ab Initio solutions and configurations.

Skills and Qualifications

• Ab Initio Expertise: Strong knowledge and hands-on experience with Ab Initio products (Co-Operating System, EME, Control Center, etc.).
• Operating System Knowledge: Familiarity with Linux/Unix operating systems, including shell scripting (Bash, Korn shell).
• ETL and Data Warehousing: Understanding of ETL concepts, data warehousing principles, and experience with data profiling, cleansing, and transformation.
• Database Knowledge: Familiarity with databases (Oracle, Teradata, etc.) and SQL.
• Scripting and Automation: Experience with scripting languages (Python, Shell, etc.) for automation tasks.
• Communication and Collaboration: Excellent communication and interpersonal skills to collaborate with cross-functional teams.
• Problem-Solving: Strong analytical and problem-solving skills to troubleshoot and resolve complex issues.
• Cloud Computing (Optional): Experience with cloud platforms like AWS, Azure, or GCP, and containerization technologies like Docker and Kubernetes.