Location: Hartford, CT or St. Paul, MN or Hunt Valley, MD (Initially 2-3 months Remote)
Duration: Full Time
Job Description
Must have expertise in the following:-
Informatica TDM (Test Data Management)
Good to Have (optional)
Informatica PowerCenter, Power Exchange, IICS
Experience Summary:
Over 5 8 years of experience in IT with extensive specialization on Test data management
4-year degree in a related field (or equivalent experience)
Requirements:
Extensive knowledge in developing TDM solution with Informatica Test Data Management with extensive exposure to Informatica PC, Informatica Power exchange
Strong knowledge in defining the Data masking, data provisioning strategy, building Gold copy repository
Should be able to co-ordinate with Informatica product team on the ticket raised and ensure faster closure
Excellent analytical skills with strong knowledge on Insurance, Data migration, ETL and BI processes / DW Strong knowledge of Mainframe systems, DB2 & IMS Experience in Agile methodology and Rally Knowledge preferred
Exposure to Testing Life cycle and understand end-to-end data validation for ETL & BI systems Experience in Project management activities
Develops solutions to meet business needs that reflect a clear understanding of the objectives, practices and procedures of the corporation, department and business unit
Understands where to obtain information needed to make the appropriate decisions
Demonstrates ability to break down a problem to manageable pieces and implement effective, timely solutions
Identifies the problem versus the symptom
Manages problems that require involvement of others to solve
Reaches sound decisions quickly
Carefully evaluates alternative risks and solutions before taking action
Optimizes the use of all available resources
Skills :
Strong SQL Knowledge
Good analytical and logical skills in writing SQLs, Stored Procedures and creating Marts/Views in Oracle
A good end to end knowledge in ETL landscape; starting from source system, warehouse, mart and reports
Very strong ETL Concepts and hands-on experience on Informatica Powercenter ETL Tool (Basic & Advanced)
Experience working within a highly-matrixed organization
Strong communication and presentation skills"