Technical Architect

Tata Consultancy Services Ltd

College Park, GA

JOB DETAILS
SALARY
$100,000–$132,000 Per Year
SKILLS
Agile Programming Methodologies, Apache HBase, Apache Hive, Apache Pig, Apache Sqoop, Apache ZooKeeper, Business Intelligence, Business Support, CA Workload Automation AE (AutoSys Edition), Cross-Functional, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Documentation, HDFS (Hadoop Distributed File System), Identify Issues, Informatica, Integration Testing, JSON, MapReduce, NoSQL, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Problem Solving Skills, Process Development, SQL (Structured Query Language), Scripting (Scripting Languages), System Test, Technical Writing, Unit Test, XML (EXtensible Markup Language)
LOCATION
College Park, GA
POSTED
30+ days ago

Primary Skill: ETL Informatica Developer

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
  • 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- $100,000-$132,000 a year

About the Company

T

Tata Consultancy Services Ltd