Talent.com
Developer
DeveloperTata Consultancy Services • Tampa, FL, United States
Developer

Developer

Tata Consultancy Services • Tampa, FL, United States
30+ days ago
Job type
  • Full-time
Job description

Database Development NoSQL Development (Mandatory) :

  • Mandatory hands-on experience with MongoDB : Designing schemas, writing complex queries, performing aggregations, and optimizing performance within MongoDB environments.
  • Understanding of NoSQL data modeling patterns and principles (e.g., document-oriented, key-value).
  • Familiarity with other NoSQL database types and their use cases (e.g., Cassandra, DynamoDB, Redis) is a plus.

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

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

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

    • Programming and Scripting Python (Good to Have) :

  • 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

    • Roles & Responsibilities :

  • Design and migration of No SQL Mongo DB in financial domain
  • Work on PL-SQL queries development, fine tuning and migration
  • Design and development of Cl oud 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.

    • Salary Range- $100,000-$125,000 a year

    #LI-CO1 #LI-SN1

    Create a job alert for this search

    Developer • Tampa, FL, United States