Ab Initio Developer

Role Summary:

Ab Initio Developer

Key Responsibilities:

• Design, develop, and maintain ETL processes using

  Ab Initio

  tools for data extraction, transformation, and loading (ETL).
• Utilize

  Ab Initio GDE, Co>Operating System, Conduct>It

  , and

  EME

  to build scalable and efficient data workflows.
• Apply best practices for

  data warehousing

  and ETL architecture in handling large data sets.
• Perform

  unit testing, debugging

  , and

  troubleshooting

  of Ab Initio graphs to ensure reliability and data integrity.
• Collaborate with data architects, analysts, and business stakeholders to understand data needs and deliver solutions.
• Optimize ETL performance and support production deployments and issue resolutions.
• Write and tune

  SQL queries

  and use

  scripting languages

  (e.g., Unix shell) for data manipulation and analysis.
• Ensure documentation of workflows, processes, and technical designs for knowledge sharing and support.
• Participate in code reviews and quality assurance activities to maintain high coding standards.

Required Skills & Experience:

• 4+ years

  of hands-on experience in

  Ab Initio

  ETL development.
• Proficiency with core

  Ab Initio suite components

  :

• GDE (Graphical Development Environment)

• Co>Operating System

• Conduct>It

• EME (Enterprise Meta>Environment)

• Strong knowledge of

  ETL concepts

  ,

  data warehousing principles

  , and

  relational databases

  .
• Solid

  SQL

  skills and experience with

  scripting languages

  (e.g., Unix Shell, Python is a plus).
• Ability to design and implement

  efficient and scalable ETL solutions

  for large-scale data environments.
• Strong

  analytical and problem-solving

  capabilities.
• Excellent verbal and written

  communication skills

  ; ability to engage effectively with technical and non-technical stakeholders.
• Experience in

  unit testing

  and

  quality assurance

  for data pipelines.

Nice to Have:

• Familiarity with

  data lake

  or

  cloud-based ETL architectures

  (e.g., AWS, Azure).
• Exposure to

  job schedulers

  (e.g., TWS, Autosys).
• Understanding of

  metadata-driven frameworks

  and

  data lineage tracking

  .
• Prior experience working in

  Agile

  or

  Scrum

  -based development teams.