ETLData Integration Developer

Strategic Resources International (USA)

Job Location:

Morristown, NJ - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

(ETL ) AND (DATA INTEGRATION ) AND (C# OR PYTHON ) AND(SQL OR SQL SERVER OR ORACLE OR MY SQL )

Design and developETL pipelinesto load data into Data Warehouse
Work with multiplesource systems(RDBMS flat files APIs) and integrate data into staging and DWH layers
HandleLate Arriving Dimensionsusing industry best practices
ImplementChange Data Capture (CDC)mechanisms including scenarios without timestamp columns
Optimizelong-running ETL sessionsand improve performance using partitioning and tuning techniques
Debug and optimizecomplex SQL queriesand ETL workflows
Work withclustered and non-clustered indexes and understandrow store vs column store
Collaborate with business and analytics teams for data validation and reporting needs

Required Skills:

ETLData IntegrationPython

(ETL ) AND (DATA INTEGRATION ) AND (C# OR PYTHON ) AND(SQL OR SQL SERVER OR ORACLE OR MY SQL ) Design and developETL pipelinesto load data into Data Warehouse Work with multiplesource systems(RDBMS flat files APIs) and integrate data into staging and DWH layers HandleLate Arriving Dimensionsusing...