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

Massachusetts Institute of Technology (MIT)

Administrative Assistant 2 | Massachusetts Institute of Technology (MIT) Job at Massachusetts Institute of Technology (MIT)

 ...Posting Description ADMINISTRATIVE ASSISTANT 2 , The Deshpande Center for Technological Innovation (DCTI), to provide administrative support for the Deshpande project teams, scheduling meetings, data entry, handling general financial duties, coordinating event logistics... 

Two95 International Inc.

Senior Cyber Security Engineer Job at Two95 International Inc.

 ...Title: Senior Cyber Security Engineer Location: Tampa, FL (Hybrid) Duration: Full Time Salary: $Open / Market Requirements Required Experience: Bachelors Degree or equivalent experience required; advanced degrees or certifications preferred... 

Advanced Bio-Logic Solutions Corp

Global Mobility Mgr Job at Advanced Bio-Logic Solutions Corp

Description: Note: Role and Responsibilities: Provide strong vendor management to deliver premium employee experience. This includes ensuring overall compliance in filing immigration petitions while partnering on strategic initiatives. Provide in-depth counsel...

SDS Rx

Pharmaceutical Delivery Driver (Kansas City, MO - PEM) SDS-Rx Job at SDS Rx

 ...with Purpose - important medical deliveries to people in need Drive packages, not people - never worry about who's getting in your car Become an SDS Pharmaceutical Delivery Driver If you have a spotless driving record, a dependable vehicle and the drive to come... 

Get It Recruit - Information Technology

RPA Developer - Remote | WFH Job at Get It Recruit - Information Technology

We are excited to offer a fantastic opportunity for an RPA Developer in the legal industry, based in New York, New York. This role primarily supports remote work and involves collaborating with various teams, including finance, billing, and accounts payable. We are looking...