Selected candidate must be willing to work on-site at least 2 days a week.

Selected candidate must reside within two (2) hours of SSA Headquarters in Woodlawn, MD

Skills Requirements:

FOUNDATION FOR SUCCESS

• 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

• 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

• 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.