Data Test Specialist
- Coforge
- 6 - 10 years
- Noida, Gurugram
- 8 months ago
- Email to a friend
- Report this job
Job Description
- 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 signoffs 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, PYTHON, JavaScript, Java.
- Identify test approaches, coverage, requirement gaps and risks and risk remediation.
- 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.
- Validate 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.
Requirements:
- 8+ experience as Data warehouse developer tester or ETL Tester.
- Graduate degree preferred in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
- Experience with testing tools like Tosca/Python DataCompy tool (Or similar).
- Expert in understanding and implementing QA/Testing Lifecycle.
- Expertise in DB-related testing and ETL testing.
- Testing experience with reporting and BI tools.
- Writing basic SQLs to check record counts, data truncation, invalid data types.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Quality Assurance and TestingRole: Data / Big Data Testing EngineerEmployement Type: Full timeContact Details:
Company: CoforgeLocation(s): Noida, Gurugram
Keyskills: amazon redshift data mapping sql sqls test data java testing life cycle asp.net etl reporting tosca c# python data analysis ssas automation testing business analysis power bi application engine vb data engineering javascript sql server etl testing quality assurance ssis db
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in