Ab Initio Developer

Key Required Skills:

• GDE, Co>Op, PSETS, PDL Programming, Meta Programming, Generic Graphs and usage of Conduct>IT (Plans).

Position Description:

• Coordinate with Leads and develop Advanced Ab Initio graphs and Ab Initio Plans, write complex Linux wrapper scripts and be productive on the work deliverables.
• Execute the SQL queries against Greenplum database, monitor daily loads and write the advanced queries to get summarized data.
• Support all the production loads, debug the failures and provide the resolutions.

Skills Requirements:

FOUNDATION FOR SUCCESS (Basic Qualifications)

• Bachelor's degree in computer science, Information Technology, Management Information Systems, or a related field.
• Master's or Doctorate degree may substitute for required experience.
• 5 + years of experience working with strong data-warehouse and ETL - Ab Initio tool background.
• Experience working with relational database like Oracle, DB2 and PostgreSQL.
• Experience working with UNIX/ Linux bash scripting.
• Experience working in a fast-paced development environment with drive to completion.
• Experience using Amazon Web Services (AWS).
• Well versed with using version control systems (EME and Git).
• Analytical and problem-solving skills.
• Must be able to obtain and maintain a Public Trust. Contract requirement.

FACTORS TO HELP YOU SHINE (Required Skills)

These skills will help you succeed in this position:

• Strong hands-on experience in data-warehouse and ETL - Ab Initio tool background.
• Excellent working knowledge of Ab Initio suites of product - GDE, Co>Op, PSETS, PDL Programming, Meta Programming, Generic Graphs and usage of Conduct>IT (Plans).
• Good experience in various Ab-initio parallelism techniques and implement overall solutions comprising of ETL jobs involving heavy volumes of data.
• Knowledge on EME version control, Ab Initio air commands, m_ commands and UNIX/Linux shell scripting.
• Experience working with various Ab Initio components such as Rollup, Scan, Join, Partition by key, Normalize, Gather, Merge, Sort, Lookup, etc.
• Proficient and comfortable with Ab Initio metaprogramming using vectors and implementing tuning techniques for performance improvement.
• Strong knowledge of any database such Oracle, DB2 or Greenplum is a must.
• Flexible to support on-going BAU production jobs and release activities.
• Must have knowledge on data warehousing concepts, data modeling and expert level Database/SQL skills.
• Proficient in creating documentation related to design documents, Unit testing, handover and walk-through documents.
• Analyze (though proof of concept, performance, and end-to-end testing) and effectively coordinate the infrastructure/service needs working with the architecture and Data Center teams.
• Closely work with the architecture team to review the design and ETL code.
• Identify and apply best practices and standard operating procedures.
• Create innovative solutions to meet the technical needs of customers.
• Experience with Agile development practices.
• Excellent communication and written skills.

HOW TO STAND OUT FROM THE CROWD (Desired Skills)

Showcase your knowledge of modern development through the following experience or skills:

• Working experience in AWS and knowledge of Cloud environment.
• Business Intelligence MIBI Reporting tools like Tableau and WebFOCUS.
• Experience with Telephony or high volumes of transactional data.
• Work closely with customer technical leads and other Leidos team members.
• All other duties as assigned or directed.

Education:

• Bachelor's degree in computer science, Information Technology, Management Information Systems, or a related field with 3+ years of experience
• Must be able to obtain and maintain a Public Trust. Contract requirement.