Job Description :
Role: PL/SQL Developer
Location: Charlotte, NC
Duration: Long Term
Responsibilities:
PL/SQL Developer using multiple interfaces.
Document interface requirements - Interview consuming application Business and Technical SMEs, and review current state documents.
Document complex data requirements including business rules, filters etc.
Partner with Subject Matter Experts and End Consumers to source data from multiple data sources and deliver to one or more target applications.
Prepare Source-to-target mapping document.
Satisfy interface requirements - Leverage and/or develop Oracle views, indexes, stored procedures, triggers.
Coordinate Testing of solution with QA teams as well as business partners.
Partnering with appropriate groups to deploy changes into Production.
Support business users with training and knowledge of the new platform.
Report on project status, estimate work requirements, all while managing a variety of distinct initiatives.
Job Requirements:
Oracle 11g/12c, PL/SQL and SQL*LOADER
Unix/Linux command fluency shell scripting
Experience in writing PL/SQL, SQLPlus, stored procedures, triggers, functions, and packages
Informatica/Job Schedulers
Experience with backup/recovery tools
Production support (Autosys, Shell