Role: Database Developer
Location: Houston, TX (Hybrid).
Who are we looking for?
We are looking for 8+ Years of database development experience should have min 6+ 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 8+ Years of database development experience and should have min 6+ 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
- Strong experience using Python or Perl
- Good to have experience with Snowflake cloud data platform including Snowflake utilities like SnowSQL, SnowPipe, data loading within cloud (AWS or Azure)- Mandatory.
-
- Exposure in Investment Management (Evaluation, Cash Flow, Projections, Analytics)
- 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