Data Warehouse & ETL Engineer TASC Outsourcing

Role Summary Design and implement scalable data pipelines to extract, transform, and store data from multiple sources into a structured data warehouse for analytics and reporting. Key Responsibilities • Develop data extraction processes from APIs, files, databases, and other data sources. • Design and manage data warehouse solutions (SQL Server and Oracle). • Perform data cleansing, normalization, and enrichment. • Apply business rules (classification, scoring, transformations). • Optimize data models for reporting and analytics. • Build and maintain ETL/ELT pipelines using tools such as SSIS or ODI or equivalent. • Implement scheduled and incremental data loads. • Ensure performance, scalability, and reliability of data pipelines. • Integrate with enterprise systems. • Support testing, validation, and deployment of data solutions. Requirements • Strong experience in SQL Server and Oracle data platforms. • Hands-on experience with SSIS, ODI, or similar ETL tools. • Experience working with APIs and structured/unstructured data. • Solid understanding of data warehousing concepts (schemas, indexing, aggregation). • Experience handling large data volumes. • Strong problem-solving and data analysis skills.