Syntricate Technologies
PLSQL Developer
Syntricate Technologies, Quincy, Massachusetts, 02171
Position-PLSQL Developer Duration-Contract Location-North Quincy, MA JD Oracle SQL Queries, PLSQL Development, Performance tuning and Capital Markets Experience is Must SQL, PLSQL Developer, Unix - Extensive experience with Oracle/Exadata SQL, PL/SQL and perform application tuning using various tools like EXPLAIN PLAN, SQLTRACE and AWR Reports. Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) & SGA (System Global Areas) to optimize memory usage. ? Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. ? Experience in Unix/Linux shell scripting. Knowledge of python is desirable.? Implementation experience with monitoring and measurement of data quality using business rules.? Maintain metadata, data glossary and data catalog processes. Ensure adherence to data security by using data encryption procedures and protocols. ? Ability to work in fast paced environment? Experience in Financial Industry with some risk background. ? Knowledge of Agile methodology is desirable ? Experience in Data Modelling - dimensional/reporting, data warehousing and transactional use cases (Physical and Logical modelling) ? Ability to translate architecture and low-level requirements to design and code using SQL ? Scale and optimize performance via schema design, query tuning, and index creation. ? Knowledge of reporting and query tools and practices. Regards, Pallavi Verma Sr. Technical Recruiter | Syntricate Technologies Inc. Direct : 781-552-4333 | Email : pallavisyntricatetechnologies.com | Web: www.syntricatetechnologies.com We're hiring connect with us on LinkedIn nd visit our Jobs Portal Minority Business Enterprise (MBE) Certified | E-Verified Corporation | Equal Employment Opportunity (EEO) Employer This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to unsubscribe .