Description

You will design and implement ETL processes for a large-scale Data Warehouse program, coordinating technical delivery between onsite teams, offshore developers, and customers.

Responsibilities

• Develop ETL strategies and complex SQL queries to support data warehousing requirements.
• Implement data warehousing concepts including schema types, dimensions, facts, and SCD.
• Execute data integration from various sources using Informatica PowerCenter transformations and functions.
• Perform data cleansing, load balancing, partitioning, and pushdown optimization.

Required Skills

• Minimum 5 years of experience with Informatica PowerCenter and Data Warehouse development.
• Expertise in writing and analyzing complex SQL queries.
• Strong experience with ANSI databases such as Teradata, Oracle, or SQL Server.
• Deep understanding of data modeling and data architecture concepts.
• Proficiency in performance tuning and parameterization within ETL workflows.
• Ability to develop algorithms and logic for efficient, error-free data processing.
• Bachelor's degree in a relevant field.

Preferred Skills

• Experience with IICS development or migration.
• Knowledge of Python, APIs, stored procedures, and Unix or batch scripting.
• Familiarity with Data Marts, Data Visualization tools, and BI reporting tools.

Key Skills

Education

Bachelor's degree