Tester Specialist

Requirements: Financial services, SAS , SQL , identify opportunity for automation, big data , analytical and critical thinker

Years:7+ but Prefer 8+ years

Freddie Macs Single-Family Division is currently seeking a Technical Testing Analyst with a strong business acumen to develop and implement data assets. IDEA team enables Business data across all applications and systems in Single-Family for modeling, analytics and reporting purposes. We work in partnership span across all parts of Single-Family organizations from Product Owner, Data Owner, Business Leadership and IT Partners and play a critical role in several project initiatives and constantly innovate to bring better customer experience with every project engagement.

Responsibilities include:

* Understand the business contexts/ requirements and ensure test cases and test data are developed to meet all data and system execution scenarios.

* Work with development and business requirements analysts to ensure that the business requirements are well understood, and testing strategy is sound, and code is well designed to test business and technical functionality thoroughly.

* Collaborate with team members and interact across organizational lines to meet business objectives.

* Establish good relationship with Data Architecture, Development, Ops and Business Requirements teams. * Functional expertise with a strong technical background.

* Develop test cases, test scripts and perform/execute sit/user acceptance testing for data application projects- manually as well as using automation.

* Facilitate test strategy, planning meetings and drive decisions.

* Works on issues of diverse scope where analysis of situation or data requires evaluation of a variety of factors, including an understanding of current data management trends.

* Have experience manipulating and analyzing large datasets including using statistical software. * Devise solutions that are innovative, thorough, and practicable.

* Works under minimal direction. Independently resolves and develops approach to solutions.

* Cleanse, manipulate and analyze large datasets (Structured and Unstructured data - XMLs, JSONs, PDFs) using Big Data Hadoop platform.

* Under minimal supervision, perform design and operation effectiveness testing of IDEA data sources * Develop programs to generate test data in json and xml format

* Develop automation test scripts using python for data staging validation, Map Reduce Validation and Output Validation

* Develop automation test scripts using python to run regression test cases

* Develop data profiling, deduping logic, matching logic for analysis

* Analyze results of tests, defects tracking and management, report status and recommendations for modifications to test plan and/or schedule.

* Document test execution, ensuring that all appropriate risks are identified and documented.

* Contribute to a team of experienced and junior staff that executes testing activities

* Perform IDEA testing per plan and complete follow-ups to ensure that they are completed timely and aligned with the corporate testing standards

* Prepare test reports that identify and communicate issues and recommendations where necessary * Assist with the development and maintenance of detailed procedures that document test plans and scripts

* Collaborating with appropriate groups within IDEA and SF Risk users to ensure timely and appropriate corrective actions are implemented

* Providing senior management with timely status updates and communication of issues

* Programming experience in BigData platform using Hadoop platform.

* Testing large scale and complex data repositories.

* Develop using Python, PySpark, PIG, HIVE scripts to filter/map/aggregate data and engage with other data engineers

* Must be able to handle multiple priorities and meet deadlines

Qualifications

* Bachelors degree in Business Administration, Computer Science, Data Analytics, Information Systems, Finance or a related discipline or equivalent work experience.

* 8 plus years of experience as Business/Data Analyst and overall dynamic experience supporting divisional / enterprise data driven initiatives.

* 8 plus years of data analysis experience, with a combination of business and technical skills.

* 8 plus years of strong SQL programming experience is a must.

* 8 plus years of SAS/Python or similar programming experience.

* Ability to work in a UNIX environment

* 5 or more years of Testing experience within the financial services industry

* 5+ years of experience in processing large volumes and variety of data (Structured and unstructured data, writing code for parallel processing, XMLS, JSONs, PDFs)

* 3+ years of programming experience in Hadoop, Spark, Python for data processing and analysis.

* 5 plus years of experience analyzing structured and semi-structured data sets. Develop Python, PySpark, Spark scripts to filter/cleanse/map/aggregate data.

* 4 plus years of data mart/database/ETL experience.

* Experience in Agile methodology and Agile software development environments.

* Strong quantitative, analytical, and problem-solving skills

* Strong knowledge of Data Platforms such as Databases, Non-SQL Data Repositories, Big Data.

* Experience documenting business processes and functions

* Experience with test automation tools

* Experience with test and defect tracking tools such as Hewlett Packards ALM (Quality Center) version 11.0

* Excellent verbal and written communication skills

* Ability to develop effective relationships across the teams.

* Proactive self-starter with good people skills and a strong work-ethic

Preferred Skills

* Familiarity with all phases of testing life cycle such as SIT and UAT

* Knowledge of secondary mortgage market and Freddie Macs business

* Understanding of Loan Origination, securitization, and/or middle and back office functions

* Foundational knowledge on AWS Data Platforms, Artificial Intelligence and Machine Learning.

* Experience working with Version One or JIRA or similar tool.

* Proficiency in MS Word, MS Visio, MS Excel and MS PowerPoint required

Required Skills : Python, SQL, PySpark, Testing
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :QA/SW Tester
Branch Code :DC Metro Commercial

---