Description

Lead data warehouse design, optimization, and performance tuning initiatives in Jersey City, NJ. Own the full lifecycle of SQL stored procedures, relational data modeling, and ETL workflows using Informatica and AWS Aurora PostgreSQL.

Responsibilities

• Design, develop, and optimize complex SQL stored procedures for enterprise systems.
• Develop and maintain relational data models ensuring scalability and data integrity.
• Build and maintain ETL workflows using Informatica PowerCenter.
• 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.
• Ability to work onsite in Jersey City, NJ.

Preferred Skills

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

Key Skills

Education

Any Graduate