Job Description :
ETL Developer with Medicare/Medicaid experience
Location: Baltimore, MD | Duration: Long Term
Medicare/Medicaid experience is must. Only Green Card or Citizen.
Minimum 9-10 years ETL experience.

The ETL developer will be responsible for leading ETL design, architecture, and development activities; administering and optimizing the existing Informatica ETL implementation; and providing guidance and operational support. The ETL Developer develops reliable and complex ETL processes to support new development of the Enterprise Master Data Management projects.
Essential responsibilities will include:
ETL architecture, design, development, and implementation.
Supporting the Informatica environment operations, including, but not limited to: automation, job scheduling, dependencies, monitoring.
Coordinating multiple ETL workflows and data load processes and monitoring/administering systems performance, including on-going optimization and tuning of Informatica implementation.
Supporting and enhancing existing Informatica environment and developing new, complex ETL processes to support additional design, development, and deployment of the Enterprise Master Data Management system.
Analyzing and evaluating data sources, data volume, and business rules.
Designing and implementing complex ETL processes.
Comprehensive proficiency with Informatica in a DB2, Oracle Database and mainframe environments.
Very good understanding of Software/System Development Lifecycle methodologies and the ability to successfully deliver Informatica assignments.

Experience with architecture, design, and development of ETL solutions using Informatica, release management, and performance optimization.
Experience with troubleshooting Informatica and database-related performance issues.
Experience in working with Mainframe environments, UNIX, Z/OS scripting.
Experience with Erwin data modeling toolset (good to have)
Expert in database concepts, logical/physical design, and development.
Experience with handling high-volume databases (minimum of 2- 5 TB
Expert in optimizing complex SQL queries (Required)
Strong understanding of Master Data Management, Operational Data Store, and DW/BI concepts. (Required)
5 to 7 plus years’ experience with Informatica software with implementing complex ETL solutions (Required)
Experience with WebSphere MQ with Powercenter/PowerExchange (Required)
Expericene in working with PowerExchange for JMS (good to have)
Experience in working with PowerCenter for WebServices (good to have

Strong organizational skills with the ability to produce and maintain documentation to support activities.
Advanced SQL programming skills.
Excellent verbal and written communication skills.
Health Care Industry and/or CMS experience is a PLUS