SDET - Associate

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 toaffordable housing finance.

Job Description

As a valued colleague on our team, you will enhance and/or refine existing applications and systems to meet new technical requirements with direction from leadership, and perform data analysis at various stages of projects to ensure development of a quality application.

The SDET role will offer you the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following 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 PL/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.
• Design and develop end-to-end automated test frameworks for UI, API, and backend systems.
• Build and maintain robust, reusable, and scalable test scripts.
• Integrate automated tests into CI/CD pipelines using tools like Jenkins, GitHub and GitLab.
• Develop and execute API automation using tools such as Postman, REST Assured, or Karate.
• 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.

THE EXPERIENCE YOU BRING TO THE TEAM
Desired Experiences:

• 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.
• Proficiency in programming languages such as Java and Python.
• 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.
• Bachelor's degree or equivalent

Target Compensation: $83,000-$108,000 a year

SF Technology - Systems Analysis - Associate

#LI-ML1

#LI-Hybrid

Qualifications

Education:
Bachelor's Level Degree (Required)

The future is what you make it to be. Discover compelling opportunities at Fanniemae.com/careers.

For most roles, employees are expected to work onsite on a regular basis at their designated office location. In-office work cadence is determined by your manager. Proximity within a reasonable commute to your designated office location is preferred unless the job is noted as open to remote.

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, unless to do so would cause undue hardship to the company. If you need assistance using our online system and/or you need a reasonable accommodation related to the hiring/application process, please complete this form .

The hiring range for this role is set forth below. Final salaries will generally vary within that range based on factors that include but are not limited to, skill set, depth of experience, certifications, and other relevant qualifications. This position is eligible to participate in a Fannie Mae incentive program (subject to the terms of the program). As part of our comprehensive benefits package, Fannie Mae offers a broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employee's physical, mental, emotional, and financial well-being. See more here .

Requisition compensation:
83000
to
108000