DataStage Developer

Tata Consultancy Services; Grand Rapids (MI); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Discretionary annual incentive

Medical coverage

Parental leaves

401K plan

Training reimbursement

Vacation & holidays

Job summary

Tata Consultancy Services in Grand Rapids, MI, seeks an experienced ETL/Data Integration Specialist to design, develop, and maintain IBM InfoSphere DataStage ETL jobs for data warehouses and reporting platforms.

You will optimize ETL processes, perform data mapping, cleansing, validation, and coordinate with business analysts and application teams in an Agile environment. Strong SQL and Unix shell scripting are required.

Qualifications

• Experience designing ETL solutions using IBM InfoSphere DataStage.
• Experience with data warehouses and dimensional modeling.
• Proficiency in SQL (Oracle, SQL Server, DB2) and scripting.
• Ability to validate and reconcile data across loads in Agile environments.

Responsibilities

• Design, develop, and maintain ETL jobs using IBM InfoSphere DataStage.
• Develop data integration solutions for data warehouses and reporting platforms.
• Perform data mapping, transformation, cleansing, and validation.
• Optimize ETL jobs for performance, scalability, and reliability.
• Analyze and resolve production issues and support data loads.
• Collaborate with business analysts, data architects, and application teams.

Skills

ETL Development

Performance tuning

Data validation

Agile/Scrum

Data mapping

Team collaboration

Tools

IBM InfoSphere DataStage

Unix/Linux Shell scripting

SQL

Oracle

SQL Server

DB2

Data Warehousing

Data Modeling

Job description

• SQL and Database Concepts (Oracle, SQL Server, DB2)


• Data Warehousing and Data Modeling


• Performance Tuning and Job Optimization


• Data Validation and Reconciliation


• Design, develop, and maintain ETL jobs using IBM InfoSphere DataStage.


• Develop data integration solutions for data warehouses and reporting platforms.


• Perform data mapping, transformation, cleansing, and validation.


• Optimize ETL jobs for performance, scalability, and reliability.


• Analyze and resolve production issues and support data loads.


• Collaborate with business analysts, data architects, and application teams.

Job Description

• IBM InfoSphere DataStage Development


• ETL Design and Development


• SQL and Database Concepts (Oracle, SQL Server, DB2)


• Data Warehousing and Data Modeling


• Unix/Linux Shell Scripting


• Performance Tuning and Job Optimization


• Data Validation and Reconciliation


• Agile/Scrum Methodology

Roles & Responsibilities

• Design, develop, and maintain ETL jobs using IBM InfoSphere DataStage.


• Develop data integration solutions for data warehouses and reporting platforms.


• Perform data mapping, transformation, cleansing, and validation.


• Optimize ETL jobs for performance, scalability, and reliability.


• Analyze and resolve production issues and support data loads.


• Collaborate with business analysts, data architects, and application teams.

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: Aut& 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-$100,000-$130,000 a year