Technical Testing Analyst

Location: McLean, VA


Responsibilities include:

  • Understand the business contexts 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 sit/user acceptance testing for data application projects.
  • 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
  • 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

  • Bachelor’s 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 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
  • 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

  • Knowledge of secondary mortgage market and Freddie Mac’s 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 excel and PowerPoint required