Luxoft company
🔔 Are you already in Poland? If YES this is the project for YOU!
Our benefits:
👩⚕️ Private Medical Care in Luxmed and Life Insurance
🏋️♀️ Multisport Card
👨👧👦 Paid referrals
📚 Self-learning libraries
🛫 Relocation package for seniors and assistance during all process...and MORE!
👉 Location: REMOTE POLAND
Project Description:
Project is maintenance and development for a bundle of applications. The described Test Expert is located at the Analytics Team.
Responsibilities:
- As a Data Test Engineer / ETL tester you would be responsible for validating data sources, extracting data applications of transformation logic, and uploading data in target tables.
- You would be responsible for designing, testing, and troubleshooting the company's data storage system before it goes live.
- Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts
- Define scope, execution plans, and coordinate test activities
- Ensure all sign-offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets governance requirements
- Responsible for ensuring the quality of their work the work of the entire development team
- Strong experience in of the following technologies preferred -SQL,PL/SQL and Informatica
- Participate in data conversion Testing and data maintenance, authoring SQL queries to fetch the data between various databases, execute them and analyze the data
- Create SIT test cases/test data and perform Test execution
- Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test cases
- Validates data by running queries in the database and verify that the results match the expectations
- Will be responsible to ensure quality of process and measurements are acceptable in accordance with the specifications
- Analyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects in JIRA and enables defect management, including working with the development team on the resolution of Software related defects
- Works closely with the software development team (Data Engineer, Business Analysts, Developers & other testers) to ensure timely and effective testing effort
- Writing queries to extract data for test case data comparison
Mandatory Skills Description:
- 3 years of experience as Data warehouse tester or ETL Tester
- Expert in understanding and implementing QA/Testing Lifecycle
- Expertise in DB-related testing and ETL testing
- Testing experience with BI tools like informatica
- Writing basic SQLs to check record counts, data truncation, invalid data types, NULLs and data integrity, data transformation, aggregate functions testing
- Experience in transforming complex Business logic into SQL or PL/SQL queries
- Must be a self-starter with the ability to work on complex projects and analyzes business requirements independently
- Must be able to identify and document testing issues and quality risks, participate in defect remediation
- Willingness to follow Agile Testing practices and guidelines, including Defect Management
- Actively participate in all test management activities like assessment, test strategies and test plans
- Knowledge of Database objects and relational data model
- Understanding of ETL requirements (source-to-target mappings)
- Testing experience with different file types
Nice-to-Have Skills Description:
- good to have Test automation experience
Languages:
English: B2 Upper Intermediate
