Ab-Initio Developer

Job Description:

The successful candidate will provide support in requirements/design/coding/testing/validation efforts for systems that support the Office of Applications and Supplemental Security Income Systems. The candidate will be performing these activities and maintain applications for the Social Security Administration under the direction of the Technical Lead and Project Management.

Skills Requirements

The responsibilities of this position include:

• Administration of the Ab Initio co>operating system, Enterprise Metadata Environment, and Data Profiling Tool on UNIX Sun Solaris servers.


• Administration of Ab Initio project directories and standard environment directories on UNIX Sun Solaris servers.


• Development of Ab Initio graphs.


• Deployment of Ab Initio graphs on UNIX Sun Solaris servers.


• Maintenance on UNIX shell scripting for moving Ab Initio code from one UNIX environment to another and purging data over 30 days old from the UNIX Sun Solaris servers.


• Maintenance of UNIX shell scripting for creating project directories on the UNIX System Services side of Mainframe.


• Guidance for best practices with regard to development of Ab Initio graphs.


• Peer Reviews for development of Ab Initio graphs.


• Guidance for best practices with regard to Data warehouse design using ORACLE for Ab Initio applications.


• Guidance for best practices with regard to Operational Data Stores using DB2 for Ab Initio applications.

Qualification:

• Minimum of 5 years of Ab Initio experience with the GDE, Metadata Repository, and Data Profiling Tool


• Six or more years of experience developing Ab Initio software in an enterprise environment


• Experience in defining Ab Initio best practices


• Should be able to understand the current design, review the code and suggest best design in Ab Initio


• Experience in SUN Solaris processing environment


• Expertise in UNIX and shell scripting


• 2-3 years of successfully demonstrated work experience using Oracle, SQL, and SQL*Loader


• Experience in UNIX Systems Services on mainframe


• Experience in Database Design


• Strong knowledge and use of BI/DW development methodologies, standards, and procedures


• Strong communication skills both written and verbal