Database Developer

Job Description

Role: Database Developer Location: Offshore – (Chennai or Bangalore) We are looking for 7+ Years of database development experience should have min 5+ years of relevant experience. Strong SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions & User defined data types. Technical Skills: Looking for 7+ Years of database development experience and should have min 5+ years of relevant 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 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 7+ years of work experience. Education qualification: Any degree from a reputed college