Data Migration ETL Tester

Key Role:

Conduct extract, transform, and load (ETL) testing of the data extracted, transferred, and loaded from the current Oracle database to the new Azure Synapse database. Write and execute test scripts, employ test frameworks and methodologies, document results, and communicate results back to the data engineering and architect team. Review complex database models and use Oracle and Azure databases. Work independently to execute ETL and work collaboratively with the data engineer and ETL team. Work with a highly dynamic team, executing in an Agile program environment.

Basic Qualifications:   

• 5+ years of experience with automating ETL testing processes to improve efficiency and reusability

• 5+ years of experience with developing and executing test plans, test cases, and test scripts to validate ETL processes

• 5+ years of experience verifying data completeness, correctness, and consistency through data profiling and business rules analysis

• 5+ years of experience performing regression testing to ensure updates to ETL processes do not introduce new issues

• 5+ years of experience collaborating with data engineers, analysts, and key stakeholders to communicate test results

• 5+ years of experience with SQL and relational database

• Experience with ETL testing tools and frameworks

• DHS suitability

• Bachelor's degree

Additional Qualifications:

• Experience with Oracle DB

• Experience with Synapse DB dedicated SQL pool

• Experience identifying and applying methods to cleansing data quality issues

• Experience with data models, database design development, data mining, and segmentation techniques

• Experience on an Agile delivery team

• Experience with Jira and Confluence collaboration tools

• Experience on Business Intelligence programs

• Experience working with Federal Government clients

• Experience working with data types, including workforce, human capital, procurement, acquisitions, real property, personal property, security, logical, or physical access

• Possession of strong verbal communication skills

Vetting:

Applicants selected will be subject to a government investigation and may need to meet eligibility requirements of the U.S. government client; DHS suitability is required.

Compensation

At Booz Allen, we celebrate your contributions, provide you with opportunities and choices, and support your total well-being. Our offerings include health, life, disability, financial, and retirement benefits, as well as paid leave, professional development, tuition assistance, work-life programs, and dependent care. Our recognition awards program acknowledges employees for exceptional performance and superior demonstration of our values. Full-time and part-time employees working at least 20 hours a week on a regular basis are eligible to participate in Booz Allen’s benefit programs. Individuals that do not meet the threshold are only eligible for select offerings, not inclusive of health benefits. We encourage you to learn more about our total benefits by visiting the Resource page on our Careers site and reviewing Our Employee Benefits page.

Salary at Booz Allen is determined by various factors, including but not limited to location, the individual’s particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements. The projected compensation range for this position is $73,100.00 to $166,000.00 (annualized USD). The estimate displayed represents the typical salary range for this position and is just one component of Booz Allen’s total compensation package for employees.

Work Model
Our people-first culture prioritizes the benefits of flexibility and collaboration, whether that happens in person or remotely.

• If this position is listed as remote or hybrid, you’ll periodically work from a Booz Allen or client site facility.
• If this position is listed as onsite, you’ll work with colleagues and clients in person, as needed for the specific role.

EEO Commitment

We’re an equal employment opportunity/affirmative action employer that empowers our people to fearlessly drive change – no matter their race, color, ethnicity, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, ancestry, age, marital status, sexual orientation, gender identity and expression, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, local, or international law.