SDET

Fannie Mae

Reston, VA

Full Time

Mid Level

4 days ago

Job Description

About the Role

At Fannie Mae, the inspiring work we do helps make a home a possibility for millions of homeowners and renters. Every day offers compelling opportunities to impact the future of the housing industry while being part of a collaborative team thriving in an energizing environment. Here, you will grow your career and help create access to affordable housing finance.

Key Responsibilities

Analyze requirements working with product owners/development team members to understand new features and user stories to design, develop, and execute test cases for testing.
Participate in all team ceremonies including PI planning, internal planning sessions and team retrospectives.
Write complex SQL queries to validate data across multiple databases.
Perform data validation and testing across AWS cloud-based data platforms.
Develop/update scripts using Python/Unix for data preparation activities and mockup data conditions/files required for testing.
Collaborate with cross-functional teams to ensure quality throughout the SDLC.
Identify, log, and track bugs, working closely with the development teams for resolution.
Support automation execution activities - data preparation activities including data refresh, cleanup, archival and table updates required for execution. Execution supporting table backups, generation of expected results and comparison reports for huge volumes of data.

Requirements

At least 2 years of relevant experience.
Strong understanding of SDLC and QA methodologies.
Proficient in writing and executing SQL queries for data validation.
Solid experience with Unix commands/scripting for file handling and log analysis.
Hands-on experience with test automation tools/frameworks.
Python programming skills for scripting and automation support.
Experience working in cloud environments, preferably AWS (e.g., S3, EC2, Lambda, RDS, SNS/SQS, EMR, Step Function).
Experience with CI/CD pipelines and tools like Jenkins, GitLab, or GitHub Actions.
Experience with creating test cases/test execution sets and defects in JIRA.
Strong problem-solving skills in troubleshooting issues in data validations.
Ability to effectively communicate and collaborate with other application teams and key business stakeholders.

Nice to Have

Bachelor's degree or equivalent.
5+ years of experience.

Qualifications

Bachelor's Level Degree (Required).

Working at Fannie Mae

Fannie Mae is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, religion, sex, national origin, disability, age, sexual orientation, gender identity/gender expression, marital or parental status, or any other protected factor. Fannie Mae is committed to providing reasonable accommodations to qualified individuals with disabilities who are employees or applicants for employment.

Apply Now