Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 17th Dec 2020
Below is the JD:
Top Three Skills
) Experience with Informatica - (standing up environments, designing warehouse, integrating with Powercenter) Experience. Must be very solid with PowerCenter
2) Oracle - Must be able to create data tables
3) Unix
4) Healthcare experience very nice to have
Job Description:-
Create data mapping and workflow using Informatica PowerCenter to extract, transform and load data into the NY APD target reporting environment
• Conform to Informatica workflow and mapping standards so development is consistent across all development resources (i.e., no hard coding, leverage of maplet, reuse concepts, etc.)
• Conduct ETL optimization, troubleshooting and debugging
• Design and develop test plans for ETL unit testing and integration testing
• Tune and optimize ETL jobs for performance and throughput. Interact with data modelers and DBAs on data architecture optimization for ETL performance
• Provide development support, including walk through approvals, to other ETL application resources to insure that standards are followed and optimized workflow is implemented
• Advocate and enforce secure coding principles, as defined by State of New York coding policies, to ensure we are in compliance with all NY standards
• Assist in documenting and maintaining operational procedures in the form of an operations manual for all ETL workflow
• Assist with troubleshooting efforts for ETL job issues related to pre-production and production
• Leverage Informatica Data Quality as a mandatory process step for profiling data prior to downstream transformation
• Assist in designing and developing data validation processes using Informatica Data Quality.
To be considered for this position, applicants need to meet the qualifications listed in this posting.
Required Qualifications: Candidates must be local to Albany NY (NY058)
• 3+ years of experience with Informatica PowerCenter.
• 2+ years of healthcare data experience across Medicaid, Medicare, Exchange or commercial payer environments.
• Experience with Informatica Data Quality.
• Working knowledge of Informatica Test Data Manager
Preferred Qualifications:
• Strong knowledge of HIPAA regulatory security requirements.
• Oracle experience
• Experience with 834, 837, NCPDP transactions
• Knowledge of Informatica Test Data Manager
• Experience with Informatica Data Quality