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 setting.
- 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

📌 ETL QA - Sirius DQ 1 1 1 (Bengaluru)
🏢 marlabs
📍 Bengaluru