Company Overview

Informica Solutions is an organization dedicated to leveraging data-driven insights for businesses. With a focus on talent tracking and hiring, we use our expertise in data analytics and assessment science to help our clients make informed recruitment decisions. Our commitment is to provide scientific and innovative solutions to enhance HR processes and redefine the human capital landscape. We have a collaborative and forward-thinking work environment that values continuous improvement and professional growth.

Job Overview

We are seeking a skilled PostgreSQL SQL Developer to join our team at Informica Solutions. As a PostgreSQL SQL Developer, you will be responsible for designing, developing, and maintaining PostgreSQL databases and ensuring their performance, availability, and security. This is a mid-level position with 4 to 6 years of experience. The role is full-time and located in Mumbai, Maharashtra, India.

Qualifications and Skills

• 4 to 6 years of experience as a PostgreSQL SQL Developer or similar role.
• Strong knowledge of PostgreSQL databases and related concepts.
• Proficiency in creating and optimizing database schemas, tables, functions, and triggers.
• Experience in writing efficient SQL queries.
• Understanding of data security principles and implementation.
• Familiarity with tools like ODI, OBIEE, SSIS, and AWS RDS.
• Ability to troubleshoot and optimize database performance.
• Excellent teamwork and communication skills.
• Bachelor's degree in Computer Science or a related field.

Roles and Responsibilities

• Design, develop, and maintain PostgreSQL databases.
• Create and optimize database schemas, tables, functions, and triggers.
• Write efficient and high-performance SQL queries.
• Ensure data security and implement appropriate access controls.
• Optimize database performance and troubleshoot performance issues.
• Work closely with cross-functional teams to understand business requirements and provide technical expertise.
• Collaborate with software developers to integrate PostgreSQL databases with applications.
• Participate in code reviews and provide constructive feedback.
• Contribute to database documentation and best practices.
• Stay updated with the latest trends and advancements in PostgreSQL and SQL technologies.