Required Skills

sqlmysqlpostgresql

Job Description

Job Tittle : Database Developer / SQL Migration Developer

2\+ years of experience in stored procedures, functions, views, and complex query development.

**Role Summary :** We are looking for a strong Database Developer with hands\-on experience in writing, analyzing, and converting complex SQL queries, stored procedures, functions, and database transformation logic. The main responsibility of this role is to study existing SQL logic from source databases such as Sybase, Oracle, MySQL, or PostgreSQL and rewrite or convert the logic into Vertica\-compatible SQL, procedures, functions, views, and ELT scripts. Direct Vertica experience is preferred but not mandatory. A candidate with strong SQL, stored procedure, and database development experience can be considered, especially if they are able to understand business rules from existing database code and convert them into clean, maintainable SQL logic.

Analyze existing database procedures, functions, packages, views, and complex SQL queries from various source databases.
Convert and rewrite SQL logic into Vertica\-compatible SQL.
Develop and maintain database views, stored procedures, functions, and ELT transformation scripts.
Transform procedural database logic into efficient set\-based SQL wherever applicable.
Understand and replicate business rules from source systems within the Vertica data warehouse.
Implement data transformation, cleansing, aggregation, validation, and loading processes.
Collaborate with ETL/ELT teams to implement data warehouse transformation requirements.
Validate converted SQL outputs by comparing source and target system results.
Perform unit testing, data reconciliation, troubleshooting, and issue resolution during migration activities.
Document conversion approaches, assumptions, mappings, and technical specifications.
Work closely with DBAs and Vertica specialists to support performance tuning and optimization.

Strong hands\-on experience in SQL development.
Expertise in stored procedures, functions, views, and complex SQL query development.
Experience with one or more databases such as Oracle, Sybase, PostgreSQL, MySQL, SQL Server, Teradata, Greenplum, Redshift, or similar platforms.
Ability to analyze existing database code and convert it to another database platform.
Strong understanding of joins, subqueries, CTEs, window functions, aggregations, temporary tables, and transaction processing.
Experience in data transformation, data cleansing, and ELT/ETL\-related SQL development.
Ability to convert row\-by\-row procedural logic into efficient set\-based SQL.
Good understanding of data warehousing concepts including staging tables, fact tables, dimension tables, ODS, data marts, and historical data management.
Strong troubleshooting skills for SQL errors, datatype mismatches, and platform\-specific logic differences.
Experience validating migrated SQL outputs against source system results.

Pay: From ₹70,000\.00 per month

Work Location: Remote