Teradata & Informatica Data Warehousing Analyst

Talent Search Recruitment - Indonesia; Kuala Lumpur; On-site; MYR 109,000 - 145,000; Full time

Job summary

Mission Consultancy Services is seeking an experienced Teradata/Informatica Business Analyst in Kuala Lumpur, Malaysia. The role focuses on gathering requirements, analyzing business processes, and designing data solutions using Teradata and Informatica.

The candidate will interact with users, document requirements, and develop design specifications. The position requires extensive experience with ETL processes, data modeling, and SQL development.

Qualifications

• Minimum 5 years of experience designing, developing and managing Data Warehousing applications.

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.
• Provided support to other developers in mapping source attributes into the Teradata FSLDM and interpreting business requirements.
• Worked with the Data Modeler and Data Architect in enhancing the FSLDM
• Developed scripts for loading data into base tables in EDW using FastLoad, MultiLoad and BTEQ
• Implemented logical and physical data modeling with Erwin in Data Mart

Education

Bachelor’s Degree in Computer Science

Tools

Teradata

Informatica

Erwin

FastLoad

MultiLoad

BTEQ

Job description

Mission Consultancy Services is seeking an experienced Teradata/Informatica Business Analyst in Kuala Lumpur, Malaysia. The role focuses on gathering requirements, analyzing business processes, and designing data solutions using Teradata and Informatica.

The candidate will interact with users, document requirements, and develop design specifications. The position requires extensive experience with ETL processes, data modeling, and SQL development.