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

PrePass, LLC

Senior Quality Assurance Engineer Job at PrePass, LLC

 ...and the optimism to shape the future of transportation. Position Summary PrePass is seeking a highly skilled Senior Quality Assurance Engineer to ensure the quality and reliability of our software applications. In this role, you will be an expert in testing... 

Humboldt County

Screener Job at Humboldt County

 ...Under limited supervision, the Screener assists applicants for public assistance programs; explains policies and procedures; gathers and verifies facts and information; initiates cases through an automated system; makes appropriate referrals for health, social and/or... 

LaSalle Network

Senior Financial Analyst Job at LaSalle Network

 ...guidelines, company policies and relevant legal regulations Senior Financial Analyst Requirements: ~ Bachelor's degree in finance, accounting or a related field ~2+ years of experience in financial planning, analysis and modeling ~ Ability to present financial... 

Morgan Stephens

Case Manager - Telephonic Hospice Validations (Remote) Job at Morgan Stephens

 ...Job Title: Remote Hospice Telephonic Case Manager (Temp-to-Perm) Pay Rate: Up to $45/hr Schedule: Monday Friday, 8:00 AM 5:00 PM PST...  ...Care Organization is seeking experienced Registered Nurses to serve as telephonic case managers for hospice validation... 

City of Fayetteville

Part-Time Park Attendant Job at City of Fayetteville

 ...description.Job SummaryMaintains watch over public property in parks, bath houses, retention areas or facilities; does related work...  ...about Recreational Amenities and programs. Collects attendance information. Ensures a clean and neat appearance of the Park at...