AB Initio Developer

Interaction24,LLC; Wilmington (DE); On-site; USD 90,000 - 140,000; Full time

Job summary

A tech consultancy in Wilmington, Delaware, is seeking a skilled professional experienced in designing and delivering complex data warehouse applications. The role requires proficiency in Ab Initio ETL development, advanced SQL programming, and a solid understanding of the Software Development Lifecycle. Strong analytical skills and effective communication are essential. Ideal candidates will possess experience within the mortgage industry and have familiarity with job scheduling tools like Maestro/TWS.

Qualifications

• Experience designing and delivering large-volume data warehouse applications.
• 5+ years Ab Initio ETL development.
• Strong SQL and Oracle database experience.
• Experience in data quality, source-to-target mapping, and performance tuning.
• Excellent verbal and written communication.

Skills

Data warehouse applications design

Ab Initio ETL development

Advanced SQL programming

Oracle databases

Data modeling

Unix scripting

Software Development Lifecycle (SDLC)

Job scheduling (Maestro/TWS)

Data Quality

Source Systems Analysis

Performance Tuning

High Volume Data Loads

Communication skills

Analytical skills

Mortgage industry knowledge

Tools

Ab Initio

Maestro

TWS

Oracle databases

Job description

Technical/Functional Skills

• Experience designing and delivering complex, large-volume data warehouse applications
• Ab Initio ETL development (5+ years of hard-core Ab Initio experience)
• Strong experience in advanced SQL programming, Oracle databases
• Minimum data modeling experience
• Solid and professional communications skills, both verbal and written
• Unix familiarity and shell scripting experience
• Strong knowledge of Software Development Lifecycle (SDLC).
• Job scheduling experience using Maestro/ TWS is required
• Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High Volume Data Loads.
• Strong written and oral communication skills are essential.
• Strong analytical skills and ability to resolve problems are desired.
• Some knowledge of mortgage industry required.
• Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment
• Flexibility to work additional hours on an as needed basis to meet deadlines and with offshore team.
• Develop relevant functional and technical documentation