Lead DWH / ETL tester

Job type:
on-site
Start date:
ab sofort
Duration:
12 months
Location:
Amsterdam
Published at:
05/25/2021
Country:
flag_no Netherlands
Contact person:
Mritunjay jha
Project ID:
2120113


We are Looking for Lead DWH / ETL tester for a long term project

Locations: Amsterdam
Language- English, Dutch
Start- ASAP

Job Description:
Lead DWH / ETL tester
Responsibilities

Be responsible for creating comprehensive test plans for DWH release
Review and analyse system specifications and write effective unit tests
Design and develop SQL scripts to generate test data, and compare expected vs. actual data created by ETL processes
Execute unit, regression, performance and integration testing (manual and automated) and analyse the results
Collaborate with ETL developers on troubleshooting and debugging of ETL jobs; identify required improvements of ETL code
Collaborate with business users for executing user acceptance testing
Collaborate with DBAs to identify improvements to the DWH performance
Ensure representativeness of test environments from both code and data perspective
Monitor and regularly report the performance of testing in accordance with established KPIs
Establish and reinforce quality standards in functional and regression testing; establish and monitor testing KPIs
Write technical documentation and specifications
Reinforce continues integration principles in testing; actively contribute into maturing the CI practice
Contribute into the design and implementation of testing tools and applications


Qualifications:
• Experience with all types of ETL/DWH testing including systems, integration, and acceptance in data warehouse environments
• Experience in creating test plans, cases, and scripts without the use of testing case tools
• Expert level of knowledge of Microsoft SQL services and technologies (SSIS, SSAS, SSRS and SQL Server 2012+)
• 5+ years of experience in SQL; Strong SQL scripting knowledge
• Experience in Regulatory reporting like Anacredit,IFRS9,IRRB
• Experience in business analysis techniques.
• Previous experience in using tools for creating automated scripts
• Good working knowledge of at least one scripting language (Bash, Python or Perl) is an advantage
• Good knowledge of relational databases
• Demonstrated knowledge of data warehouse concepts
• In-depth knowledge of testing techniques, e.g. TMAP
• Experience of using Jira as a defect tracker
• Ability to troubleshoot and solve complex technical problems
• Experience in CI/CD tool like Bamboo is an advantage
• Working experience in Agile projects
• Experience in working in high priority projects (high pressure on delivery)
• Some flexibility outside 9-5 working hours
• Able to communicate complex information clearly and concisely.
• Able to work independently and also to collaborate across the organization
• Highly developed problem-solving skills with minimal supervision
• Excellent written and verbal communication skills in English

Competencies
Integrity and Responsibility
o Balance Risk with Opportunity
o Customer Focus
o Demonstrate Global Perspective
Professionalism and Teamwork
o Drive For Results
o Collaborate and Build Partnerships
o Communicate Effectively and Professionally
Challenge Ourselves To Grow
o Influence and Inspire Others
o Lead Change & Seek Continuous Improvement
o Think Strategically

The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.

We are proud to be an Equal Opportunity/Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate in employment decisions on the basis of any protected category.

Language skills
Verbal and written communication skills in English are essential.


eligible candidates, please share their CV at

Regards
CosMicIT