Developer

Must Have Technical/Functional Skills

Primary Skill: ETL Informatica Developer

Secondary: Oracle, SQL

Experience: Minimum 10 years

Roles & Responsibilities

Bachelor's or master's degree in computer science or related field.

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

Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie.

Experience with Spark, Kafka, NoSQL databases.

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

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