ob SummaryWe 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 ResponsibilitiesData Architecture & MappingTranslate 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 & ValidationCollaborate 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 EnablementEnsure 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.
ob SummaryWe 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 ResponsibilitiesData Architecture & MappingTranslate 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 & ValidationCollaborate 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 EnablementEnsure 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.
HCLTech is a global technology company, home to more than 226,600 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2025 totaled $14.2 billion. To learn how we can supercharge progress for you, visit hcltech.com.
