Full-Time

Ab Initio ETL Engineer

USM Business Systems

USM Business Systems

501-1,000 employees

Global IT services and staff augmentation

No salary listed

No H1B Sponsorship

Washington, DC, USA

In Person

Local candidate preferred; in-person interview required after phone screen.

US Citizenship Required

Category
Data & Analytics (1)
Required Skills
Bash
SQL
ETL
Linux/Unix
Requirements
  • 5+ years of experience of hands-on work designing and implementing data integration solutions for data warehouse and business intelligence systems
  • 5+ years using, configuring, and tuning industry leading ETL software tools in data intensive, large scale environments
  • 5+ years hands-on design, development and support experience with the Ab Initio product suite using GDE, Co>Operating System and EME. Experience in any of the following is desired: Query>It, Conduct>It, Express>It, Continuous flows, Metadata Hub.
  • 3+ years hands-on experience working in Unix/Linux environment, with proficiency in Unix shell scripting (Korn, Bourne, Awk, Sed, etc.)
  • 3+ years hands-on experience with scheduling tools, preferably, Control-M
  • Strong SQL.
  • Strong ability to effectively communicate (oral presentation) concrete concepts to a variety of stakeholders across business and information technology organizations in a formal and informal manner.
  • Strong writing skills including attention to metadata and definitional detail as well as ability to visually depict concepts to technical and non-technical audiences.
  • Proven ability to work close with others, to work through design challenges, to solve problems, and to mentor and guide.
  • Proven ability to work both independently and in groups as a self-motivated and highly engaged contributor.
  • 1+ years of experience working with Health Insurance (Payer) organizations or a highly related field including knowledge of Health Level-7 (HL7) and / or related Claims, Enrollment, and Benefits Administration industry data models / taxonomies is preferred (not required).
Responsibilities
  • Provide day-to-day maintenance and development support for the FEP Operations Center’s ETL processes for the delivery of Audit control mappings for the Care Coordination Technical Infrastructure (CCTI) data warehouse environment
  • Generate and maintain system documentation for ETL/DI processes developed
  • Assist with troubleshooting of system and application performance related issues and recommend fixes.
  • Other duties as assigned.
Desired Qualifications
  • 1+ years of experience working with Health Insurance (Payer) organizations or a highly related field including knowledge of Health Level-7 (HL7) and / or related Claims, Enrollment, and Benefits Administration industry data models / taxonomies is preferred (not required).

USM Business Systems provides IT services and workforce solutions to Fortune 500 companies and government agencies. It helps clients with digital transformation through services such as IT consulting, application development, cloud computing, data analytics, AI/ML, and cybersecurity, while also offering staff augmentation to supply skilled IT professionals. The company executes projects by delivering both technology solutions and the personnel needed to implement them, including cloud migrations, custom software development, and data-driven operational improvements. Compared with competitors, it combines a broad tech-services portfolio with dedicated staffing capabilities and a long track record since 1999, targeting large enterprises and government clients. Its goal is to enable large organizations to execute IT projects efficiently, transform their technology landscape, and manage technology infrastructure by providing integrated solutions and qualified talent.

Company Size

501-1,000

Company Stage

N/A

Total Funding

N/A

Headquarters

Chantilly, Virginia

Founded

1999

Simplify Jobs

Simplify's Take

What believers are saying

  • Agentic AI demand surge boosts USM's AI expertise contracts.
  • Rapid AI prototyping captures mid-market scalability clients.
  • Production AI security wins regulated healthcare finance deals.

What critics are saying

  • Infosys TCS poach Hyderabad Indore AI staff within 6-12 months.
  • H-1B caps FY2027 cripple US staffing from India 3-6 months.
  • OpenAI March 2026 platform obsoletes USM custom AI engineering.

What makes USM Business Systems unique

  • USM excels in Generative AI transformation for enterprise autonomous workflows.
  • USM specializes in edge-computing for IoT predictive maintenance.
  • USM advances cognitive automation handling unstructured data self-optimization.

Help us improve and share your feedback! Did you find this helpful?

Your Connections

People at USM Business Systems who can refer or advise you

Benefits

Remote Work Options

Health Insurance

Dental Insurance

Vision Insurance

Unlimited Paid Time Off

Flexible Work Hours

Hybrid Work Options

401(k) Retirement Plan

401(k) Company Match

Mental Health Support

Wellness Program

Gym Membership

Phone/Internet Stipend

Home Office Stipend

Conference Attendance Budget

Professional Development Budget

Family Planning Benefits

Fertility Treatment Support

Stock Options

Company Equity

Paid Sick Leave

Paid Holidays

Parental Leave

Adoption Assistance

Childcare Support

Bereavement Leave

Relocation Assistance

Employee Referral Bonus

Tuition Reimbursement

Professional Certification Support

Company News

USM Business Systems
Aug 17th, 2022
Usmsystems received award Award on Jan 1st 22'.

“It is a proud movement and Usmsystems is honored to receive IEDRA’s Award this year.

USM Business Systems
Jul 27th, 2022
Usmsystems launches list of the top software

Herein, Usmsystems has compiled a list of the top software development companies in Austin, TX.

USM Business Systems
Mar 15th, 2022
Usmsystems launches list of trending mobile apps for smart home automation

Herein, Usmsystems has compiled a list of trending mobile apps for smart home automation.