Informatica ETL Developer — Tata Consultancy Services, Charlotte, NC

Job Description

Must Have Technical/Functional Skills

Primary Skill: Informatica IDMC Developer

Secondary: Oracle, Hadoop

Experience: Minimum 8 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