Database Test Engineer (SN1000377)
Posted on: January 14, 2019
The Database Test Engineer is responsible for establishing and extending defined data quality checks. This role will analyze, automate, maintain, and implement testing methods and procedures necessary for different data systems. This includes a wide range of data analysis and holistic testing of many complex data models. This role performs other duties as required to ensure that the products or features meet requirements and quality standards. This position is responsible for testing multiple projects at one time, in various different stages of development, in a fast-paced environment. ESSENTIAL DUTIES AND RESPONSIBILITIES:* Work closely with the Business Intelligence and Data Warehouse development team to understand the data and business requirements for development projects.* Perform data analysis, testing, and validation using complex SQL queries, stored procedures and data - driven testing methodologies to create repeatable tests that leverage source-to-target validation.* Adopt Kanban Jira board and Agile methodologies utilized by the Business Intelligence and Data* Warehouse team.* Attend Daily Stand up meetings and Code Review sessions held prior to validation effort to aid in the understanding of the design and architecture.* Monitor validation reports for issues and errors. Open bug/issue tickets for the Data Warehouse team to address and/or research.* Work independently and act as a liaison between QA and the ETL Development team.* Ensure QA concerns are escalated to Management regarding deployment readiness or jeopardy items.* Work with Functional QA and QA Automation team members to achieve department goals.* Open to new technologies, process improvements and movement toward a Cloud Data Warehouse architecture. Required Skills* Bachelor's degree in Business or technical field or similar discipline; minimum five years of software/Quality Assurance testing experience.* 5+ years professional experience overseeing the design, development, and implementation of quality assurance standards for data testing.* Extensive experience writing SQL verification scripts against a complex ERD.* Extensive experience testing SQL objects including views, ETL scripts, Ad-hoc SQL statements, and stored procedures, for accuracy and consistency through multiple layers of an application.* Highly efficient knowledge of complex SQL.* A good understanding of Cloud & Data Warehouse concepts.* A good understanding of schema changes, stored procedures, and database reporting.* Understand data transaction and load testing.* Experience with Agile development environments, specifically Scrum and Kanban.* Experience with Microsoft SQL Server Management Studio or equivalent data analysis tools.* Experience in Microsoft SQL Server.* Strong communication and problem-solving skills.* Detail-oriented with strong analytical and organizational skills* Ability to address time-sensitive demands on a continual basis.* Excellent teamwork and interpersonal skills.* Media and Entertainment experience preferred. OTHER REQUIREMENTS:* Experience with Tableau, Cognos, SSRS, or similar data reporting tools a plus.* Experience with functional automation tools like Selenium a plus.* Good understanding of Amazon Redshift and Amazon Elastic Cloud (EC2) is a plus* Experience with JIRA and Confluence preferred.* Experience in cloud-based data warehousing solutions such as Redshift or Snowflake, a plus.* Ability to read Python load scripts, a plus STARZ (www.starz.com), a Lionsgate company (NYSE: LGF.A, LGF.B), is a leading global media and entertainment company that provides premium subscription video programming on domestic U.S. pay television networks and produces and distributes content for worldwide audiences, including its investment in the STARZ PLAY Arabia OTT service. STARZ is the ultimate destination for obsessable TV, movies and more. Characters who pull you in and stories that stay with you. From bold Original Series to the best movies, whatever you love, STARZ ignites your passions. STARZ offers a competitive compensation package and an attractive benefits program to all eligible employees including a variety of healthcare plans, dental and vision insurance, 401k, life/disability insurance. Eligible employees will enjoy paid time off in the form of vacation and company holidays. STARZ is an Equal Opportunity Employer. This means that all applicants will receive consideration for employment regardless of gender, age, race, national origin, disability, color, religion, sexual orientation, gender identity and/or expression, veteran status, or any other characteristic protected by federal, state or local law. In addition, STARZ will provide reasonable accommodations for qualified individuals with disabilities.
Keywords: Starz, Denver , Database Test Engineer (SN1000377), Engineering , Englewood, Colorado
Didn't find what you're looking for? Search again!