26 Aug
|
People Prime Worldwide
|
Chennai
26 Aug
People Prime Worldwide
Chennai
- Looking for 7+ Years of database development experience and should have min 5+ years of relevant experience
- Proficiency in Snowflake with extensive experience in data warehouse architecture and management
- Expertise in Snowflake: Pipes, Snowpipe, Stored Procedures, Views, Streams, Tasks
- Should be able to perform data related task and analysis in Snowflake cloud DW; SnowPro core certification is preferred
- Expertise in SQL and database development with the ability to write complex queries and optimize database performance
- Strong programming skills in Python including experience with data libraries and frameworks like Pandas, Flask, and Python scripting
- Strong PLSQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.
- Expertise in using Oracle Performance tuning concepts with Oracle hints and EXPLAIN PLAN tool
- Strong experience using SQL and PL/SQL features like Built In Functions, Analytical Functions, Cursors, Cursor variables, Native dynamic SQL, bulk binding techniques and Packages/Procedures/Functions wherever applicable to process data in an productive manner
- Strong understanding of Data Warehousing and Extraction Transformation Loading (ETL)
- Sound understanding of RDBMS (Oracle)
- Should have used Oracle SQL Loader/External File Utilities to load files
- Strong experience using Python or ETL/ELT
- Good to have experience with Snowflake cloud data platform including Snowflake utilities like SnowSQL, SnowPipe, data loading within cloud (AWS or Azure)
- Exposure in Investment Management (Evaluation, Cash Flow, Projections, Analytics)
- Strong written and oral communication skills
📌 Database Developer (Chennai)
🏢 People Prime Worldwide
📍 Chennai