Data Assurance

**Role Purpose**:
Working for Business Intelligence requires a good understanding of the business context and the business requirements. The focus of the role is testing BI Applications which are the data provisioning layer and direct interface to our BI customers. A major focus is to make sure the quality of backend development for this layer, which means, being responsible for the development of required data structures, data marts, their provisioning with data, and their transfer into regular.

Business Intelligence testing initiatives help companies gain deeper and better insights so they can manage or make decisions based on hard facts or data.
- Simple, a BI testing project is a testing project too. That means the typical stages of testing are applicable here too, whether it is the performance you are testing or functional end-to-end testing:
- Test planning
- Test strategy
- Test design (Your Test cases will be query intensive rather than plain text based. This is the ONE major difference between your typical test projects to a Data Warehouse/Reporting/BI testing project.)
- Test execution (Once again, you are going to need some querying interface such as Teradata SQL Assistant, to run your queries)
- Defect reporting, closure, etc.

**BI Testing Strategy**:

- A comprehensive test strategy is the stepping stone of an effective test cycle. The strategy should cover test planning for each stage, every time the data moves, and state the responsibilities of each stakeholder e.g. business analysts, infrastructure team, QA team, DBAs, Developers, and Business Users. To ensure testing readiness from all aspects the key areas the strategy should focus on are:
- Scope of testing: Describe testing techniques and types to be used.
- Test environment set up.
- Test Data Availability: It is recommended to have production-like data covering all/critical business scenarios.
- Data quality and performance acceptance criteria.

**Key Accountabilities**:
**Main Tasks**:

- Verify transformations of data are applied correctly at the data mart level or not.
- Check if the target and source databases are connected well and if there are no access issues.
- While loading the data, check for the performance of the session
- Verify you can fail the calling parent task if the child task fails.
- Verify that the logs are updated
- Verify mapping and workflow parameters are configured accurately
- Verify data completeness
- Make sure data transformations are correct as per applied business logic.
- Make sure no Data loss during the data integration process and handshaking between sources.
- Keen to understand the data.

**Interfaces with Customers**:

- All Vodafone departments

**Leadership & Teamwork**
- Technical development lead
- Works in several project teams

**Innovation & Change**
- Develops rules and guidelines for efficient and customer-friendly BI solutions

Communication: in close collaboration with all other BI departments as well as IT departments

**Essential**:

- Manual testing, DWH testing
- SQL
- Attitude to plan and organize work to deliver as agreed
- Excellent verbal and written communication
- Excellent data interpretation skills
- Good understanding of the range of data manipulation and analysis techniques
- Detail-conscious, Problem solver & Innovative thinker
- Ability to work under pressure to tight deadlines.
- Should be able to interact with the client teams and share ideas.
- Relevant work experience (4-5) years

**Desired**:

- Telecommunication experience
- SQL, Jira, HP-ALM
- Excellent communication skills
- Written and verbal English language
- Ability to respond quickly to issues and risks
- Ability to highlight possible issues proactive
- Orientated for process improvements
- Being a problem solver
- Team player

**Skills**:

- Primary Skills: Manual testing, SQL ,DWH testing, Teradata, Excel, BTeq, ,VBA-Macros,UAT
- Alternate Skills: HP-ALM, Data Analysis