Job Description :
Requisition: Sr. Ab Initio Data Integration (ETL) Engineer
Duration: 6+ months, possible extensions
Interview Format: 1st Phone Screen; 2nd In-person (NO SKYPE)
Location: Washington, DC & or Reston, VA
Tasks:
The Ab Initio Data Integration Engineer role will have the following responsibilities:.
· Provide full lifecycle support for the data integration component of the Additional PPO project.
· Generate and maintain system documentation for ETL/DI processes to be developed.
· Develop efficient, high quality data integration code leveraging the most relevant features of Ab Initio.
· Assist with troubleshooting of system and application performance related issues and recommend fixes.
· Other duties as assigned.
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.
· 3+ 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 closely with others, to work through design challenges, and to solve problems.
· Proven ability to work both independently and in groups as a self-motivated and highly engaged contributor.
· 1+ years of experience with database management and Big Data technology, preferably including Cloudera and IBM DB2.
· 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