Sr. ETL Developer / PEGA Bix Position

Job Title: Sr. ETL Developer / PEGA Bix Position
Location: Baltimore, MD
Duration: Long Term Contract
Client: Leidos
Visa Status: H1B, Green Card & US Citizens
Key Required Skills:
PEGA BIX tool, ETL, PL/SQL, DBE2, Oracle 19c, Greenplum, PostgreSQL, Linux, UNIX, BI/MI

Position Description:
·        Design, develop, and unit test software modules/functionality.
·        Peer review team members code for quality and standards.
·        Demonstrate completed functionality and assist testers with approaches to validate features and refine test cases.
·        Attend team meetings with team members to understand and refine business features. 
·        Attend regular customer meetings and provide status on assigned tasks.
·        Analyze and troubleshoot the existing Oracle 19c data models, PL/SQL and Linux scripts, and code for opportunities to optimize performance and migrate into the Enterprise Data Warehouse (EDW).
·        Monitor and troubleshoot daily production jobs and job failures.
·        Coordinate with various other teams to resolve production job failures.
·        Develop design documentation and guidelines.
·        Develop presentation material.
·        All other duties as assigned or directed

Skills Requirements:
Basic Qualifications:
·        Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field
·        Masters or Doctorate degree may substitute for required experience
·        8+ years of combined experience with PEGA BIX tool, ETL, and PL/SQL

Required Skills:
·        Strong experience in design, building and testing graphs and Extract, Transform, and Load (ETL) applications.
·        Strong experience with PEGA BIX tool.
·        Strong experience with SQL, mapping, and integration of databases such as DB2, Oracle 19c, and Greenplum.
·        Proficiency writing scripts using Oracle PL/SQL, PostgreSQL, and Linux.
·        Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files.
·        Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
·        Knowledge of when to use plain SQL vs. PL/SQL.
·        Working knowledge with analyzing and developing optimal code to maintain high performance for processing large volumes of data.

Desired Skills:
·        Proficiency with reading UNIX logs and executing basic UNIX commands to troubleshoot existing applications.
·        Hands on experience with data warehouse Business Intelligence (BI) / Management Information (MI) reporting environment. Knowledge in both client-server and mainframe-based systems and the connectivity/infrastructure requirements to support, design, develop and implement such systems.