ETL QA - Sirius DQ 1 1 1

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