Informatica ETL Developer

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

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Family Support

Commuter Benefits

Certification & Training Reimbursement

Time Off

Legal & Financial Assistance

401K Plan

Job summary

Tata Consultancy Services in the United States seeks an experienced Informatica IDMC Developer to join our data integration team. The role emphasizes migration projects, data modeling, and building robust ETL pipelines.

The candidate will work with Oracle, Hadoop ecosystems, SQL/PLSQL, and Autosys for scheduling, ensuring data quality and performance across data warehouses used for BI insights.

Qualifications

• Minimum 10 years of experience in data integration and ETL development.
• Experience in IDMC migration projects.
• Proficiency in SQL/PLSQL and data transformations.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica PowerCenter or other Informatica tools.
• Experience with Agile Methodology and cross-functional collaboration.
• Troubleshoot and optimize ETL performance; ensure data quality and reliability.
• Create technical documentation and perform unit/integration testing.

Skills

Informatica IDMC Developer

Oracle

Hadoop

Education

Bachelor's degree in Computer Science or related field

Tools

Bitbucket

Job description

Job Description

Must Have Technical/Functional Skills

Primary Skill: Informatica IDMC Developer

Secondary: Oracle, Hadoop

Experience: Minimum 10 years

Roles & Responsibilities

• Bachelor’s or master’s degree in computer science or related field.


• Minimum 2 years experience in IDMC migration projects.


• ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.


• Experience in Agile Methodology


• Experience with code versioning tools like Bit-Bucket


• SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.


• Exposure to advanced transformations like data transformations, Parsing JSON/XML messages


• Experience in Job scheduling tools Like Autosys


• Experience with HDFS, MapReduce, and Hadoop ecosystems.


• Understanding data storage and data processing techniques in Hadoop


• 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 SQL script/queries for speed and efficiency.


• Troubleshooting: Identify and resolve issues in ETL processes.


• Documentation: Create and maintain technical documentation for ETL processes.


• Testing: Perform unit, integration, and system testing on ETL processes.


• Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes.


• Data Quality: Ensure data quality by implementing data cleansing and transformation processes.


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

Qualifications

BACHELOR OF COMPUTER SCIENCE