Senior Data Warehouse Engineer - SQL & Hadoop

Tata Consultancy Services; Charlotte (NC); On-site; USD 85,000 - 90,000; Full time

Job summary

Tata Consultancy Services in Charlotte, NC is seeking a Data Warehouse Developer to design, build, and optimize datamarts across SQL Server, Oracle, and Hadoop ecosystems.

Candidates should have 5+ years of data warehouse or data engineering experience, strong SQL skills, and familiarity with Hive and Impala. The role focuses on data quality, performance, and scalable data models.

Join a team delivering enterprise data solutions with adherence to timelines and standards.

Qualifications

• 5+ years of experience as a data warehouse developer or data engineer.
• Experience with data flow data enrichment, transformations SQL ; Hadoop Hive, Impala, Oracle, Microsoft SQL Server
• Ability to optimize database queries for performance and quality.

Responsibilities

• Responsible to build and improve existing datamarts housed in SQL Server, Oracle and Hadoop .
• Candidate will enforce best practices for enterprise data models, integrations, and data warehouse development.
• Candidate will create and maintain technical specifications, unit testing/system testing documents, and work with the data modeler and leads to architect the solutions based on agreed scope and timelines.
• Candidate will support monitoring our data pipelines for data quality and timeliness.

Skills

Data warehouse development

Tools

SQL

Hadoop Hive

Impala

Oracle

SQL Server

Job description

Tata Consultancy Services in Charlotte, NC is seeking a Data Warehouse Developer to design, build, and optimize datamarts across SQL Server, Oracle, and Hadoop ecosystems.

Candidates should have 5+ years of data warehouse or data engineering experience, strong SQL skills, and familiarity with Hive and Impala. The role focuses on data quality, performance, and scalable data models.

Join a team delivering enterprise data solutions with adherence to timelines and standards.