Ab Initio / PL-SQL Developer

We are urgently looking for a *Ab Initio / PL-SQL Developer* with in-depth experience.

Work Mode: Onsite(5days a week)

Long-term project

Location: Woodlawn, MD

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

Job Responsibilities:

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

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.

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