Sr ETL Validator Job at Omm IT Solutions, Woodlawn, MD

RWd1RWovZlhwdmZsbk96UGFlMmhCUmNRbEE9PQ==
  • Omm IT Solutions
  • Woodlawn, MD

Job Description

Please Note:

  • Selected candidate must reside within two (2) hours of the clients Headquarters in Woodlawn MD
  • Selected candidate must be willing to work onsite at least 2 days a week.

Position Description:

  • ETL Process Validation.
  • 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.

Key Required Skills:

Strong experience in writing ETL specs and validating ETL processes with expertise in SQL PL/SQL Oracle BI/MI.

Requirements

Basic Qualifications:

  • Bachelors degree with 7 years of experience.
  • Bachelors degree in computer science Mathematics Engineering or a related field and 8 years of experience in a trainingrelated field
  • Masters or Doctorate degree may substitute for required experience.
  • Must be able to obtain and maintain a Public Trust. Contract requirement.

Required Skills:

  • Expertise writing ETL Specs
  • Experience validating ETL processes.
  • Strong experience with SQL mapping and integration of databases such as DB2 Oracle 19c and PostgreSQL is a plus.
  • 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.

Desired Skills:

  • Development background in programming language like Java with strong SQL is preferred.
  • 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 clientserver and mainframebased systems and the connectivity/infrastructure requirements to support design develop and implement such systems.
Basic Qualifications: Bachelor\'s degree with 7+ years of experience. Bachelor\'s degree in computer science, Mathematics, Engineering or a related field and 8+ years of experience in a training-related field Masters or Doctorate degree may substitute for required experience. Must be able to obtain and maintain a Public Trust. Contract requirement. Required Skills: Expertise writing ETL Specs Experience validating ETL processes. Strong experience with SQL, mapping, and integration of databases such as DB2, Oracle 19c, and PostgreSQL is a plus. 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. Desired Skills: Development background in programming language like Java with strong SQL is preferred. 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. Benefits: Holiday Benefit: 10 Holidays per year Vacation Benefit: 10 Vacation Days per year. Accrued on weekly basis. Sick Leave Benefit: 5 Personal/Sick Leaves per year. Accrued on weekly basis Medical Insurance Reimbursement Benefit: Medical Insurance Allowance QSEHRA Reimbursement (Eligibility date dependent on enrollment.Employee purchase own plan) AFLAC Supplemental Insurance Plan: AFLAC Supplemental Insurance Plan 401 (K) Retirement Plan: 401 (K) Retirement Savings Plan Salary Range= $124000 - $129000 with Benefits

Job Tags

Holiday work, Contract work, 2 days per week,

Similar Jobs

EPAM Systems, Inc.

Fraud & Brand Protection Analyst Job at EPAM Systems, Inc.

Fraud & Brand Protection Analyst Description We are seeking a dedicated Fraud & Brand Protection Analyst to join our team, taking a pivotal role in safeguarding our clients' brands from fraudulent activities and brand impersonation threats. In this position, you... 

Rollins College

Director of Admission | Rollins College Job at Rollins College

 ...graduate enrollment professional to bring a personalized, concierge level of service to the Director of Admission position. The Director of...  ...-time programs. The School's Master of Business Administration (MBA) programs were designed for executives and working professionals,... 

Valley Medical Group

Primary Care Physician - Extremely Light Call - Western Massachusetts Job at Valley Medical Group

Valley Medical Group, an independent, primary care based multi-specialty group and training...  ...board certified or eligible family medicine physicians in our offices in Amherst, Easthampton...  ...therapy, behavioral health, eye care, sports medicine, rheumatology, endocrinology,... 

Healing Hands Diagnostic LLC

Mobile Phlebotomist Job at Healing Hands Diagnostic LLC

 ...Job Title: PRN Bilingual Mobile Phlebotomist, Drug Screen Collector, & Diagnostic Tester Company: Healing Hands Diagnostic Lab (HHDL) Location: Tucker, GA (Travel Required) Job Type: PRN / Part time (As Needed Basis, Contract Position)- Morning Shift About... 

Grand Circle Cruise Line

Kitchen Steward for European Passenger River Ships Job at Grand Circle Cruise Line

Description: Responsible for delivering an exceptional sanitation service for our travelers in accordance with Grand Circle Cruise Line (GCCL) standards, while contributing to a positive work environment. Responsibilities: Practicing GCCL values; Responsible...