[Skip to main content](#main-content)

[OpenNash Jobs](https://jobs.opennash.com/)
[Hiring report](/reports/hiring/) · [All Tata Consultancy Services jobs](https://jobs.opennash.com/companies/tata-consultancy-services/) · [Search jobs](/search/)

Tata Consultancy Services · Pittsburgh, PA

# Engineer

Pittsburgh, PA $100,000-$120,000 Operations 

Last seen on Tata Consultancy Services’s official careers site on August 1, 2026; it may have closed since.
[Apply on Tata Consultancy Services’s careers site →](https://ibegin.tcsapps.com/candidate/jobs/425634J)

[OpenNash Jobs](https://jobs.opennash.com/) / [Tata Consultancy Services](https://jobs.opennash.com/companies/tata-consultancy-services/) / Engineer

## Job description

### Skill

ETL Developer Must Have Technical/Functional Skills: Experienced ETL Developer with strong expertise in Informatica PowerCenter, specializing in designing and developing mappings, sessions, and workflows to support enterprise data integration. Skilled in leveraging tools such as Source Analyzer, Mapplet Designer, and Workflow Manager to build efficient data loading processes, monitor execution, and ensure performance reliability.

Proficient in SQL and database design with proven ability to troubleshoot issues, optimize queries, and implement complex transformations including Slowly Changing Dimensions (SCD), delivering accurate and scalable data solutions aligned with business requirements. Roles & Responsibilities

### ETL Methodologies
- Extensively applied ETL concepts to support data extraction, transformation, and loading processes using Informatica PowerCenter.

### ETL Job Design
- Designed and developed PowerCenter ETL jobs to extract data from heterogeneous source systems and load into DB2 Data Marts.

### Business Requirement Analysis
- Collaborated with business analysts to understand processes and translate user requirements into optimized Data Mart solutions.

### Transformations Expertise
- Implemented complex data manipulations using Filter, Expression, Lookup, Aggregator, Joiner, Router, Rank, Sorter, Update Strategy, and Slowly Changing Dimensions (SCD).

### Data Integration
- Processed data from multiple source systems including relational databases and flat files, ensuring seamless integration.

### SCD Type Implementation
- Designed and implemented Slowly Changing Dimension Type methodology to maintain historical data accuracy.

### ETL Mapping & Workflow Design
- Created and optimized mappings in Informatica PowerCenter Designer using Source Analyzer, Mapplet Designer, and Mapping Designer; developed sessions and workflows in Workflow Manager to enable seamless data loading and monitored execution in Workflow Monitor for performance and reliability.

### SQL & Database Expertise
- Demonstrated strong proficiency in SQL queries, database design, and development; performed data processing, identified issues, and implemented solutions to ensure accuracy and efficiency across relational databases. Salary Range - $100,000-$120,000 a year 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.

## Qualifications

BACHELOR OF COMPUTER SCIENCE

## At a glance
- Posted by the employer: Not stated
- First seen by OpenNash: Aug 1, 2026
- Last checked: Aug 1, 2026
- Listed for: Under a day
- Location: Pittsburgh, PA
- Pay: $100,000-$120,000[Apply on Tata Consultancy Services’s careers site →](https://ibegin.tcsapps.com/candidate/jobs/425634J)

## More jobs at Tata Consultancy Services

### [Business Analyst](https://jobs.opennash.com/companies/tata-consultancy-services/jobs/668ad9362766058d5a61/)

Pittsburgh, PA

## Similar jobs at other companies

### [Design Verification Engineer - NPU- Engineer to Sr. Staff Engineer](https://jobs.opennash.com/companies/qualcomm/jobs/0c1dc2a4d468781e22b8/)

Qualcomm · Austin, Texas, United States of America

### [Sonar Engineer/ Acoustic Engineer](https://jobs.opennash.com/companies/lockheed-martin/jobs/83d547a9a4ef976f5770/)

Lockheed Martin · Liverpool, NY

### [Electronics Engineer III, Responsible Engineer](https://jobs.opennash.com/companies/lockheed-martin/jobs/4b87971f4632d20b39c9/)

Lockheed Martin · Littleton, CO

### [Sr Engineer (Systems Engineer)](https://jobs.opennash.com/companies/general-dynamics/jobs/fda6afc828d360978750/)

General Dynamics · Colchester, VT, US

### [Manufacturing Engineer I (Process Engineer)](https://jobs.opennash.com/companies/airbus/jobs/3d2f8c5b91725bb44142/)

AIRBUS · Mobile Area, AL

OpenNash lists jobs from employers’ own careers sites and does not handle applications.
Dates come from the employer where stated; “first seen” and “last checked” are our own observations.

OpenNash Jobs · Official listings with dates and links to the employer. [Weekly hiring report](/reports/hiring/) · [Methodology](/methodology/)