Data Warehouse Developer

Unison Consulting Pte Ltd is currently looking for an experienced EDW Developer to join our team. As an EDW Developer, you will be responsible for designing, developing, and maintaining our enterprise data warehouse (EDW) solutions, ensuring the efficient and accurate storage, retrieval, and analysis of data. Responsibilities:

• Design, develop, and maintain the EDW architecture and data models.
• Create and implement ETL processes to extract, transform, and load data into the EDW.
• Collaborate with cross-functional teams to gather requirements and define data integration and reporting needs.
• Perform data analysis and profiling to ensure data quality and integrity.
• Implement data security measures to protect the confidentiality and integrity of the data.
• Optimize performance of the EDW through query tuning and indexing strategies.
• Work with business users to understand their reporting and analytical needs and develop appropriate data structures and models.
• Collaborate with data architects and DBAs to ensure the scalability and reliability of the EDW.
• Document technical specifications and ensure compliance with coding and documentation standards.
• Stay up-to-date with the latest industry trends and best practices in EDW development.

• Proven experience as an EDW Developer or similar role.
• In-depth knowledge of data warehousing concepts and methodologies.
• Strong experience in Teradata and Informatica ETL.
• Excellent SQL along with Oracle and SQL Server.
• Required experience with TD and MDM.
• Strong experience required in AS400 and Linux.
• Strong analytical and problem-solving skills.