Description

Design and implement ETL processes and data warehousing solutions for large-scale environments.

This role is remote.

Responsibilities

• Design dimensional data models, star schemas, and 3rd Normal Form models.
• Develop complex workflows, mappings, and ETL routines using Informatica PowerCenter and shell scripts.
• Lead technical teams through the full system development life cycle (SDLC) and conduct peer code reviews.
• Analyze business requirements, estimate timelines, and prepare technical design documentation.
• Debug production issues, perform performance tuning, and manage the Enterprise Data Warehouse batch cycle.

Required Skills

• 5+ years of experience in data and business intelligence projects.
• Expert-level proficiency with SQL and PL/SQL.
• Extensive experience with Oracle databases.
• Hands-on experience with Informatica PowerCenter.
• Proven experience leading technical teams and medium-sized projects.
• Strong background in designing data warehouses and data marts.
• Ability to elicit requirements and document complex business processes.
• Experience implementing near real-time warehousing solutions and web services.
• Bachelor's degree (BA/BS) or equivalent graduate degree.

Key Skills

Education

Any Graduate