SAP/Oracle Developer

Job ID: MI-106613 (97990714)Hybrid SAP/Oracle Developer with mainframe migration, data loading/querying/scrambling, scripting, security, PL/SQL, SQL Server, data visualization, testing experienceLocation: Dimondale, MI DTMBDuration: 12+ monthsCandidate Docs: RTR/Resume/Hybrid work attestation (manual/digital sign)Vendor docs: Cover Sheet/1 Level Subvendor formstack formSkills: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•yearsResponsibilities:Software testing in SAP – required 2 yearsCreate mocked up data files – 3 yearsEffective communication skills to coordinate with team about status and issues – required 5Create 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, visualCreate queries for data analysis and profiling.Requirements:Supporting the Department of Treasury, the elected person will need to be fingerprinted in addition tothe State of Michigan background check.Role Description:This position is responsible for special duties on Treasury’s project to replace the legacy mainframe withSAP. Duties include loading data into SAP and modifying data for testing in an interface application. Theanalyst will validate data scrambling in the test databases, write scripts that will create data in interfaceapplications, create mock files for interface data loads, and query Oracle databases to profile currentdata. A strong foundational understanding of querying data, creating programs to create and validatedata, and database structure is required.This person should possess strong attention to detail, follow processes exactly, and precisely followsecurity guidelines. These activities will be done in a fast-paced environment with quick turnaround andhigh pressure.During the interview, a demonstration of writing a basic PSQL query will be required.MIE-RTR-1 (3).doc(Vendor and Candidate Signatures REQUIRED on form); State of Michigan Hybrid Work Environment Attestation (1).docx