SDET

Fannie Mae • Reston, VA

194d • $107,000 - $139,000 • Remote

About The Position

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. As a valued colleague on our team, you will enhance and/or refine existing applications and systems to meet new technical requirements with support from leadership, and perform data analysis at various stages of projects to ensure development of a quality application.

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 Haves

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

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.

Benefits

• Broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employee's physical, mental, emotional, and financial well-being.
• Eligible to participate in a Fannie Mae incentive program.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Credit Intermediation and Related Activities
• Education Level: Bachelor's degree