Job description
Position Summary:
This position requires a strong engineer with extensive experience in Testing of complex Data-warehouse, Reports and AWS Cloud eco systems.
Duties and Responsibilities:
The Data QA engineer will:
- Review project deliverables (for example, Business Requirements, Functional Requirements, Technical Designs) as they relate to a given test stage.
- Manage offshore team (provide guidance, task assignment and communicate project updates to offshore)
- Review offshore deliverables and communicate to delivery team.
- Review and provide input to test deliverables.
- Define test plan / strategy and identify risks related to testing efforts.
- Create test cases based on requirement & technical design specifications for data validation.
- Understand ETL logic & write complex SQL queries for data and Report Validation
- Understand Cognos Report logic and develop SQL queries for report data quality validation
- Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
- Ensure issues are identified, tracked, reported on and resolved in a timely manner
- Works across various groups & effectively drive testing of cross-team solutions that have complex dependencies and requirements.
- Inform the Project Test Lead of issues that may affect the schedule, budget, or quality of the solution or the testing process.
Minimum Qualifications:
(MUST list minimum level of experience (years) and education required) First bullet: Degree Second Bullet: Years of Experience
- Bachelor's Degree in Information Technology or related field, or equivalent work experience
- 5 to 8 years experience in QA analyst roles in BI (Data warehouse & Report) environments
Requirements and General Skills:
(keep applicable bullet points and remove/add as relevant to job)
- Good public speaking and presentation skills.
- Interpersonal skills and ability to interact and work with staff at all levels.
- Excellent written and verbal communication skills.
- Ability to work independently and in a team environment.
- Ability to pay attention to details and be organized.
- Ability to project professionalism over the phone and in person.
- Ability to handle multiple tasks in a fast-paced environment.
- Commitment to internal client and customer service principles.
- Willingness to take initiative and to follow through on projects.
- Creative writing ability.
- Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment.
Technical Skills:
(list required computer and technical skills and equipment/software used)
- Background with traditional databases such as Oracle, Teradata, SQL Server, ETL tools / processes and data warehousing architectures.
- Experience in AWS eco systems (S3, Redshift, Aurora, etc.)
- Experience in using tools such as Informatica, job scheduling and Unix scripting
- Extensive testing experience in Data warehouse, DataMart, Stored procedure, ETL jobs, Report ,Cube
- Experience in Test data management
- Strong knowledge of data structures, algorithms, enterprise systems, and asynchronous architectures.
- Experience with raw, unstructured data.
- Strong quantitative, data tabulation and analytic skills.
- Ability to investigate discrepancies in data by writing queries and comparative analysis.
- Ability to develop and use test plans, test cases, test scripts, test results
- Experience using technical documents such as business requirements, functional requirements, database design representations, data and systems flow diagrams.
- Streaming data validation experience is plus
