Create and maintain optimal Database / DWH / Datamart architecture, which may include:
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Informatica, SQL and related technologies
• Identify, design and implement internal process improvements.
i) Automating manual processes
ii) Optimizing data delivery
iii) Re-designing infrastructure for greater scalability
• Work with stakeholders to identify business needs and build/maintain Datamart
Participate in project and assist the user PM on the followings:
• To coordinate with IT and stakeholders on the completion of the UAT
• To create test cases/ test script
• To conduct UAT testing and post implementation phase