Job Description :
Role: Informatica / Datawarehouse
Duration: 12 months
Work Location : Marlborough, MA
Relevant Experience : 6-8 (in Yrs)
Technical/Functional Skills:
Experience in developing and maintaining ETL applications, data cleansing functions, load automation, data extraction, data acquisition functions and others
Proficiency with Linux/Unix and ability to write complex shell scripts
Must able to perform Admin activities(code migrations, user creations, password change, security changes)
Proficiency in coding complex SQL logic
Must be able to review and monitor ETL code.
Must understand IPC code and able to troubleshoot in case of any issues.
Experience with heterogeneous databases; Informatica PwC 9+; Informatica on Cloud; Informatica Data Quality; Oracle SQL, PL/SQL
Roles & Responsibilities:
Providing L2 and L3 support, resolve tickets and complete service request within agreed SLAs.
Design, development, testing and deployment of enhancements as required in AMS Model
Co-ordinate with business users and functional analysts to understand and validate requirements for system upgrades and/or enhancements
Monitoring of overnight batches and ensuring batch completion within agreed SLAs
Perform root cause analysis for frequently occurring issues and work with cross-functional teams to ensure quick resolution.
Co-ordinate with business users and functional analysts to understand and validate requirements for system upgrades and/or enhancements.
Perform root cause analysis for frequently occurring issues and work with cross-functional teams / vendor to ensure quick resolution.
Education: BS / MS in Science/Engineering or an equivalent combination of education or experience