ETL Developer

We are seeking a highly experienced and strategic ETL Developer with 5+ years of data engineering experience to join our growing data warehousing team.Key Responsibilities1. ETL Architecture & Pipeline DevelopmentDesign, build, and maintain complex end-to-end ETL mappings, workflows, and sessions using Informatica PowerCenter.Develop, optimize, and schedule Python automation scripts for data ingestion, processing, custom transformations, and system monitoring.Architect and scale data integration pipelines within the Hadoop ecosystem (Hive, HDFS, Spark, or MapReduce) to handle massive datasets.2. Performance Tuning & OptimizationAnalyze and tune long-running Informatica workflows, complex SQL overrides, memory allocations, and session bottlenecks.Implement performance tuning strategies in relational databases (especially Teradata macro/stored procedures, volatile tables, primary indexes, and join strategies).Optimize big data storage formats and execution engine resources within Hadoop to maximize throughput.Required Skills & QualificationsTechnical RequirementsETL Expertise: 5+ years of core, hands-on experience with Informatica PowerCenter (including advanced transformations, XML parsing, and SQ overrides).Programming: Strong proficiency in Python for data engineering tasks, alongside advanced shell scripting (Unix/Linux) and SQL is a must.Big Data Ecosystem: 3+ years of experience working with Hadoop platforms (HDFS, Hive, Impala, Sqoop).Relational Databases: Advanced SQL skills. Teradata expertise (including BTEQ, FastLoad, MultiLoad, TPT, and Volatile Tables) is an added advantage.Experience & EducationTotal Experience: Strictly 5+ years in Data Engineering, Data Warehousing, or ETL Development.Domain Knowledge: Prior experience in the Telecom Domain is highly preferred / good to have.Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.