Software Developer

Tata Consultancy Services; Plano (TX); On-site; USD 90,000 - 145,000; Full time

Job summary

Tata Consultancy Services is seeking an ETL Informatica Developer in Plano, Texas. This role requires a minimum of 10 years of ETL experience, deep understanding of various data technologies, and proficiency in SQL/PLSQL.

The ideal candidate will collaborate cross-functionally to integrate data, design data warehouses, and ensure data quality. The salary range is $90,000 to $145,000 per year depending on experience and expertise.

Qualifications

• Minimum 10 years of experience in ETL development.
• Proficient in SQL/PLSQL for data manipulation.
• Experience with data modeling techniques.

Responsibilities

• Integrate data from various sources ensuring quality.
• Design and maintain data warehouses for BI activities.
• Optimize SQL queries for better performance.

Skills

ETL

Informatica

SQL

Agile Methodology

NoSQL

Data Warehouse Design

Performance Optimization

Data Quality

Education

Bachelor of Computer Science

Tools

Bit-Bucket

Autosys

Job description

Job Description

Primary Skill: ETL Informatica Developer
Secondary: Oracle, SQL
Experience: Minimum 10 years

Roles & Responsibilities

• 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.

Salary Range

$90,000-$145,000 a year

Qualifications

BACHELOR OF COMPUTER SCIENCE