The Data Warehouse and
ETL Developer is responsible for the architecture, development, and maintenance
of the enterprise data warehouse. This role focuses on building
high-performance data pipelines using Talend, optimizing MS SQL Server
environments, and ensuring seamless data flow between QAD (ERP) and Salesforce
(CRM) using Open Query and API-driven integrations.
Key Technical
Responsibilities
Data Warehousing &
Modeling
Warehouse Architecture: Design
and maintain scalable data warehouse structures (Star and Snowflake
schemas) to support company-wide analytics.
SQL Development: Write and
optimize advanced T-SQL, including complex window functions and CTEs, to
transform raw ERP data into actionable insights.
Database Optimization: Manage
indexing, partitioning, and execution plan analysis to ensure the data
warehouse performs efficiently as data volume grows.
Legacy Connectivity: Expertly
utilize Open Query to extract data from Progress-based QAD/Mfg./Pro
settings into SQL Server.
ETL & Integration
Development
Talend Pipelines: Design,
develop, and deploy Talend ETL jobs to automate the extraction,
transformation, and loading of data from disparate sources.
System Synchronization: Build
and monitor critical integrations between QAD and Salesforce, ensuring
customer, order, and inventory data remains synchronized.
API Integration: Develop Talend
workflows that utilize REST/SOAP APIs to push and pull data from
cloud-based platforms like Salesforce.
Error Handling: Implement
robust logging and alerting frameworks within Talend to proactively
identify and resolve data discrepancies.
Data Governance &
Quality
Data Cleansing: Develop
automated scripts to identify and correct "dirty" data, ensuring
high-quality inputs for Power BI dashboards.
Documentation: Maintain
detailed data lineage documentation, mapping source-to-target
transformations for compliance and audit purposes.
Expertise and Attr
📌 Datawarehouse And Etl Developer Chennai (India)
🏢 Devoir Software Solutions
📍 India
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.