ETL Developer (Informatica/DataStage)

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

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

401K Plan

Performance Bonus

Certification & Training Reimbursement

Vacation & Holidays

Commuter Benefits

Family Support

Job summary

Tata Consultancy Services in Charlotte, NC is seeking a Data Engineer to craft data solutions using Informatica/DataStage, SQL, Python and ETL tools to enhance a Data Warehouse.

You will design and build data pipelines, maintain relational databases such as Oracle Exadata, and collaborate in an agile environment with CI/CD practices.

Applicants should have 8–20 years of experience and a Bachelor of Computer Science, with a strong foundation in data modeling and BI concepts.

Qualifications

• Bachelor of Computer Science degree.
• 8 to 20 years of data engineering/ETL experience.
• Strong SQL and data warehousing concepts.
• Experience with Informatica/DataStage and Python.

Responsibilities

• Craft data solutions to meet business and enterprise requirements using ETL tools.
• Design and build data warehouses and manage data flows.
• Work with CI/CD tools and Unix scripting.
• Collaborate in an agile environment.

Skills

ETL

Informatica/DataStage

SQL

Python

Unix scripting

Education

Bachelor of Computer Science

Tools

Oracle Exadata

Autosys

Jenkins

Ansible

Job description

Job Description

Must Have Technical/Functional Skills

• Primary Skill: ETL
• Secondary: Informatica/DataStage
• Experience: Between 8 to 20 years

Roles & Responsibilities

As a Data Engineer, candidate will be expected to craft data solutions to meet business and enterprise requirements using Informatica/DataStage SQL, Python and ETL Tools to enhance and support a Data Warehouse.

• Strong SQL skills and awareness/experience of good coding practices and ability to articulate such.
• Practical working experience with relational databases, preferably Oracle Exadata.
• Familiarity with Data Warehouse/Data Mart/Data Modeling/Business Intelligence concepts.
• Familiarity with Autosys/Orchestration Tools.
• Exposure/self-education with Unix scripting.
• Exposure/self-education with Python (e.g. Pandas, Data Frames) and use in data processing solutions.
• Exposure to CI/CD processes and tools (e.g. Ansible, Jenkins).
• Experience designing and building data warehouses and knowledge of the data flows involved.
• Willingness to take on problems outside of current skillset and experience.
• Experience with development methodologies and working in an agile framework.

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: $120,000-$130,000 a year

Qualifications

Bachelor of Computer Science