Technical Lead

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

Job Description

Roles & Responsibilities

• ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
• Data Integration: Integrate data from various sources, ensuring data consistency and quality.
• Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities.
• Performance Optimization: Optimize data pipelines for speed and efficiency.
• Troubleshooting: Identify and resolve issues in ETL processes.
• Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes.
• Data Storage: Determine data storage needs and manage data storage requirements.
• Data Quality: Ensure data quality by implementing data cleansing and transformation processes.
• SQL Proficiency: Utilize SQL to extract, transform, and load data.
• Data Modeling: Develop and maintain relational and dimensional data models.

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
• Salary Range: $110,000 - $120,000 a year

Qualifications

• BACHELOR OF COMPUTER SCIENCE