ETL Test Engineer - SGA Inc.

Software Guidance & Assistance, Inc., (SGA), is searching for an ETL  Test Engineer for a contract assignment with one of our premier Banking clients in Frisco, TX. Hybrid schedule 2x weekly onsite.

Must be local to the Dallas area - relocation candidates cannot be considered.

Responsibilities:

• Understand functional requirements for the Finance, Treasury and other banking Reg Reporting Test Scenarios.
• Creates use cases, user stories and test scripts for functional requirements validations.
• Defines testing phase entrance and exit criteria Facilitates environment readiness validation (connectivity, test data, user access etc).
• Coordinates/oversees validation of end-to-end business and system processes (starting from sourcing to rendering to data capture to reporting).
• Plans, coordinates, executes non-functional testing, system integration and user acceptance testing, communicates test plans, progress, issues, and risks to key project stakeholders.
• Conducts requirements traceability, gap analysis, Diagnoses problems and reports defects.
• Use discretion and judgment to maintain the confidentiality of sensitive data
• Strong experience using Informatica tools, understanding data pipelines and processes.
• Proficiency in working on Agile/Scrum environments, participating in sprint planning, daily stand-ups and retrospectives. Implementing regression test suites for ETL pipelines, enabling continuous integration and testing.
• Experience in collaborating with cross-functional teams, including business analysts, developers and data architects to understand data requirements, define and design appropriate test strategies.
• Leadership experience in mentoring junior testers, guiding teams in best practices for ETL testing and improving the overall QA process.
• Experience in managing QA activities, ensuring alignment with project timelines, maintaining quality standards throughout the ETL lifecycle.

Required Skills:

• 7+ years experience in automation and manual positive & negative testing, adopting best practices for functional, system integration testing use cases.
• 5+ years experience in testing, validating large volumes of data in large data warehouse and ensuring the accuracy of data quality, transformation and data flow processes with data security enforcement.
• 5+ years experience with snowflake specific features, such as SnowPipe or SnowSQL including writing and testing complex SQL queries or Python code.
• 5+ years experience Creating automation test suites using SQL, python, pytest framework.
• 5+ years experience on test management tools used for project. management, Bug tracking and Test management like QTest, JIRA.
• 3+ years of banking experience with strong documentation of test evidences to fulfill compliance, security, regulatory audit needs.
• Must have excellent troubleshooting and problem-solving skills to identify root causes of issues and recommend resolutions.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.