Data Warehouse Lead - Informatica & OBIEE Architect

Paradigminfotech; Torrance (CA); On-site; USD 140,000 - 170,000; Full time

Job summary

You will lead design, development, testing and migration to production, and guide report/dashboard development (RPD/OBIEE) while maintaining best practices and internal standards. This is a long-term, on-site engagement requiring local CA consultants.

Qualifications

• 7+ years in ETL, Data Warehousing and SDLC.
• Proficient with Informatica ETL tool (design and development).
• Experience with OBIEE11g is a plus.
• Strong data modeling and star schema design skills.
• Ability to lead design sessions with business and BI teams.
• Knowledge of Data Quality, Metadata, and Data Lineage concepts.
• Experience with large-scale data integration (>7 TB).
• Informatica 9.5.1 and NETEZZA familiarity is desired.

Responsibilities

• Lead ETL architecture, data analysis, and dimensional modeling.
• Gather requirements and create technical design specifications.
• Develop Informatica mappings and workflows, ensure performance.
• Design OBIEE reports/dashboards and manage BI deliverables.

Skills

Informatica ETL

OBIEE11g

Data Modeling

ETL Design

Tools

Informatica 9.5.1

NETEZZA

AutoSys

OBIEE11g

Job description

You will lead design, development, testing and migration to production, and guide report/dashboard development (RPD/OBIEE) while maintaining best practices and internal standards. This is a long-term, on-site engagement requiring local CA consultants.