Job description
Contract Length: Permanent
Role Description:
Our life Insurance client is seeking a talented Data Warehouse Software Development Engineer in
Test (SDET) who is passionate about Software Quality, has an Agile Tester mindset and is interested in developing their knowledge and skillset within the Data Warehouse space. This role will involve close collaboration with all members within the Data & Analytics team to support and test throughout the entire data development lifecy within our data warehouse and reporting systems, including data profiling, ETL and data model design, development, testing and support. We’re looking for someone who has strong experience testing data warehouse and reporting systems and the underlying ETL jobs. The ideal candidate for this role has a programming background and has experience leveraging test automation within the Data Warehouse layer to support an efficient testing strategy. This candidate is team oriented, quality-focused and a great communicator with a proven ability to streamline the QA process by leveraging automated solutions.
- Design and develop the test strategy and test artifacts to validate our data warehouse E2E
- Responsible for devising the test automation strategy and tools for validating the data,
- Conduct thorough testing of the data warehouse solutions.
- Devise an environment management strategy for the Data Warehouse and Reporting Test
- Work with the team to define the core QA gates and processes for new Data Warehouse
- Work with the team to define the key QA gates and test approach for functionality delivered
- Build out a core data warehouse regression suite focusing on leveraging automated validation
- Validate the source to target mappings using a variety of tools.
- Reports validation ensuring the finalised reports are an accurate reflection of the source data.
- Ensure comprehensive and transparent test coverage for new and existing functionality.
- Ensure the testability of new Data Warehouse features is considered during analysis and
- Develop a deep understanding of the E2E flow in the Data Warehouse and the associated BI
- Test coordination with the relevant User Acceptance Testers to ensure we have an efficient
- Implement best of breed, scalable solutions according to defined patterns and practices.
- Work closely with the Data & Analytics Software Engineers to develop a deep understanding
- Work as part of a Scrum team using Agile practices and adhering to the values and principles.
- Promote testing best practices within the team.
- Researching test tools, methodologies, and trends and working on continuous process
- Work closely with the Data Architect to create the appropriate test strategies for new
- Excellent MS SQL Server experience and can build and analyse complex SQL queries
- Experience with Business Intelligence tools such as Microsoft Power BI And SQL Server
- Experience working with relational data models
- Experience implementing best-in-class testing strategies, processes, test tools and best
- Must be a self-starter comfortable working in a fast-paced, flexible environment, and take
- Strong Experience working as a technical tester specialising in data warehouse technologies
- Experience with test automation in the Data Warehouse space with hands on experience
- Demonstrate hands on experience of testing code quality & metric production & the
- Agile tester mindset and approach that has experience defining test approaches that
- Strong communication skills and the ability to influence the Delivery Team on Software
- Proven ability to assess inefficiencies in testing strategies and the successful execution of
- SQL Server Management Studio + Integration Services addon (SSIS)
- SQL Server Analysis Services (SSAS)
- SQL Server Reporting Services (SSRS)
- Power BI
- Strong SQL Server skills – Building and analysing complex queries and PL/SQL
- Tivoli Workload Scheduler (TWS) or similar Enterprise Scheduling tools
- Java, Python, Bash, PowerShell
- The candidate needs to be a self- starter and implement best of breed testing solutions
- Passionate about Quality with a continuous drive for improvements
- Strong communicator and proven ability to influence test approach and process within teams
- Interested in Data & Analytics and developing their expertise and skillset in this area
- Minimum 3 years’ experience in a similar role.
- 3rd level qualification (honours degree), preferably in a related discipline.
- Experience in the financial services background
- Ref. Number
BNDWSDET
- Location
Dublin City Centre
- salary
Negotiable
- job type
Full Time
- date posted
18th of October
- category
IT
seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.