ETL tester

Title: ETL tester Client: BAH/IRS Position: Remote Job Description: Key Role: As ETL Test Engineer you will be expected to perform manual and automation testing in validating data sources, extraction of data, applying transformation logic, and loading data into target tables, working closely with data engineering functions to ensure a sustainable test approach. Basic Qualifications: ¿ ETL tester with at least 44 years of ETL testing experience ¿ Testing experience in Data Engineering (Spark/PySpark and Data Bricks), Big Data Testing and Strong Python/PySpark scripting. ¿ Strong working experience with AWS Services like Glue, EMR etc. ¿ Experience with AWS Databases RDS PostgreSQL/AWS Redshift/ MS SQL Server/Mongo DB Database and highly proficient with complex SQL scripting to validate source/target data load and transformations ¿ Experience in Databricks data pipeline testing with Databricks/Spark framework in AWS cloud infrastructure ¿ Knowledge of applying the PySpark Data Frame API concepts using PySpark to complete data transformations/manipulation task's ¿ Strong uCandidate needs to have a very good understanding of business intelligence concepts, architecture & building blocks in areas ETL processing, Databricks Delta lake, Datawarehouse, dashboards and analytics ¿ Experience on different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing as needed. ¿ Hands-on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) on Agile Scrum environments ¿ Work with DevOps team to integrate the test automation scripts into GitHub/Jenkins CI/CD pipeline. ¿ An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects ¿ Experience with Integration testing and E2E testing among different upstream projects ¿ Public Trust clearance Additional Qualifications: ¿ Experience using JIRA, Cucumber Gherkin, BDD, IBM's ETM/ELM toolset ¿ Data migration testing automation experience using tools like iDQE or Informatica Data Validation ¿ Working knowledge in scripting languages like Python to create automated Test Scripts ¿ Experience with Selenium Rest Assured API automation testing experience ¿ Experience creating Selenium Automation Frameworks from scratch ¿ Working knowledge of non-functional automation testing tools, including JMeter or LoadRunner ¿ Experience Experience with DevOps concepts and integrating regression tests as part of the CI/CD pipeline and build process ¿ Experience with implementing a test automation suite to validate COTS and 3rd party products ¿ Knowledge of non-functional automation testing tools, including JMeter or LoadRunner ¿ Agile or SAFe certification Clearance: Applicants selected will be subject to a security investigation and may need to meet eligibility Eligibility Requirements: Candidate MUST satisfy 80% of job requirements to submit resume. Candidates who are clearly unqualified (less than 60% skill match), or lacks legal work status will be rejected & reported. SORRY, NO CORPORATE TO CORPORATE (CORP. 2 CORP. / C2C) APPLICANTS will be considered for this position. Candidates must be willing to work on Virpie or client's W2. About Virpie Tech: A certified NMSDC minority-owned consulting firm since 1997, providing a complete range of staffing services to Fortune 500 companies nationwide across a broad spectrum of industries along with various Federal and State goverment agencies. We consult with candidates to understand their personal goals before discussing technical skills and offer an opportunity to succeed. The enthusiasm our employees bring to work extends to their personal life, and we encourage a healthy balance of work and life. Virpie has won awards for Top 50 Diversity Business, Fortune 50 Company, Inc. 500 Fastest Growing Company, and Diversity Business Top 500 Business. Virpie is an Equal Opportunity Employer; welcoming diversity as a competitive advantage We honor our Veterans Visit us at: www.virpietech.com