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.
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
- 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