ETL Developer – Data Integration Specialist

About the role

Join our data warehousing team as an ETL Developer, responsible for designing and maintaining robust data integration pipelines. You will work with Informatica PowerCenter, Python, and Hadoop technologies to deliver high‑performance data solutions.

Key responsibilities

• Design, 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, MapReduce) to handle massive datasets.
• Analyze and tune long‑running Informatica workflows, SQL overrides, memory allocations, and session bottlenecks.
• Implement performance tuning strategies in relational databases, especially Teradata (macros, stored procedures, volatile tables, primary indexes, join strategies).
• Optimize big data storage formats and execution engine resources within Hadoop to maximize throughput.

Required profile

• Minimum 5 years of hands‑on experience in data engineering, data warehousing, or ETL development.
• Proven expertise with Informatica PowerCenter, including advanced transformations and XML parsing.
• Strong programming skills in Python and Unix/Linux shell scripting.
• Experience with Hadoop platforms (HDFS, Hive, Impala, Sqoop) and big‑data processing tools.
• Advanced SQL proficiency; Teradata experience is a plus.
• Bachelor’s or Master’s degree in Computer Science, IT, or a related field.
• Prior experience in the telecom domain is highly preferred.

Required skills

• Informatica PowerCenter
• Python
• Unix/Linux shell scripting
• SQL
• Hadoop ecosystem (HDFS, Hive, Spark, MapReduce, Impala, Sqoop)
• Teradata (BTEQ, FastLoad, MultiLoad, TPT, Volatile Tables)