- Derex Technologies Inc
- Cincinnati, OH
- Full-Time
- 6 days ago
QA Data Test Lead: our view in 3 lines...
- The Role: Lead QA data testing for large-scale ETL and data migration efforts, validating data accuracy and quality across systems for enterprise clients.
- The Person: Design and execute ETL test plans and automated data validation to verify source-to-target accuracy, investigate data anomalies, and document and communicate data quality findings.
- Requirements: 6 years of ETL testing experience, SQL, Spark, Hive, Spark SQL and data frame API, Snowflake, Informatica, IDMC, CDV, CDQ and data quality automation tools.
Job Description
Company Description
Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.
With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.
Job Description
Role - QA Data Test Lead
Location - Cincinnati, Ohio(Hybrid)
Job Description:
- The Candidate is expected to work on large datasets and will be involved in ETL testing, and thorough validation between the source and target
- Develop and execute test plans, test cases, and scripts to validate data accuracy, completeness, and integrity.
- Perform functional, integration, regression, and performance testing of data pipelines, ETL processes, and databases.
- Identify and investigate data anomalies, inconsistencies, and discrepancies; troubleshoot and resolve data quality issues.
- Collaborate with data engineers, data architects, business analysts, and other stakeholders to understand data requirements and ensure data quality standards are met.
- Document test plans, test results, and data quality issues; communicate findings and recommendations effectively to technical and non-technical stakeholders
- Recommend and implement improvements to data quality processes, tools, and methodologies.
- Automate data validation and testing processes where possible to improve efficiency and accuracy.
Requirements - Must Have Skills:
- 6 years of total technical experience on ETL testing
- Experience in developing ETL test plans, test cases and validating large scale data migrations.
- P&C experience is must
- Strong understanding of ETL processes, SQL, Spark, Hive and data migration
- Advanced proficiency in writing SQL queries, hands-on experience with Hive, Spark, Spark SQL and data frame API.
- Experience with Snowflake data warehousing.
- Experience in testing using Informatica, IDMC, CDV, CDQ
- Experience with data quality automation tools and frameworks.
- Ability to document and present findings clearly and concisely.
- Excellent verbal and written communication skills.
- Strong analytical and problem-solving skills.
- Need to be excellent team player.
Regards,
Manoj Goud
Derex Technologies INC
Contact : 973-834-5005 Ext 206
Additional Information
All your information will be kept confidential according to EEO guidelines.
