onsite
Technical Architect - Tata Consultancy Services (TCS)
Solutions Architect
Seasoned Technical Architect with 10+ years designing and maintaining ETL solutions using Informatica, Oracle, and SQL, plus deep expertise in Hadoop, Spark, and Kafka within Agile environments.
About the role
Key Responsibilities
- Design, develop, and maintain robust ETL pipelines using Informatica PowerCenter and related tools.
- Leverage Hadoop ecosystem components (HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie) to process large‑scale data sets.
- Implement real‑time data streaming and processing solutions with Spark and Kafka.
- Write efficient SQL/PLSQL scripts for data extraction, transformation, and loading, including advanced JSON/XML parsing.
- Collaborate with cross‑functional teams following Agile methodology and manage code versioning with Bitbucket.
Requirements
- Minimum 10 years of hands‑on experience in ETL development, primarily with Informatica.
- Strong proficiency in Oracle databases and SQL/PLSQL programming.
- Extensive knowledge of Hadoop ecosystem tools and big‑data processing frameworks.
- Experience with Spark, Kafka, and NoSQL databases for high‑velocity data pipelines.
- Proven ability to work in Agile teams and use version control systems such as Bitbucket.
Skills
oraclesqlhadoopkafkaagile