onsite
Application Software Engineer - Tata Consultancy Services (TCS)
Software Engineer
Seasoned Application Software Engineer with 10+ years of experience designing, developing, 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.
- Implement data ingestion and processing workflows on Hadoop ecosystems (HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie).
- Leverage Spark and Kafka for real‑time and batch data processing, integrating with NoSQL stores as needed.
- Write efficient SQL/PLSQL scripts for data extraction, transformation, and loading, including advanced JSON/XML parsing.
- Collaborate in Agile teams, manage code versions with Bitbucket, and schedule jobs using enterprise scheduling tools.
Requirements
- Minimum 10 years of hands‑on experience in ETL development with Informatica.
- Strong proficiency in Oracle databases and SQL/PLSQL.
- Extensive knowledge of Hadoop components and big‑data processing frameworks (Spark, Kafka).
- Experience working in Agile methodology and using version control systems such as Bitbucket.
- Ability to handle complex data transformations, including JSON and XML parsing.
Skills
oraclesqlhadoopkafkaagile