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

DSV - Global Transport and Logistics

HR Assistant Job at DSV - Global Transport and Logistics

 ...Read more at Location: USA - Dallas-Fort Worth Int Apt, Grapevine, Esters Blvd Division:Solutions Job Posting Title: HR Assistant Time Type: Full Time P & O Assistant, Sr Role title: P & O Coordinator, Sr Aligned with:People & Organization Business... 

LaSalle Network

Entry Level Accounting Opportunity! Job at LaSalle Network

 ...providing exceptional patient care and enhancing the overall healthcare experience. Our client is offering an exciting Entry-Level Accounting Opportunity for candidates eager to jumpstart their careers. They are open to fresh graduate profiles or candidates with 1-4... 

MRA Recruiting Services

CNC Machine Setup Operator Job at MRA Recruiting Services

 ...Nolte Precise Manufacturing, Inc. CNC Machine Setup Operator Cincinnati, OH Company Vision: To be an industry expert for supplying precision machined components and assemblies to OEMs in the U.S.A. Primary Job Duties: Maintain acceptable setup standards... 

Beth Israel Lahey Health

Manager, Patient Relations and Experience Job at Beth Israel Lahey Health

 ...When you join the growing BILH team, you're not just taking a job, you're making a difference in people's lives.**The Patient Experience (PEX) Manager for Beverly, Addison Gilbert and the Anna Jaques hospitals reports to the Executive Director of Quality and Patient... 

Sage Hospitality Group

Dir Sales & Marketing Job at Sage Hospitality Group

**Why us?**Sage Hotel Management is currently seekingan experiencedDirector of Sale and Marketing for TheAlexandrianand MorrisonHouseHotels,locatedin Alexandria, VA.At Sage Hotel Management, we passionately strive to be the best and create excellence in everything we...