Data Warehouse Engineer — High-Impact Data Pipelines

Tata Consultancy Services Limited; 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 join our technology team. The role focuses on building and improving datamarts across SQL Server, Oracle, and Hadoop, enforcing enterprise data modeling and integration best practices.

Responsibilities include creating technical specs, testing documents, and collaborating with data modelers and leads to architect solutions within scope and timelines, plus monitoring data pipelines for quality and timeliness.

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

Job description

Tata Consultancy Services in Charlotte, NC is seeking a Data Warehouse Developer to join our technology team. The role focuses on building and improving datamarts across SQL Server, Oracle, and Hadoop, enforcing enterprise data modeling and integration best practices.

Responsibilities include creating technical specs, testing documents, and collaborating with data modelers and leads to architect solutions within scope and timelines, plus monitoring data pipelines for quality and timeliness.