Microtech Systems LLC Hiring for ETL Developer (Remote) at Remote Full Time

EAD/GC/Citizenship required. No H1B holders and no C2C. Strongly No Third Party Recruiters.
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.
Education:
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.

Job Type: Contract

Pay: $58.00 – $65.00 per hour

Schedule:

Ability to commute/relocate:

• Owings Mills, MD 21117: Reliably commute or planning to relocate before starting work (Preferred)

Education:

Experience:

• Oracle: 3 years (Required)
• SQL: 5 years (Required)
• ETL: 8 years (Required)

Work Location: Remote