Programmer Analyst

07 Aug 2024

Vacancy expired!

Job Title: Programmer Analyst Job Location: Dimondale, MI 48821 Duration: 13 Months Contract Required Skills:

  • Experience with querying databases such as Oracle and SQL Server
  • Ability to create reports, display in visual manner for easy consumption
  • Experience with software testing in SAP
  • Experience creating mocked up data files
  • Effective communication skills to coordinate with team about status and issues
Additional Details: Role Description:
  • This position is responsible for special duties on client's project to replace the legacy mainframe with SAP.
  • Duties include loading data into SAP and modifying data for testing in an interface application.
  • The analyst will validate data scrambling in the test databases, write scripts that will create data in interface applications, create mock files for interface data loads, and query Oracle databases to profile current data. A strong foundational understanding of querying data, creating programs to create and validate data, and database structure is required.
  • This person should possess strong attention to detail, follow processes exactly, and precisely follow security guidelines. These activities will be done in a fast-paced environment with quick turnaround and high pressure.
  • During the interview, a demonstration of writing a basic PSQL query will be required.
Skills:
  • Experience with querying databases such as Oracle and SQL Server required 5 years
  • Ability to create reports, display in visual manner for easy consumption required 5 years years
  • Software testing in SAP required 2 years
  • Create mocked up data files 3 years
  • Effective communication skills to coordinate with team about status and issues required 5 years
Responsibilities:
  • Create and modify test data.
  • Create data files.
  • Validate data has been scrambled using SQL.
  • Consistently provide high quality queries with results in various formats (spreadsheets, visual tables)
  • Create queries for data analysis and profiling.

  • ID: #44674827
  • State: Michigan Dimondale 48821 Dimondale USA
  • City: Dimondale
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2022-08-07
  • Deadline: 2022-10-06
  • Category: Et cetera