Lead ETL QA Consultant

$73,008 - $170,640/Yr

Perficient - Livonia, MI

Full-time - Senior

Livonia, MI

Professional, Scientific, and Technical Services

About the position

The Lead ETL QA Consultant role is a hands-on position focused on understanding ETL/ELT test requirements and performing comprehensive data testing. The consultant will create and execute test plans and scripts to validate data quality and integrity during the ETL process, automate data validation tests, and ensure compliance with data quality standards while communicating progress and results to stakeholders.

Responsibilities

• Develop and support requirement analysis, Test Estimation, Test Planning, design test cases, traceability matrix, execution of test cases and support of Extract, Transform, Load (ETL/ELT) processes and environments.
• Experience in Data Testing, Data Conversion, Data Migration, Data Transformations, Data Profiling, Data Analysis and Data Quality Validation.
• Experience in testing of ETL Mappings to extract data from multiple sources like Oracle, SQL Server, Flat files etc. into target tables using transformations like Expressions, Lookups, Source Qualifiers, Aggregators, Filters, and Joiners etc.
• Hands on experience in design and implementation of E2E Data testing strategies and developing data testing automation frameworks.
• Work on End-to-End product feature testing and Business Report Testing. Designing, testing, and troubleshooting data and reports.
• Deep understanding of data sources like Informatica, SQL Server, Oracle and experience writing complex queries for data validation of business logic transformations.
• Hands on experience with cloud data platforms like Snowflake is a must.
• Must have dataOps implementation experience, integration QA automation suites with devOps pipelines.
• Must have hands on Test automation experience to drive test automation strategy and test automation implementation.
• Interact with project teams, development, operations, and infrastructure resources to recommend solutions to remediate data issues.
• Experience in defect life cycle management - logging, replication, triaging, verification, closing, metrics reporting, etc.
• Demonstrated ability to acquire high volumes of test data required to support Test execution.
• Experience handling multiple team members under offshore and Onshore model.
• Good understanding of Agile methodology.
• Mentor and groom team members on product/application features/functionality and domain.
• Working knowledge of test management tools like HP ALM, Jira etc.
• Excellent verbal and written communication skills.

Requirements

• A bachelor's degree in Computer Science or related information technology field from an accredited institution or equivalent work experience.
• 9+ years of software product development and delivery experience.
• 7+ years of ETL testing/SQL experience.
• 5+ years of Snowflake experience.
• Experience building CI/CD pipelines for data testing.
• Test Automation experience required, writing scripts using Java strongly preferred.
• 5+ years' experience overseeing the development of data test plans, test scenarios, test cases, execution of test case and documentation of test results.
• Working experience with programming languages like Java is a must.
• 5+ years of experience in some of the Cloud data platform tools: ADF, PySpark, Scala.
• 5+ Experience with Java, Python and libraries like Pandas, Numpy.
• Experience in summarizing large number of metrics into meaningful graphs and reports.
• Hands on experience with testing tools such as Great Expectations and dbt will be preferred.
• Familiar with latest Cloud technologies.
• Experience working in a QA Lead capacity.

Nice-to-haves

• Experience with testing tools such as Great Expectations and dbt will be preferred.
• Familiar with latest Cloud technologies.

Benefits

• Competitive salary range of $73,008 to $170,640 based on experience and location.
• Opportunities for professional development and career growth.
• Collaborative and inclusive work culture.
• Diversity and inclusion initiatives.