design processes to extract, transform and load the source data into the target data warehouse and ad hoc process Develop complex sequential and parallel Informatica Power Center Perform unit and system testing on the ETL processes and resulting data warehouse /ad hoc tables Create test cases and test the data. Assist with capacity planning and performance tuning activities. Mentor others on the team with product functionality and provide guidelines and solutions on performance tuning techniques and industry best practices. Understanding the existing ETL environment, translating into new environment requirements and planning tasks to meet those requirements.