Annexa - Washington, DC

posted about 1 month ago

Full-time
Washington, DC
Merchant Wholesalers, Durable Goods

About the position

The Healthcare Informatica ETL Developer will play a crucial role in supporting the Department of Health Care Finance by designing, implementing, and testing ETL processes using Informatica Powercenter. This position requires collaboration with team members to develop efficient workflows and mappings, ensuring data is accurately extracted, transformed, and loaded into target environments. The developer will also provide mentorship to junior developers and troubleshoot issues in various environments, contributing to the overall success of the DC Access System (DCAS).

Responsibilities

  • Create data mapping and workflows using Informatica Powercenter to extract, transform and load data into target environments.
  • Create technical design documents and develop test plans for ETL unit testing and integration testing.
  • Work and interact with functional and integration teams on architecture and design.
  • Tune and optimize ETL batch jobs for performance and throughput.
  • Conform to Informatica workflow and mapping standards for consistent development.
  • Develop ETL workflows and mappings from ODS to Datawarehouse using Informatica Powercenter.
  • Provide development support and mentor junior developers.
  • Assist with troubleshooting ETL batch job issues in production, PreProd, QA, and UAT.
  • Support infrastructure and development teams.

Requirements

  • 9 years of Business Analysis experience
  • 9 years of Software Development Lifecycle experience
  • 9 years of requirements gathering and documentation
  • 9 years of MS Office/PowerPoint experience
  • 8 years of professional experience with Informatica Powercenter 9.X
  • 8 years of professional experience in Oracle Database
  • 8 years of professional experience in SQL Developer
  • 8 years of professional experience in SQL
  • 9 years of professional experience in PL/SQL
  • 9 years of professional experience in Linux and Windows environments
  • 6 years of professional experience in ODS/Datawarehouse concepts
  • 3 years of professional experience in installation, administration, configuration, and monitoring of Informatica Powercenter
  • 5 years of excellent communication and leadership skills
  • 4 years of knowledge/familiarity with Informatica Powercenter HTTP Adapter, JMS Adapter, Webservices Hub
  • 1 year of Microstrategy development experience
  • 3 years of Curam Data Model experience (V6.2)
  • Bachelor's degree in IT or related field or equivalent experience

Nice-to-haves

  • 6 years of professional experience in SOAP WebServices
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service