Technical Lead - ETL & Data Warehouse Architect

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

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

401K Plan

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services is seeking an experienced ETL Engineer to design, develop, and maintain scalable data pipelines in Charlotte, NC. You will work with Informatica PowerCenter and other tools to ensure data quality and timely delivery for BI initiatives.

Ideal candidates have strong SQL, data modeling, and data warehousing experience, with a focus on performance optimization and collaboration across cross-functional teams.

Qualifications

• Bachelor degree in Computer Science or equivalent.
• Strong ETL and data integration experience required.
• Experience building data warehouses for BI purposes.

Responsibilities

• Design, develop, and maintain ETL processes.
• Integrate data from diverse sources ensuring quality.
• Design and maintain data warehouses for BI needs.
• Optimize data pipelines for performance and speed.
• Identify and resolve issues in ETL workflows.
• Collaborate with cross-functional teams to implement ETL solutions.
• Determine data storage needs and manage storage requirements.
• Implement data cleansing and transformation for quality.
• Utilize SQL to extract, transform, and load data.
• Develop and maintain relational and dimensional data models.

Skills

ETL development

Data integration

Data warehousing

Performance optimization

Troubleshooting

SQL proficiency

Data modeling

Collaboration

Data storage

Data quality

Education

Bachelor of Computer Science

Tools

Informatica PowerCenter

Job description

Tata Consultancy Services is seeking an experienced ETL Engineer to design, develop, and maintain scalable data pipelines in Charlotte, NC. You will work with Informatica PowerCenter and other tools to ensure data quality and timely delivery for BI initiatives.

Ideal candidates have strong SQL, data modeling, and data warehousing experience, with a focus on performance optimization and collaboration across cross-functional teams.