Senior ETL Data Engineer (Ab Initio / Informatica)

Job Title: Senior ETL Data Engineer (Ab Initio / Informatica)
Experience: 4+ Years
Location: Lahore / Karachi / Islamabad (Hybrid)
Job Type: Full-Time

About the Role:

We are looking for a highly skilled Senior ETL Data Engineer (Ab Initio / Informatica) with strong experience in building robust data pipelines, working with large-scale datasets, and leveraging modern Big Data and cloud technologies. The ideal candidate should have hands-on expertise in ETL frameworks, distributed data processing, and data modeling within cloud environments such as AWS. If you have a passion for working with data and enjoy designing scalable systems, we’d like to meet you.

Key Responsibilities:

• Design and develop complex ETL pipelines and data solutions using Big Data and cloud-native technologies.

• Leverage tools such as Ab Initio, Informatica, DBT, and Apache Spark to build scalable data workflows.

• Implement distributed data processing using Hadoop, Hive, Kafka, and Spark.

• Build and optimize data pipelines in AWS using services like EMR, Glue, Lambda, Athena, and S3.

• Work with various structured and unstructured data sources to perform efficient data ingestion and transformation.

• Write optimized SQL queries and manage stored procedures for complex data processing tasks.

• Orchestrate workflows using Airflow, AWS Step Functions, or similar schedulers.

• Collaborate with cross-functional teams to understand data needs and deliver high-quality datasets for analytics and reporting.

• Deploy data models into production environments and ensure robust monitoring and resource management.

• Mentor junior engineers and contribute to the team’s knowledge sharing and continuous improvement efforts.

• Identify and recommend process and technology improvements to enhance data pipeline performance and reliability.

Required Skills & Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or a related field.

• 4+ years of hands-on experience in ETL development, data engineering, and data pipeline orchestration.

• Strong working knowledge of Ab Initio, Informatica, or similar ETL tools.

• Expertise in Python, PySpark, or Scala for data processing.

• Proven experience in Big Data technologies (Hadoop, Hive, Spark, Kafka).

• Proficient with AWS services related to data engineering (EMR, Glue, Lambda, Athena, S3).

• In-depth understanding of data modeling, ETL cycle, data warehousing, and data management principles.

• Hands-on experience with relational (PostgreSQL, MySQL) and columnar databases (Redshift, HBase, Snowflake).

• Familiarity with containerization (Docker), CI/CD pipelines (Jenkins), and Agile tools (Jira).

• Ability to troubleshoot complex data issues and propose scalable solutions.

• Excellent communication and collaboration skills.

Nice to Have:

• Experience with open table formats such as Apache Iceberg.

• Working knowledge of Snowflake and its data warehousing capabilities.

• Familiarity with GDE, Collect > IT, or other components of Ab Initio.

Why Join Us?

• Hybrid work model with flexibility to work from home and office.

• Exposure to cutting-edge technologies and high-impact projects.

• Collaborative team environment with opportunities for growth and innovation.

• Culture that values ownership, continuous learning, and mutual respect.