What are the responsibilities and job description for the Oracle PL/SQL Developer position at Meritore Technologies?
Addison, TX (Nearby Only As F2F Required)
W2 Candidates
Must have here need Oracle PL/SQL with Data warehousing environment and strong performance tuning, F2F interview required
Pls ask below questions before submitting any candidate:
W2 Candidates
Must have here need Oracle PL/SQL with Data warehousing environment and strong performance tuning, F2F interview required
Pls ask below questions before submitting any candidate:
- Can automate Partition.
- Can insert null value into partitioned column.
- Can create partition on pipelined function.
- Can access pipelined function over DB link.
- What is the pre-requisite to create DB Link.-Diff. b/w local (private/public DB Link).
- Pragma, Dynamic SQL, Local/global index, which index is marked invalid itself. Merge statement, Bulk collect multiset types of collection & differences. Jason & XML transformations.
- SCD (Slowly change dimensions)
- 10 years of experience (in the financial industry) working experience in Data Warehousing environments with very large amounts of data.
- Review the E2E ETL process and apply critical performance tuning skills to optimize the Oracle ETL process and real time operational services;
- Candidates must possess advanced problem-solving skills, analyzing complex data and ability to connect dots to understand data across different systems and multiple claims products, able to work multiple projects assignments concurrently, willingness to self-learn and ability to communicate verbally effectively and concisely and in written/presentable format.
- Candidates must work well in a supportive and transparent team environment, while having the ability to research and resolve issues independently.
- Candidates must have good communication skills and the ability to engage multiple business analysts and developers/dev leads and influence teams across Claims technology and the business.
