Lead ETL QA Consultant

This role will be hands-on position primarily focusing on understanding ETL/ELT test requirements from various programs/pillars and performing all facets of data testing.  Create and execute test plans and scripts that will validate the projects' data quality and data integrity as the data is transitioned through the ETL process.  Create test automation for data validations and integrate test automation with the DevOps pipelines for regression testing.  Test the compliance of information flows and data stores against data quality standards, and effectively communicate test progress, test results to the project stakeholders and management. Perficient is always looking for the best and brightest talent and we need you! We're a quickly growing, global digital consulting leader, and we're transforming the world's largest enterprises and biggest brands. You'll work with the latest technologies, expand your skills, experience work-life balance, and become a part of our global community of talented, diverse, and knowledgeable colleagues. 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 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   The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials. It is not typical for a candidate to be hired at or near the top of the range for their role, and compensation decisions are dependent on the unique facts and circumstances regarding each candidate. A reasonable estimate of the current salary range for this position is $73,008 to $170,640. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs. Information regarding the benefits available for this position are in this  benefits overview .   WHO WE ARE Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers' expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients - the world's largest enterprises and biggest brands succeed. WHAT WE BELIEVE At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you'll become part of something truly special. We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We're committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders... and we're not done yet.   Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.   Applications will be accepted until the position is filled or the posting is removed.   Disability Accommodations: Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.     Disclaimer:   The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification.  Management retains the discretion to add or change the duties of the position at any time.  #LI-JS1

Created: 2024-10-28