About the role
Job Description
Role: Oracle PLSQL,SnowFlake Developer
Location: Offshore – (Chennai or Bangalore)
Who are we looking for?
We are looking for 6+ Years of database development experience with good experience in Snowflake and Strong SQL, .Net experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types.
Technical Skills:
- Looking for 6+ Years of database development experience.
- 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 efficient manner
- Good experience in MRM SQL Conversion.
- 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
- Good to have experience with Snowflake cloud data platform including Snowflake utilities like SnowSQL, SnowPipe, data loading within cloud (AWS or Azure)
- Strong written and oral communication skills
- Excellent problem-solving and quantitative skills
- Demonstrated ability to work as part of a team.
- Investment Management experience in the past
Process Skills:
- Ability to evaluate, analyze, design and implement solutions based on technical requirements.
- Develop and peer review of LLD (Initiate/ participate in peer reviews)
- Strong design and technical skills, ability to translate business needs into technical solutions and able to analyze the impact.
Behavioral Skills:
- Resolve technical issues of projects and explore alternate designs.
- Participates as a team member and fosters teamwork by inter-group coordination within the modules of the project.
- Effectively collaborates and communicates with the stakeholders and ensure client satisfaction.
- Train and coach members of project groups to ensure effective knowledge management activity.
Qualification:
- Somebody who has at least 6+ years of work experience.
- Education qualification: Any degree from a reputed college