Job Summary:We are seeking an experienced Data Warehouse Lead with strong expertise in SQL stored procedure development, relational data modeling, AWS Aurora PostgreSQL, and Informatica. The role involves leading data warehouse design, optimization, and performance tuning initiatives while ensuring high-quality, scalable data solutions.
Key Responsibilities:- Design, develop, and optimize complex SQL stored procedures.
- Develop and maintain relational data models for enterprise data warehouse systems.
- Work with AWS Aurora PostgreSQL for database development and administration.
- Perform SQL performance tuning and query optimization.
- Design, develop, and maintain ETL workflows using Informatica.
- Ensure data integrity, scalability, and reliability across warehouse environments.
- Troubleshoot performance bottlenecks and resolve database-related issues.
- Collaborate with cross-functional teams to define data requirements and solutions.
- Support database administration tasks and best practices.
Required Skills & Experience:- Strong SQL stored procedure development expertise.
- Strong relational data modeling experience.
- Hands-on experience with Amazon Aurora PostgreSQL.
- Strong SQL performance tuning skills.
- Experience with Informatica PowerCenter.
- Experience with Microsoft SQL Server 2019.
- Strong knowledge of Database Administration (DBMS) concepts.
- Experience working in enterprise data warehouse environments.
Competencies:- Strong analytical and troubleshooting skills.
- Leadership capability in data warehouse initiatives.
- Ability to work onsite and collaborate effectively with stakeholders.
- Performance optimization mindset.
- Strong communication and documentation skills.
Preferred Skills:- Experience in cloud-based data warehouse environments.
- Exposure to AWS ecosystem services.
- Experience leading small technical teams.
