This job offer is not available in your country.

ETL QA - Sirius DQ 1 1 1

ConfidentialBengaluru / Bangalore

11 days ago

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

Skills Required

Sql Server, Etl Tools, Oracle, Teradata, QA Analyst

Create a job alert for this search

Etl • Bengaluru / Bangalore