Position : PostgreSQL Developer

Timings : 12-9PM

5 days work from Office (Monday - Friday)

Job Summary

We are looking for a PostgreSQL Developer with strong experience in database development, SQL, data migration, ETL/ELT pipelines, and Python automation. The candidate should be able to work on high-volume databases, optimize queries, and support end-to-end data migration and integration projects.

Key Responsibilities

- Design and develop PostgreSQL databases, tables, views, indexes, and database objects.
- Perform MSSQL/SQL Server to PostgreSQL data migration with a focus on data accuracy and integrity.
- Develop and optimize complex SQL queries, stored procedures, functions/UDFs, and triggers.
- Implement data validation, business rules, and transaction integrity.
- Perform query tuning and database performance optimization.
- Develop and maintain ETL/ELT data pipelines for high-volume data.
- Work with Snowflake, including external stages, storage integrations, COPY INTO, and Snowpipe.
- Develop Python scripts using Pandas and database connectors for data extraction, transformation, file staging, validation, and reconciliation.




- Perform source-to-target data validation and reconciliation during migration.
- Troubleshoot database, SQL, migration, and pipeline issues.
- Work with application developers, data engineers, DevOps, and other technical teams.
- Maintain technical documentation for database development, migration, and integration processes.

Required Skills

- Strong hands-on experience in PostgreSQL.
- Strong knowledge of SQL and PL/pgSQL.
- Experience in MSSQL to PostgreSQL migration.
- Experience with Stored Procedures, Functions/UDFs, Triggers, Views, and Indexes.
- Positive understanding of database performance tuning and query optimization.
- Experience with ETL/ELT and data integration.
- Hands-on experience with Python and Pandas.
- Experience with Snowflake and data loading processes.
- Good understanding of data validation, reconciliation, and data integrity.
- Ability to work with large-volume data and production databases.

Good to Have

- PostgreSQL backup and restore.
- Replication, WAL, HA/DR.
- pg_dump and pg_restore.
- Git, CI/CD, Docker, or DevOps exposure.

📌 PostgreSQL Developer Andheri East Work from Office (Mumbai)
🏢 Intelli Search Services
📍 Mumbai