Teradata/Informatica Business Analyst

Talent Search Recruitment - Indonesia; Kuala Lumpur; On-site; MYR 5,000 - 7,000; Full time

Job summary

A prominent consultancy service is seeking an experienced Teradata/Informatica Business Analyst in Kuala Lumpur. The role involves gathering requirements, data modeling, and supporting ETL processes. Candidates must have at least 5 years of experience in data warehousing applications, strong SQL skills, and a Bachelor's degree in Computer Science. This position offers a competitive salary based on expatriate market standards.

Qualifications

• 5+ years experience in Designing, Developing & Managing Data Warehousing Applications.
• Expert in SQL query writing for system optimization.
• Experience with Teradata architecture and load utilities.

Responsibilities

• Gather requirements and analyze client business processes.
• Develop scripts for loading data using Teradata utilities.
• Collaborate with stakeholders to ensure accuracy in requirements.

Skills

Data Warehousing Development

SQL Query Writing

Informatica ETL Processes

Relational Databases

Business Analysis

Education

Bachelor's Degree in Computer Science

Job description

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 108675-144900.

Working location

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