Description

You will design and build complex data solutions within large-scale data environments.

Responsibilities

• Develop and maintain complex ETL processes using Informatica PowerCenter.
• 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.
• Experience with data warehouse concepts, including Factless Fact Tables and Temporal/Bi-Temporal models.
• Strong understanding of Entity-Relationship (E-R) data models.
• Proficiency in Python.
• Experience with Spark (PySpark) for data loading and transformations.
• Strong analytical and verbal/written communication skills.

Key Skills

Education

Any Graduate