Job ID: MI-107591 (97990809)
Hybrid SAP/Oracle Developer with mainframe migration, data loading/querying/scrambling, scripting, security, PL/SQL, SQL Server, data visualization, testing experience
Location: Dimondale, MI DTMB
Duration: 12+ months
Must be able to come onsite 2x a week to Dimondale location from day 1
Local and Non Local may apply
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
•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.
Role Description:
This position is responsible for special duties on Treasury’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.