Technical Architect

Tata Consultancy Services Limited
Plano, United States of America
16 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 135K

Job location

Plano, United States of America

Tech stack

Agile Methodologies
CA Workload Automation Ae
Data Cleansing
Data Integration
ETL
Data Transformation
Data Warehousing
Database Queries
Hadoop Distributed File System
MapReduce
HBase
Hive
JSON
Job Scheduling
NoSQL
Apache Oozie
Oracle Applications
Parsing
Performance Tuning
PL-SQL
SQL Databases
Sqoop
System Testing
XML
Apache Zookeeper
Apache Yarn
Informatica Powercenter
Spark
Apache Flume
Information Technology
Kafka
Bitbucket
Software Version Control

Job description

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

Requirements

Do you have experience in ZooKeeper?, Do you have a Bachelor's degree?, Secondary: Oracle, SQL Experience: Minimum 10 years Roles & Responsibilities 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, Qualifications : BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

(part of Tata group) 3.93.9 out of 5 stars Plano, TX $100,000 - $135,000 a year

Apply for this position