Talent.com
Teradata / Informatica Business Analyst

Teradata / Informatica Business Analyst

Talent Search Recruitment - IndonesiaKuala Lumpur, Kuala Lumpur, Malaysia
30+ hari lalu
Penerangan pekerjaan

About the job Teradata / Informatica Business Analyst

Mission Consultancy Services is looking for an experienced, Business Analyst who has significant experience in Teradata and Informatica Projects. Previous experience in Banking and Financial Services is a plus. The successful candidate will have experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.

Responsibilities

  • Gathering of requirements from various systems business users.
  • Communicating with the business users to understand business requirements clearly.
  • Conducting meetings with the data architects to understand the source system elements.
  • Consult with business stakeholders to understand and evaluate current business processes and identify complex business problems and needs, turning those needs into system requirements.
  • Provide support to other developers in accurately mapping source attributes into the Teradata Financial Services Logical Data Model (FSLDM) and in interpreting business requirements.
  • Work closely with the Data Modeler and Data Architect in enhancing the FSLDM.
  • Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
  • Implemented logical and physical data modeling with techniques using Erwin in Data Mart.

Skilled required

  • Minimum 5 years - Experience in Designing, Developing & Managing Data Warehousing Applications (Informatica and Teradata).
  • Solid understanding of relational databases.
  • Previous experience in creating Source to Target Mapping Data documentation. Develop understanding of data models of various source systems and their relationships.
  • Experienced in writing Design Documents, System Administration Documents, Test Plans & Test Scenarios / Test Cases and documentation of test results.
  • Experienced in Designing and Preparing Training Material and Conducting Training Sessions to the users.
  • Good understanding of Teradata architecture, FSDLM, Stored Procedures & its Load Utilities.
  • Hands on experience in designing, building & monitoring ETL processes using Informatica.
  • Expert in writing complex SQL queries to automate jobs in Teradata.
  • Integrate data from multiple sources into one database system to streamline information.
  • Isolate and resolve issues with data and databases and make sure final tables are easily accessible and database performance is optimized.
  • Optimize the system performance using best ETL / Database practices.
  • Hands on experience analyzing, optimizing and combining large datasets from various sources by writing complex queries from multiple sources.
  • Adaptable and willing to take on any project with flexibility in dynamic environments.
  • Banking experience with understanding of Hadoop Architecture & its framework is preferred.

    • Required Education

    You have a Bachelor’s Degree in Computer Science or equivalent substitute.

    Salary

    As this position is for abroad, salary / package will be based on expat market standards in the base country. Salary Range : INR .

    Working location

    One of the largest banks in Malaysia located in Kuala Lumpur.

    #J-18808-Ljbffr

    Buat amaran kerja untuk carian ini

    Analyst • Kuala Lumpur, Kuala Lumpur, Malaysia