QA Automation Engineer - Java / Datawarehouse

Covent Garden
07 Oct 2016
02 Nov 2016
Contract Type
The Role The purpose of the role is to QA and test the data warehouse solution and google cloud data within Gamesys. These include ability to plan, design, script and execute test cases. Assist with regression testing efforts utilising both automated and manual test cases. Clarifying requirements and understanding design documents. You will be working as part of growing team of developers and QA analysts as well as collaborating closely with the analytics, technical, and business teams. Key Responsibilities Test all changes to data coming into, and being transformed within, the warehouse and google cloud. Ensure that all changes impacting system data are adequately tested end-to-end. Define and create sets of test data as required for specific test cases and scenarios. Test cloud based java code, google dataflow. Able to design, build and implement test automation. The Person Experience 5 years of writing and executing complex test cases within large-scale high-volume OLTP & OLAP databases. Experience in SQL and test expertizes in ETL / Data Migration / Data Transformation is must. Strong Unix understanding and core familiarity is a must. Knowledge of one or more object oriented languages (e.g., C++ or Java) and/or scripting languages like python. DB2 or any major RDBMS, Oracle, SQL Server, Sybase, MySQL etc. Working to structured releases and deadlines. Handling very large data volumes. Experience in Agile process Excellent understanding of non-functional requirements, test analysis, software engineering principles and continued improvement methods Gherkin based BDD framework Understands the benefits and differences between API/Integration and Unit testing. Working experience of the Job Schedulers like Control-M. Testing java based code. Skills Strong knowledge of manual and automated testing. Strong functional testing experience in a detailed manner through a full testing phase. Experience of both positive and negative points of failure Strong SQL querying experience Understanding of OLTP and OLAP data structures. Working knowledge of UNIX/Linux command line and basic scripting. Defect management. Test data creation and management strategies. Attitude The successful candidate will be willing to: Provide out of hours support during releases. Undertake technical and non-technical training as required. Keep open and continual communications with your manager and your team with regard to workload and projects. Desirable: Data Warehousing. BigData technologies like Hadoop, BigTables, Google Cloud Computing, AWS. Online gaming experience. Experience of software testing tools and test automation. Experience in performance and load testing. Experience of Agile software development practices. Data Platform Team - About Us The Data Platform is where we collect, analyse and use the data from our live gaming sites in order to provide analytics, insights and reporting to internal and external customers every day. At the heart of our operation is a 45Tb Data Warehouse that is growing by 100,000,000 game events and associated transactions every night, populating over 1,000 tables. This includes collecting data from backend relational databases, such as DB2 and MySQL, various gaming APIs and also Splunk logs that contain information such as which devices our members are playing our games on. We have strong, Agile teams that adhere to a Scrum methodology to deliver quality ETL software, working closely with our Business Intelligence teams and external regulators, as well as the Core Platform and DBAs to deliver data where it matters. Primarily we are DB2 driven, but the teams have a passion for seeking out new data sources to add value to our products, which includes exploring additional technologies to further drive the Data Platform, such as Java for automated testing, researching how Hadoop can be used in our operations and utilising the power of graph databases, such as Neo4j as well as using R and IBM data mining tools to provide statistical data models that can be used to make important business decisions. About Us We are on a mission to become the world’s most entertaining online gaming company. It all started with Jackpotjoy but along the way we have grown into the award-winning team of designers, developers and operators behind some of the leading gaming sites and apps including Virgin Games and Caesar’s Casino. But, we haven’t stopped there we’re also behind Bingo Lane, Jackpotjoy Slots and other great free-to-play games. Born in 2001 with just a handful of developers, we are now over 900 employees strong across 7 group offices worldwide with our headquarters in Central London. Over 24 million players enjoy our 258 games, generating on average 6,028 chat messages every 15 minutes Whether it be through the awards we've won for innovation in Bingo and Slots, our commitment to using cutting edge technology, or simply our passion to innovate, thrill, and surprise, Gamesys constantly pushes the boundaries to be the best in class. Our culture is visible everywhere. Visit our reception - you’ll find sweets and a giant monkey, in the design team a giant red lamp and the latest quad core mac pros; the breakout areas a Gamesys pool table and fridges full of beer, wine and soft drinks. In the meeting rooms you might find grass instead of carpet, in the summer you’ll meet all our families together for a celebration and in the winter you can find Mexican wrestlers or circus acts roaming around. Weekly social and sports events give you the opportunity to stretch both your mind and body, whether it be getting involved in a meetup or brownbag session, playing in the poker tournament or joining one of the many sports teams. But our culture is not just in what you can see it's in everything we do, we're hard workers and we get stuck in. We have fun, making fun and our vision is to invent, play and discover together, to craft experiences that thrill our players and rock the world. This job was originally posted as