Intelli Search Services logo

PostgreSQL Developer Andheri East Work from Office

Intelli Search Services

4 - 9 years

Mumbai

Posted:4 days ago

Job Description

Position : PostgreSQL Developer

Timings : 12-9PM

5 days work from Office (Monday - Friday)

Job Summary

PostgreSQL Developer

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

    .
  • Good understanding of

    database performance tuning and query optimization

    .
  • Experience with

    ETL/ELT and data integration

    .
  • 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.

contact 9341626895

Skills Required

Stored Procedures Postgresql SQL Queries data migration SQL Triggers SQL Server MSSQL

Learn the skills this job asks for

See your skill gap for Software Developer →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Intelli Search Services logo
Intelli Search Services

RecommendedJobs for You