DontApply.Club
Login Register

Senior ETL Developer

Software Systems Llc — Oman · Posted ~2 hours ago

Senior

Skills

ETL development Data engineering Informatica PowerCenter Python Hadoop Hive HDFS Apache Spark MapReduce SQL Teradata Performance tuning Data warehousing Data integration Data pipeline development

🔓 Log in to save this job, tailor your resume & track your apply process — 7 days free, no card needed.

Log in to add to target list

Summary ✨ AI‑Generated

A senior ETL Developer is sought to join a growing data warehousing team and design, build, optimize, and maintain complex end-to-end data integration pipelines. The role requires 5+ years of data engineering experience and strong expertise in Informatica PowerCenter, Python automation, SQL, relational database performance tuning, and big data technologies. Responsibilities include developing ingestion and transformation workflows, scaling pipelines for massive datasets, monitoring systems, and optimizing workflow execution, memory usage, database operations, storage formats, and processing resources.

Highlights

Opportunity to work on complex, large-scale data engineering and data warehousing initiatives, including ETL architecture, automation, big data integration, and performance optimization. The role involves technically challenging work with modern data processing technologies and substantial-scale datasets.

Description

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 Responsibilities 1. ETL Architecture & Pipeline Development 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, or MapReduce) to handle massive datasets.2. Performance Tuning & Optimization Analyze 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 & Qualifications Technical Requirements ETL 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 & Education Total 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.