Database Developer

Job DescriptionDatabase Development Mandatory* Mandatory hands on experience with Python Scripting preferably on Data Migration scripts* Experience with Python for database automation, scripting, data processing, and API integrations.* Familiarity with relevant Python libraries for database connectivity (e.g., psycopg2, pymongo, snowflake-connector-python* Mandatory hands-on experience with MongoDB: Designing schemas, writing complex queries, performing aggregations, and optimizing performance within MongoDB environments.* In case associate has not worked on MongoDB, familiarity with similar NoSQL Document database (For example Apache CouchDB)* Understanding of NoSQL data modeling patterns and principles (e.g., document-oriented, key-value). PL/SQL Proficiency (Mandatory):* Extensive experience in developing, debugging, and optimizing complex stored procedures, functions, triggers, and packages using PL/SQL.* Strong understanding of relational database concepts, including normalization, indexing, and referential integrity.* Experience with a major relational database system (e.g., Oracle, PostgreSQL, SQL Server). Performance Tuning (Must Have)* Proven ability to diagnose and resolve database performance issues across relational and NoSQL environments.* Expertise in query optimization (e.g., analyzing execution plans, rewriting inefficient queries).* Experience with index tuning, partitioning strategies, and database configuration for optimal performance.* Familiarity with database monitoring tools and techniques. Good to Have Skills - Data Platforms - Snowflake (Must Have):* Strong experience with Snowflake Data Cloud development, including DDL/DML, stored procedures, UDFs, and performance optimization within Snowflake.* Understanding of Snowflake’s architecture (compute, storage, cloud services) and features (e.g., Virtual Warehouses, Zero-Copy Clones, Time Travel, Streams, Tasks).* Experience with data loading/unloading into and out of Snowflake. Apache Iceberg (Preferred):* Practical experience with Apache Iceberg for managing large, high-performance data sets in open table formats.* Understanding of Iceberg’s key features, such as schema evolution, hidden partitioning, time travel, and manifest files.* Experience integrating Iceberg with query engines (e.g., Spark, Presto, Trino) or data lakes. * Design and migration of No SQL Mongo DB in fi nancial domain* Work on PL-SQL queries development, fine tuning and migration* Design and development of Cloud based DWH using Snowflake* Implementation and Roll-out of on prem and cloud-based application development projects* Work on fixing application issues and enhancement items* Mentoring junior developers in the team and identify opportunities for product improvements, implementation of best practices et al.* Work on application troubleshooting, perform root cause analysis as well as address identified issues * Track the project status, issues, risks and updates timely with senior leadership.