ETL Data Warehouse Engineer

19 May 2024

Vacancy expired!

About InnovaSystems International Inc.InnovaSystems is a leading provider of enterprise software and data solutions to the Department of Defense, federal, state, and local government agencies.With us, you’ll be part of a team that delivers a vital service to support our nation’s National Security Strategy by developing extraordinary solutions through innovative software!

Some of our perks & benefits include: Flexible hybrid schedule & telecommute options, continuous learning opportunities including technical training and Leadership development programs, comprehensive benefits package, onsite gym/workout facilities, 401k plan w/ company match, competitive salary and a fantastic culture of collaboration.

Job RoleAre you someone who can troubleshoot issues in an efficient and systematic manner to identify and resolve underlying causes? Do you consider yourself a

SQL guru? As

a ETL / Data Warehouse Test Engineer, you will be a core member of a team supporting a DoD readiness enterprise data project with over 50 data sources running daily for over 14,000 users. This individual will participate in

SQL-centric testing of

SSIS and

IBM DataStage ETLs for our enterprise data warehouse. This includes estimation, data quality checking, collaboration with team stakeholders, and the regular updating of work item status and hours.

Qualified candidates

MUST be a US Citizen with the

ability to obtain a secret, DoD security clearance.

Experience Required:
  • Proven record of delivering end to end enterprise solutions.
  • 4 years of experience as either a

    Data Warehouse/ETL developer or Data Warehouse/ETL Test Engineer
  • Strong SQL expertise a must (T-SQL preferred)
  • Experience in development of ETL test scripts based on technical specifications and source-to-target mappings
  • Experience working with multiple co-located teams
  • Communication (verbal, written, & listening), planning, organizing, analytical, and problem-solving skills
  • Ability to multi-task to meet critical deadlines in a rapidly changing environment
  • Ability to effectively present information and respond to questions
  • Knowledge of military/DoD-related data operations & procedures strongly desired

Education:
  • BS/BA plus at least 4-7 years of experience

Successful applicants will be asked to show proof of their U.S. Citizenship.

Benefits & CultureWhen you join our team, we are committed to enhancing your skills through training and certification programs, as needed, to facilitate your role on the team. Opportunities for advancement and variety are offered through the various projects we create and build for our customers and careers can take on a leadership path or progressive technical track through career and succession planning. At InnovaSystems, we embrace a philosophy of continuous performance management, including relationship building, feedback and recognition and we provide the leadership training and software tools to support these concepts.

Our comprehensive employee benefits offerings include:
  • Flexible schedule
  • Company-paid employee development learning and licenses
  • 10 paid holidays
  • 3 weeks (120 hours) of paid leave annually - hours increase after 3 years of service
  • 401k plan w/ company match
  • Comprehensive benefit package to include health, dental, vision, pet and supplemental insurance plans
  • Recognition & reward programs including peer-to-peer, service awards, leadership and values awards
  • Onsite offices with fitness facilities (depending on location)
  • Social events
InnovaSystems is a proud supporter of community organizations including; Challenged Athletes Foundation (CAF), Support the Enlisted Program (STEP), and Salvation ArmyInnovaSystems International is an EEO/AA employer M/F/D/V.

  • ID: #41166412
  • State: California San diego 92108 San diego USA
  • City: San diego
  • Salary: $110,000 - $125,000
  • Job type: Permanent
  • Showed: 2022-05-19
  • Deadline: 2022-07-15
  • Category: Government