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