Data Warehouse Lead - W2 only

Title                                      : Data Warehouse Lead

Location                              : Jersey City, NJ / Dallas, TX / Tampa, FL

Duration                             : 12+ months

Relevant Experience (in Yrs.): 8 +

·         Lead the design, development, and optimization of enterprise data warehouse solutions.

·         Develop and optimize complex SQL stored procedures, functions, views, and triggers.

·         Design and implement scalable relational data models (Star & Snowflake schemas).

·         Manage and optimize AWS Aurora PostgreSQL databases.

·         Perform SQL performance tuning (query optimization, indexing strategies, execution plan analysis).

·         Lead ETL/ELT development using Informatica PowerCenter / IICS.

·         Oversee data integration from multiple source systems.

·         Ensure data quality, governance, and integrity across systems.

·         Collaborate with business stakeholders to translate requirements into technical solutions.

·         Guide and mentor junior developers and ETL engineers.

·         Participate in architecture reviews and suggest improvements.

·         Manage deployments, migrations, and production support.

Must Skills:

·         Relational data modeling

·         Amazon Web Services (RDS, S3, IAM preferred)

·         Informatica PowerCenter or Informatica Intelligent Cloud Services.

·         Amazon Aurora PostgreSQL.

·         Advanced SQL development

·         Complex stored procedures

·         Query optimization & performance tuning

Thanks & regards, 

Certified MWBE | WBE | MBE | WOSB | CPUC | E- verify employer 

===