Tata Consultancy Services
Overview
Tata Consultancy Services provided pay range. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range : $100,000.00/yr - $125,000.00/yr Direct message the job poster from Tata Consultancy Services Responsibilities
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). 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. 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. 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 NoSQL MongoDB in financial 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. Qualifications
Seniority level: Mid-Senior level Employment type: Full-time Industries: IT Services and IT Consulting
#J-18808-Ljbffr
Tata Consultancy Services provided pay range. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range : $100,000.00/yr - $125,000.00/yr Direct message the job poster from Tata Consultancy Services Responsibilities
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). 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. 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. 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 NoSQL MongoDB in financial 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. Qualifications
Seniority level: Mid-Senior level Employment type: Full-time Industries: IT Services and IT Consulting
#J-18808-Ljbffr