Description

Lead the design, development, and implementation of data warehouse solutions for large financial institutions. Manage medium-sized projects and guide development teams in delivering high-quality ETL solutions.

Responsibilities

• Design dimensional data models, including Star Schemas and 3rd Normal Form structures.
• Develop complex workflows, mappings, and web services using Informatica PowerCenter and shell scripts.
• Perform peer code reviews, testing, and migration of releases into testing and production environments.
• Debug and troubleshoot production issues while supporting the Enterprise Data Warehouse batch cycle.
• Elicit requirements, create design documents, and document business processes for BI projects.

Required Skills

• 10-12+ years of experience in the full system development life cycle (SDLC).
• Expert-level SQL and PL/SQL skills.
• Extensive hands-on experience with Informatica PowerCenter.
• Hands-on experience with Oracle and DB2 databases.
• Expertise in Python, AWS, and data analysis/automation.
• Proven experience leading technical teams and managing BI project work.
• Strong background in designing and implementing data warehouses.

Preferred Skills

• BA/BS degree required.

Key Skills

Education

Any Graduate