Quality Assurance Engineer - REMOTE - US Citizenship Required

Company: General Dynamics Information Technology
Location: Petaluma
Posted on: November 15, 2022

Job Description:

Type of Requisition: RegularClearance Level Must Be Able to Obtain: NonePublic Trust/Other Required: BI Full 6C (T4)Job Family: IT Quality AssuranceGDIT, a Federal marketplace leader in next-generation IT solutions and services, is seeking highly qualified and motivated IT professionals like you who are eager to contribute to our critical Homeland Security missions. For the Department of Homeland Security (DHS), GDIT provides enterprise IT services for DHSs biometric identity management system (IDENT) and the Office of Biometric Identity Management (OBIM) to store, match, share, and analyze biometric and biographic data in support of DHSs strategic mission. GDITs operations and maintenance (O&M) services support break-fix of current OBIM functional capabilities, as well as security remediation activities and developmental engineering (such as prototyping new code or configurations of OBIM functionality). At the most critical moments of change, were there - bringing the resources, solutions, and expertise to help our clients take on some of the worlds biggest challenges - and GDIT is excited to offer you a unique opportunity to join a best performing O&M team supporting one our nations most critical national security, law enforcement, immigration and border management, and intelligence missions.GDIT is looking for an Quality Assurance/Tester to serve on the Operational Data Store (ODS) / Business Intelligence (BI) team for this large, complex task order. The successful candidate will support the OBIM data warehousing (DW) and BI environment and reporting capability in GovCloud. You are expected to apply your technical expertise and knowledge to provide continuous quality assurance of our data migration (ETL), datamart, and BI report development and validation. You will apply your quality assurance and testing skills to streamline our current data validation regime across multiple databases and environments. You may create Informatica ETL mappings and workflows based on existing templates. You may develop Oracle and Redshift tables and create Informatica mappings and workflows to perform high volume sampling data validation. You will perform exception analyses for data count and/or data value discrepancies. You will use your skills to automate and streamline validation methods and reporting. You will present findings and work with team on mitigations. You will validate business intelligence reports generated from BIRST and potentially other GovCloud BI tools.Specific responsibilities include but are not limited to: Perform daily data validation of ETL processes for staging and datamart Perform exception analyses on daily validation results Manage and maintain data validation and analyses Implement automated solutions to improve and streamline validation methods and reporting Work across heterogeneous platforms - on-premise Oracle, AWS/GovCloud Redshift Based on existing ETL mappings, create additional ETL mappings and workflows to run validation samples Perform Business Intelligence report validation Manage validation of tables Capture the artifacts (Text and/or MS Excel formats) in SharePoint and manage them Develop SQL Queries and PL/SQL Programs, MS Excel/VBasic functions, Linux scripting, cron jobsRequired Skills / Qualifications: U.S. citizen DHS HQ EOD required to start; must be able to obtain DHS HQ Final Suitability BA/BS or equivalent and 2+ yrs related experience Data validation/quality experience Oracle PL/SQL developerDesired Skills / Qualifications: 5+ yrs related experience Degree in systems engineering, computer science, information systems, or other relevant technical field of study AWS, S3, and Redshift experience Experience with Informatica PowerCenter, AWS DMS Experience with BI tools, e.g. Birst, Quicksight, others Experience with DHS vetting-related data and/or application solutions Unix/Linux OS and scripting experience Certification in AWS Cloud Practitioner, Operations, and/or Specialty domainEDUCATION AND EXPERIENCE: BA/BS or equivalent, 5+ years of experienceCOVID-19 Vaccination: GDIT does not have a vaccination mandate applicable to all employees. To protect the health and safety of its employees and to comply with customer requirements, however, GDIT may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements.We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.

Keywords: General Dynamics Information Technology, Petaluma , Quality Assurance Engineer - REMOTE - US Citizenship Required, Engineering , Petaluma, California