Ab Initio Developer

Job Title: Ab Initio Developer
Location: Coral Springs, FL / Atlanta, GA / Omaha, NE- Day 1 Onsite
Duration: Long-Term Contract

Responsibilities

• Design, develop, test, and maintain Ab Initio ETL applications and data pipelines.
• Develop complex Ab Initio graphs, plans, and reusable components.
• Build and maintain ETL processes for extracting, transforming, and loading large volumes of data.
• Work with business and technical teams to understand data requirements and translate them into technical solutions.
• Develop data transformations, validations, aggregations, joins, lookups, and other ETL processes.
• Troubleshoot and resolve ETL failures and production issues.
• Perform performance tuning and optimization of Ab Initio graphs and workflows.
• Develop and maintain DMLs, PSETs, Plans, and Parameter Files.
• Work with Unix/Linux shell scripting for automation and job execution.
• Write complex SQL queries and work with relational databases.
• Monitor batch jobs and resolve data processing issues.
• Perform unit testing, integration testing, and data validation.
• Participate in code reviews and follow development standards.
• Support production deployments and provide technical support.
• Create and maintain technical documentation.
• Work in an Agile/Scrum development environment.

Required Skills

• 5+ years of experience in Ab Initio development.
• Strong hands-on experience with Ab Initio ETL.
• Strong knowledge of:
  • Ab Initio Graphs
  • DML
  • PSETs
  • Plans
  • Components
  • Metadata management
  • Scheduling and batch processing
• Strong Unix/Linux experience.
• Good knowledge of Shell scripting.
• Strong SQL skills.
• Experience with relational databases such as Oracle, SQL Server, or DB2.
• Strong understanding of ETL concepts and Data Warehousing.
• Experience with large-volume data processing.
• Strong debugging and performance-tuning skills.

Experience with production support and issue resolution