Job Description :
Job title: Oracle Developer
Location: Troy, MI
Duration: 9 + months

Our client is looking for a Oracle Pl/SQL Developer: Troy, MI. Please go through below requirement and let me know if you are comfortable with the requirement.

Position: Oracle Developer
Location: Troy, MI
Duration: 18 Months

Oracle PL / SQL Developer is responsible for developing and maintaining SQL queries and stored procedures to support our client''s Applications development

Responsibility:
Gather requirements, create technical design, document and implement solutions to satisfy
business and development needs.
Understanding and experience in Database/Metadata analysis and design.
Understanding of all phases of the Software Development Life Cycle and process
methodologies.
Knowledge of methods for quality assurance and usability testing for information systems.
High Level proficiency with Oracle skills, working knowledge of stored procedure
development, performance tuning and data warehouses
Develop, Execute and manage Oracle PL/SQL as well as T-SQL stored program units such as
procedures, functions, packages and database triggers.
Develop and maintain system documentation including technical specifications, data
mapping, program logic and flowcharts.
Design and Development of software using primarily PL/SQL batch processing.
Design and Develop test reports using Pl/SQL and Experience with Oracle Streams, Oracle
tuning.
Perform additional duties and projects as assigned by management.
Experience integrating software with existing systems.
Develop and Maintain SQL Queries and Store Procedures
Experience with database design best practices, including normalization, query
optimization, referential integrity and logical database architecture
Ability to quickly understand business requirements and transform user requirements into
queried reports / stored procedures
Defining and utilizing data warehouses and dynamic reporting (including but not limited to
data modeling, ETL architectures, OLAP, drillable reports, star/snowflake schemas, etc)
Dealing with database performance and scaling issues
Using of SCRUM and Agile methodologies for iterative software development
Experience in writing complex SQL and writing Oracle PLSQL programs
Experience with data modeling and designing logical and normalized databases
Experience using source control tools and issue tracking tools
Experience with data extraction, transformation and loading techniques
Experience with data migration/conversion/validation methods
Should have experience working on different triggers at form, block and item level and have
very good knowledge on the sequence of execution of triggers.
Prepare and Execute Unit Test Plan and Unit Test Cases and Use of version control (SVN or
other tools / methodologies)

Thank you,
Kallu,
TechniPros,