Senior ETL Programmer

Location: Baltimore, MD
Date Posted: 05-10-2018
Position Summary:
The Client is seeking a Computer Programmer (Senior) resources to provide Extract, Transform and Load (ETL) design, development and support services for the client Health Benefit Exchange (HBX) system.
 
Duties and Responsibilities:
  • Design, develop, automate, support and monitor performance tuning using Informatica.
  • Develop stored procedures, triggers and functions in SQL in PostgreSQL or other databases.
  • Architect Extract, Transform and Load (ETL) solutions and data conversion strategies for integrating disparate systems.
  • Create data mapping and modelling for data migrations.
  • Create end-to-end solution for ETL transformation jobs that involve writing Informatica workflows and mappings, SQL procedures and functions.
  • Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes.
Required Experience:
  • A minimum of six (6) years of experience in enterprise application analysis and development.  
  • A minimum of four (4) years of hands-on experience in ETL design, development, performance tuning, monitoring and supporting using Informatica.
  • A minimum of two (2) years of hands-on experience in creating complex and efficient SQL queries, stored procedures, triggers and functions.
  • A minimum of two (2) years of hands-on experience in ETL platform administration and integration for performance monitoring and analysis.
  • A minimum of four (4) years of experience as a database developer utilizing SQL.
  • A minimum of four (4) years of hands-on experience using Informatica PowerCenter.
  • Experience in establishing and maintaining reporting databases and data warehouses.
  • Demonstrated ability to manage multiple critical priorities and tight deadlines.
  • Demonstrated analytical and problem solving skills.
 
Education:
Bachelor’s Degree from an accredited college or university in Engineering, Computer Science, Information Systems, Business or other related Discipline.  Master’s degree preferred.
 
Preferred Qualifications
  • A minimum of eight (8) years of experience in developing, maintaining, and enhancing Informatica Mappings, Work-flows, and processes.
  • A minimum of six (6) years of hands-on experience using Informatica PowerCenter.
  • A minimum of four (4) years of experience in architecting ETL solutions and data conversion strategies of disparate systems and create data mapping and modelling for data migrations.
  • A minimum of four (4) years of hands-on experience in ETL design, development, performance tuning, monitoring and supporting using Informatica.
  • A minimum of four (4) years of hands-on experience in creating complex and efficient SQL queries, stored procedures, triggers and functions.
  • A minimum of two (2) years of ETL related experience in HealthCare EDI or Health and Human Services applications.
  • Experience with the State Based Marketplace solutions in Healthcare IT or Health and Human Services domains.
  • Experience in analyzing, converting and transforming EDI transaction sets such as the 834 and 999, IRS datasets such as the H36, H41, 1095-A, 1095-B and SBMI.
  • Knowledge in the Affordable Care Act (ACA) eligibility rules.
  • Experience in quality assurance, quality control and compliance processes of large scale Healthcare IT Systems.
  • Experience working with the Project Management Office (PMO) processes, policies and procedures.
or
this job portal is powered by CATS