The salary is $80K. This is not one of those positions where there is an exception. Must be US Citizen or GC Holder, no H1’s
Install, upgrade and patch Informatica components so that the environment remains current
Implement procedures to maintain, monitor, backup and recovery operations of the ETL environment so that the environment is reliable and highly available through time
Define Informatica workflow and mapping standards so that development is done in a consistent manner across all development resources (I,e, no hard coding, leverage of mapplet/reuse concepts…)
Conduct ETL optimization, troubleshooting and debugging
Designs and develops 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
Document and maintain operational procedures in the form of an operations manual for all ETL workflow
Lead troubleshooting efforts for ETL job issues related to pre-production and production
Migration of ETL objects from lower environment to production.
Experience on multiple data sources/targets like (Excel, CSV, Flat file, Oracle, SQL Server and DB2…)
Experience on data masking/de-identification using Informatica.
Experience in the Healthcare industry
