Develop Informatica workflows to process data from multiple transactional systems according to documented logic and source-to-target mappings
Work directly with Business Analysts, System / Data Architects and lead designing and developing most cost effective solution
Present ETL design and test result to teams and customers to gain confidence
Suggest architecture improvements, design and integration solutions
Conduct analyses of alternatives for different technical solutions and be able to communicate the strengths and weaknesses of each ETL solution
Apply Informatica tool to provide data cleansing, data quality assurance, and PII data masking for testing purposes
Monitor ETL workflows and logging, providing detailed job reports and status
Explore new database and ETL technologies as part of our modernization project.