Optim Lead Developer

Object Technology Solutions, Inc. (OTSI); Topeka (KS); On-site; USD 80,000 - 100,000; Full time

Job summary

Object Technology Solutions, Inc. (OTSI) located in Topeka, KS is seeking a skilled IT professional to coordinate and implement Optim solutions. This role involves managing requirements, developing test data processes, and ensuring the effectiveness of data masking and SQL implementations.

The ideal candidate will have strong experience in RDBMS, especially with DB2 and SQL Server, and be effective in collaborative environments. This is a long-term project position offering a dynamic work setting.

Qualifications

• Strong experience with designing and implementing data masking jobs.
• Proven ability to work collaboratively within a team environment.
• Effective written and verbal communication skills.

Responsibilities

• Coordinate and manage requirements for implementing Optim solutions.
• Define code migration and management processes for Optim code.
• Oversee Optim Test Data projects and ensure effective testing processes.

Skills

Optim subsetting jobs design and implementation

Optim Data Masking rules

RDBMS development, specifically SQL

DB2, IMS, SQL Server expertise

Distributed software (Optim suite)

Mainframe and distributed systems development

Reading and modifying physical data models

Team collaboration and communication

Tools

Optim

IBM Data Studio

Discovery Studio

Job description

Object Technology Solutions Inc. is dedicated to helping customers around the world leverage IT to empower their business through cost effective services, solutions, and consulting.

Founded in 1999 and headquartered in Overland Park, Kansas, OTSI offers global reach and local delivery to companies of all sizes, from start-ups to Fortune 500s. Through offices across the US and around the world, we provide universal access to exceptional talent and innovative solutions in a variety of delivery models to reduce overall risk while optimizing outcomes; enabling our customers to thrive in a global economy.

Job Description

Location: Topeka, KS

Duration: 6+ Months

Job Responsibilities

• Works directly with project teams coordinating and managing requirements and designs for implementing Optim solutions with project teams
• Understanding of configuration and release management, able to define code migration and management processes for developed Optim code
• Experience in the testing lifecycle, helping testing organizations take advantage of data, improved efficiency, quality and delivery
• Overall coordination of Optim Test Data projects
• Background and experience in Project Management and application delivery
• Develops, maintains and enhances Optim jobs
• Technical resource assuming responsibility for Discovery automating analysis of physical data model relationships and location of fields to mask
• Management, or turnover of, complete physical data models

Qualifications

Required Skills:

• Experience with designing, developing, and implementing Optim subsetting jobs
• Strong knowledge of building Optim Data Masking rules
• Background as RDBMS developer, well experienced in SQL
• Strong expertise in RDBMS; Especially DB2, IMS, and SQL Server
• Experience with the distributed software Optim, Optim Designer, Optim Scheduler, Optim Manager, Optim Connect, IBM Classic Data Architect, IBM Data Studio, Discovery Studio, and Optim on the mainframe
• Programming background in mainframe and distributed systems development
• Competent in reading and modifying physical data models
• Proven ability to work effectively in a team/collaborative environment
• Should have excellent communication and written skills

Activities

• Conduct pilot project on Claims Batch Adjudication process
  • Define and build data test bed
  • Create jobs to reload test data
  • Build compare process
  • Develop processes to add/update data to process more complex claims
• Define and build processes to create a Gold Copy of test data
  • Setup jobs to run on a scheduled basis
  • Build processes to add/update test data to the Gold Copy
• Build refresh jobs to update test environments with Gold Copy
• Define and build data masking jobs
  • Mask Gold Copy
  • Document steps for masking other test data requests
• Build a standard project plan template to use for setting up test beds (subset data) for other systems/projects
  • Steps to follow
  • Check list of deliverables
• Mentor/train resources on Optim functionality.

Additional Information

All your information will be kept confidential according to EEO guidelines.