Be an early applicantLess than 25 applicants

Company

KOAR Cloud Solutions · 6 hours ago

ETL Validator with Security Clearance

Woodlawn, MD

Full-time

Remote

Senior Level, Lead/Staff

8+ years exp

Maximize your interview chances

IT Services and IT Consulting

No H1B

Security Clearance Required

Insider Connection @KOAR Cloud Solutions

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Writing ETL Specs

Mentor and coach technical staff, proactively shape product vision, and support multiple internal/external initiatives to achieve mission success.

Involved with MI reports testing in Agile environment.

All other duties as assigned or directed.

Test different modules of MI reporting.

Attend all Agile ceremonies like Daily standup, Sprint planning, Backlog grooming and Sprint Retrospective meetings.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

ETL Specs WritingETL Process ValidationSQLPL/SQLOraclePostgreSQLLinux ScriptingData ExtractionTest Strategies DevelopmentBI/MI ReportingDB2JavaUNIX CommandsClient-Server Systems KnowledgeMainframe Systems Knowledge

Required

Bachelor's degree in computer science, Mathematics, Engineering or a related field and 8+ years of experience in a training-related field

Must be able to obtain and maintain a Public Trust

Expertise writing ETL Specs

Experience validating ETL processes

Strong experience with SQL, mapping, and integration of databases such as DB2, Oracle 19c, and PostgreSQL

Strong experience in testing Extract, Transform, and Load (ETL) applications

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

Experience designing and developing test strategies based on Business Requirement document

Strong communication and collaborative skills

Preferred

Development background in programming language like Java with strong SQL

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