PLSQL DeveloperNorth Quincy, MA onsite ContractRole Description:Extensive experience with Oracle/Exadata SQL, PL/SQL and perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE 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 environmentExperience in Financial Industry with some risk background.Knowledge of Agile methodology is desirableExperience 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 SQLScale and optimize performance via schema design, query tuning, and index creation.Knowledge of reporting and query tools and practices.Competencies: ORACLE SQL, PL/SQL, Unix Shell Scripting and text processing tools, Unix / Linux Basics and CommandsRegards,Ashutosh Pasbola Assistant Manager | Syntricate Technologies Inc. Direct: Email: | Web: