[外資] 資料庫和ETL開發人員-顧問

我們提供具有競爭力的薪資、全面的福利計劃以及專業增長和發展的機會。如果您是一位高度積極的個人，喜歡在充滿活力和快節奏的環境中工作，請提交您的簡歷和求職信以供考慮。 Job Summary: We are seeking a skilled DB (Database) and ETL (Extract, Transform, Load) Developer with 2-3 years of experience to join our team. The successful candidate will be responsible for designing, developing, and maintaining databases and ETL processes. This role requires a strong understanding of database management systems, ETL tools, and data integration concepts. The ideal candidate should have a proven track record in implementing robust and efficient database solutions and ETL workflows. 職位摘要： 我們正在尋找一位具有2-3年經驗的熟練DB（資料庫）和ETL（資料抽取、轉換、加載）開發人員加入我們的團隊。成功的候選人將負責設計、開發和維護資料庫和ETL流程。該職位需要對資料庫管理系統、ETL工具和數據整合概念有深入的了解。理想的候選人應具有在實施強大高效的資料庫解決方案和ETL工作流方面的成功經驗。 Responsibilities: Design and develop database solutions: Create and maintain database schemas, tables, indexes, and views. Optimize database performance and ensure data integrity. Implement data storage and retrieval strategies for efficient data access. Collaborate with stakeholders to gather database requirements and translate them into technical specifications. Develop and maintain ETL processes: Design and implement ETL workflows to extract data from various sources, transform it according to business rules, and load it into destination systems. Develop data mapping and transformation logic to ensure data consistency and quality. Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner. Perform data validation and reconciliation to ensure accurate data integration. Develop and maintain ETL processes: Design and implement ETL workflows to extract data from various sources, transform it according to business rules, and load it into destination systems. Develop data mapping and transformation logic to ensure data consistency and quality. Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner. Perform data validation and reconciliation to ensure accurate data integration. Data integration and automation: Collaborate with cross-functional teams to integrate data from different systems and sources. Identify and implement automation opportunities to streamline ETL processes and improve efficiency. Develop and maintain data integration interfaces and APIs. Performance tuning and optimization: Identify and resolve performance bottlenecks in databases and ETL processes. Optimize queries and data retrieval to enhance system performance. Analyze and interpret query execution plans to optimize database performance. Documentation and reporting: Create and maintain technical documentation related to database schemas, ETL processes, and data flows. Generate reports and provide insights on data quality, system performance, and data integration 職責： 設計和開發資料庫解決方案： 創建和維護資料庫結構、表格、索引和視圖。 優化資料庫性能，確保數據的完整性。 實施數據存儲和檢索策略，以實現高效的數據訪問。 與利益相關者合作，收集資料庫需求並將其轉化為技術規格。 開發和維護ETL流程： 設計和實施ETL工作流程，從各種來源提取數據，根據業務規則進行轉換，並將其加載到目標系統。 開發數據映射和轉換邏輯，以確保數據的一致性和質量。 監控和解決ETL流程中的問題，及時識別並解決問題。 執行數據驗證和對賬，以確保準確的數據整合。 性能調優和優化： 識別並解決資料庫和ETL流程中的性能瓶頸。 優化查詢和數據檢索，提升系統性能。 分析和解讀查詢執行計劃，優化資料庫性能。 文件記錄和報告： 建立並維護與資料庫結構、ETL流程和數據流相關的技術文件。 生成報告，提供有關數據質量、系統性能和數據整合指標的見解。 Requirements: Bachelor's degree in Computer Science, Information Systems, or a related field. 1-3 years of experience as a DB and ETL Developer or similar role. Strong knowledge of database concepts, SQL, and database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL). 要求： 計算機科學、信息系統或相關領域的學士學位。 1-3年作為資料庫和ETL開發人員或類似角色的經驗。 對資料庫概念、SQL和資料庫管理系統（例如Oracle、SQL Server、MySQL、PostgreSQL）有較深入的了解。 Self-Motivation and Learning: Self-driven individual with a passion for continuous learning and staying up-to-date with industry trends and technologies. 注重細節： 高度注重細節，以確保數據的準確性和質量。 在記錄流程和維護技術文檔方面非常細致。