Backend Ab Initio / PL-SQL Developer

  • Woodlawn, MD
  • Posted 4 days ago | Updated 4 days ago

Overview

On Site
Depends on Experience
Full Time
No Travel Required

Skills

Ab Initio
Linux
SQL
PL/SQL
Oracle
Extract
Transform
Load
Scrum

Job Details

Key Required Skills:

Strong working knowledge of COBOL, JCL, Ab Initio, PL-SQL, Linux Scripting, and of DB2. PostgreSQL, and Oracle databases.

Position Description:

  • Analyze ETL jobs and the data feeds and make adjustments as needed.
  • Write SQL and PL-SQL to extract data from Oracle and Db2 databases, and upload into PostgreSQL databases using Ab Initio.
  • Maintain documentation for job processes and update as needed.
  • Coordinate with various other teams to resolve production job failures.
  • Monitor, troubleshoot, and resolve job failures.
  • Develop code to create new client-server jobs as part of application modernization effort.
  • Attend all customer technical discussions/design/development meetings and provide technical inputs to further enhance the code quality/process.
  • Impact functional strategy by developing new solutions, processes, standards, or operational plans that position Leidos competitively in the marketplace.
  • All other duties as assigned or directed.

(Basic Qualifications)

  • Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field.
  • Masters or Doctorate degree may substitute for required experience
  • 10+ years of experience with Web component development using modern JavaScript, CSS and CSS preprocessors such as SASS and LESS, ES 6+, and Stencil.js.
  • Must be able to obtain and maintain a Public Trust. Contract requirement.

*** Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week.

(Required Skills)

  • Understanding the db2 and Oracle data models and JCL Programs.
  • Proficient writing Ab Initio scripts to extract, transform, and load data.
  • Proficient in writing PL-SQL scripts.
  • Experience monitoring and troubleshooting daily production jobs and job failures.
  • Proficient in writing Linux scripts for ETL.
  • Excellent communication and written skills

(Desired Skills)

  • Experience with modern development software, tools, and methodologies.
  • Experience working on Agile projects and understanding Agile terminology.
  • Work in DevOps Environment.
  • Experience with Linux environments.
  • Participate in daily scrum and provide updates.

Education:

  • Bachelor's Degree with 10+ years of experience
  • Must be able to obtain and maintain a Public Trust. Contract requirement.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Global CI