Hyderabad, Telangana
Job Summary

Job Summary We are looking for an experienced ETL SCM Functional Consultant to design, architect, and optimize supply chain data pipelines and enterprise data warehouse solutions. In this role, you will define the functional mapping requirements for complex supply chain data (e.g., procurement, inventory, manufacturing, and order management) and collaborate with data engineers to build reliable, high-performance ETL/ELT processes. Key Responsibilities Data Architecture & Mapping Translate functional supply chain requirements into technical data mapping specifications (Source-to-Target Mappings).Define business logic, data cleansing rules, and transformation rules for core supply chain domains (Procure-to-Pay, Order-to-Cash, Inventory Valuation, Logistics/Shipping).Partner with enterprise architects to design data warehouse schemas (star/snowflake schemas, dimensional modeling) tailored to supply chain metrics. ETL/ELT Design & Validation Collaborate with data engineering teams to review and oversee the development of data pipelines using up-to-date ETL tools (e.g., Informatica, Talend, AWS Glue, dbt) or cloud platforms (Snowflake, BigQuery).Conduct rigorous data validation and functional testing to verify that transformations match underlying ERP logic (e.g., Oracle SCM, SAP S/4HANA).Troubleshoot data discrepancies, pipeline failures, and reconciliation issues between source systems and analytical reports. Analytics & Reporting Enablement Ensure loaded data supports business intelligence (BI) requirements, enabling dashboards for inventory turnover, supplier performance, order fulfillment lead times, and demand forecasting.Partner with business stakeholders to define KPIs and metrics that track supply chain efficiency.

Key Responsibilities

Job Summary We are looking for an experienced ETL SCM Functional Consultant to design, architect,



and optimize supply chain data pipelines and enterprise data warehouse solutions. In this role, you will define the functional mapping requirements for complex supply chain data (e.g., procurement, inventory, manufacturing, and order management) and collaborate with data engineers to build reliable, high-performance ETL/ELT processes. Key Responsibilities Data Architecture & Mapping Translate functional supply chain requirements into technical data mapping specifications (Source-to-Target Mappings).Define business logic, data cleansing rules, and transformation rules for core supply chain domains (Procure-to-Pay, Order-to-Cash, Inventory Valuation, Logistics/Shipping).Partner with enterprise architects to design data warehouse schemas (star/snowflake schemas, dimensional modeling) tailored to supply chain metrics. ETL/ELT Design & Validation Collaborate with data engineering teams to review and oversee the development of data pipelines using modern ETL tools (e.g., Informatica, Talend, AWS Glue, dbt) or cloud platforms (Snowflake, BigQuery).Conduct rigorous data validation and functional testing to verify that transformations match underlying ERP logic (e.g., Oracle SCM, SAP S/4HANA).Troubleshoot data discrepancies, pipeline failures, and reconciliation issues between source systems and analytical reports. Analytics & Reporting Enablement Ensure loaded data supports business intelligence (BI) requirements, enabling dashboards for inventory turnover, supplier performance, order fulfillment lead times, and demand forecasting.Partner with business stakeholders to define KPIs and metrics that track supply chain efficiency.

Skill Requirements
Other Requirements
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-

📌 Technical Lead (India)
🏢 HCLTech
📍 India