Job Summary
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.
- Minimum Qualification: Degree
- Experience Level: Mid level
- Experience Length: 5 years
Job Description/Requirements
Nice To Have:
- 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
Important Safety Tips
- Do not make any payment without confirming with the Jobberman Customer Support Team.
- If you think this advert is not genuine, please report it via the Report Job link below.