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

Biom

Creative Director Job at Biom

 ...up, youre in the right place. Who You Are: Youre a creative leader who thrives on both vision and execution. Youve been the...  ...presentation for both visual impact and operational feasibility. Art Direction & Content Creation Own the concepting and... 

Yexgo

Data Entry - Typist Part-Time - Work Online - Remote Job at Yexgo

 ...Job Description Working in the Data Entry field is a great way to supplement your income. Looking for both full-time, and part-time employees to work from home. Qualifications Must be able type with accuracy. Computer Skills including internet,... 

Great Bay Staffing Group

Interventional Radiographer Job at Great Bay Staffing Group

Vascular Interventional Radiology Technologist (VIR Tech) - Tampa Bay Area Join one of Florida's premier healthcare facilities as a Vascular Interventional Radiology Technologist, where you'll be at the forefront of advanced medical imaging. This role offers an exceptional...

University of California, Irvine

Senior Patient Escort-Patient Care Equipment Pool-F/T, Night Shift Job at University of California, Irvine

 ...Equipment Pool Assistant is responsible to receive requests for patient care equipment and supplies and to deliver them to and from...  ...calculators Minimum 6 months of demonstrated experience as a Patient Escort or an Equipment Pool Assistant, in a patient care/hospital... 

Global Channel Management, Inc.

Warehouse Packer Operator Job at Global Channel Management, Inc.

Warehouse Packer Operator needs 2+ years' experience Warehouse Packer Operator requires: Monday - Friday 6:30 AM - 3:15 PM for training...  ...- 8:00 PM, and Sunday 5:30 AM - 2:00 PM. Warehouse Pick, pack Ship Material Upload Receipt or order OSHA, FDA,...