Description

Lead data warehouse design, optimization, and performance tuning initiatives in Jersey City, NJ.

This role is hybrid.

Responsibilities

• Design, develop, and optimize complex SQL stored procedures for enterprise systems.
• Build and maintain ETL workflows using Informatica PowerCenter.
• Develop and maintain relational data models ensuring scalability and data integrity.
• Perform SQL performance tuning and query optimization on AWS Aurora PostgreSQL.
• Troubleshoot performance bottlenecks and resolve database-related issues.

Required Skills

• 8+ years of experience in data warehouse environments.
• Strong expertise in SQL stored procedure development.
• Hands-on experience with Amazon Aurora PostgreSQL for development and administration.
• Proven experience with Informatica PowerCenter for ETL processes.
• Strong background in relational data modeling.
• Experience with Microsoft SQL Server 2019.
• Deep knowledge of Database Administration (DBMS) concepts.

Preferred Skills

• Experience leading small technical teams.
• Exposure to broader AWS ecosystem services.

Key Skills

Education

Any Graduate