Description

You will design and build complex data solutions within large-scale data environments, owning the ETL lifecycle from ingestion to transformation.

This role is hybrid.

Responsibilities

• Develop and maintain complex ETL processes using Informatica PowerCenter and Apache Airflow.
• Write advanced SQL and PL/SQL queries for complex data analysis and transformation.
• Design and implement stored procedures, triggers, MQTs, and views on IBM DB2.
• Perform performance tuning on DB2 tables, queries, and stored procedures.
• Translate customer business requirements into technical data designs and solutions.

Required Skills

• 5+ years in data development within complex, high-volume data environments.
• 5+ years developing ETLs with Informatica PowerCenter.
• 5+ years proficiency in SQL and PL/SQL for complex querying.
• 5+ years experience developing stored procedures, triggers, MQTs, and views on IBM DB2.
• Proficiency in Python and experience with Spark (PySpark) for data loading and transformations.
• Experience with Snowflake data warehouse platforms.
• Strong understanding of data warehouse concepts, including Factless Fact Tables and Temporal/Bi-Temporal models.
• Strong understanding of Entity-Relationship (E-R) data models.

Preferred Skills

• Strong analytical and verbal/written communication skills.

Key Skills

Education

Any Graduate