Informatica ETL Developer

Location: Baltimore, Maryland
Date Posted: 05-07-2018
Position:     Informatica ETL Developer
Location:    On-site – Baltimore, MD 21202          
Hours:         Full-Time (40 Hours/Week); The Candidate Must Have the flexibility to work Overtime, including weekends, Holidays, and Off-Hours, as needed.
Start:           June/July Timeframe
 
The Canton Group is a privately held family owned and operated company with a 20-year track record of delivering award-winning web sites, software and digital solutions to Fortune 500 organizations and Government Entities. Located in the trendy waterfront neighborhood of Canton, Baltimore, we are part of a thriving residential and business community with numerous shops, restaurants, parks and other amenities. We are seeking up to four (4) Computer Programmer (Senior) resources to provide Extract, Transform and Load (ETL) design, development and support services for the Maryland Health Benefit Exchange (HBX) system.
 
DESCRIPTION
  • 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.
MUST HAVE:
  • 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.
PREFERRED:
  • 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.
Lindsay Kozlowski
The Canton Group, LLC
Please contact with any questions at: recruiting@cantongroup.com
 
or
this job portal is powered by CATS