Data Warehouse Analyst Programmer

SAVANT INFOTECH SOLUTIONS PTE. LTD.-Singapore, Singapore

Job Scope

  • Design Extract, Transform and Load (ETL) strategy across multiple data sources using Informatica PowerCenter.
  • Work with other team members to ensure that all system components in various environments are prepared for ETL activities.
  • Develop and execute ETL using Informatica PowerCenter 10.x or higher.
  • Responsible for ensuring the proposed ETL design is aligned with the overall architecture design.
  • Responsible for complying with the ETL processes and standards defined for the projects.
  • Carry out data mapping from source Systems to target Systems for ETL.
  • Conduct testing with Functional and BIA teams to validate the data mapping.
  • Deliver all project documentations that mínimally includes data mapping specifications and test plan.
  • Participate in quality assurance activities and resolve any risks or areas for improvement identified.
  • Participate in the change request process which includes performing impact assessment, development and testing impacting BIA.

Competencies

  • Proficiency in Informatica PowerCenter tools (version 10.x or above).
  • Working knowledge of Oracle Procedural Language (PL/SQL).
  • Ability to communicate and articulate clearly to seek resolution of project issues.
  • Ability to work independently and efficiently, managing timelines and expectations, and producing high quality deliverables (documentation, presentations, research).
  • Good team player who is responsible, meticulous, and resourceful.

Working Experience

Minimum two (2) years of experience in data engineering and data warehouse implementation using Informatica.