PL/SQL Developer
Information Technology company
Information Technology company
Albany, NY 12201
W-2 and C2C availableContractContract to Permanent767 views
Albany, NY 12201
ContractContract to Permanent
Questions?
Click to chat now!
This posting has been closed

JOB DESCRIPTION:

Responsible for programming and software development using various programming languages and related tools and frameworks, reviewing code written by other programmers, requirement gathering, bug fixing, testing, documenting and implementing software systems. Experienced programmers are also responsible for interpreting architecture and design, code reviews, mentoring, guiding and monitoring programmers, ensuring adherence to programming and documentation policies, software development, testing and release.

Required Skills and Experience:

Write software programs using specific programming languages/platforms such as Java or MS .NET, and related tools, platform and environment. Write, update, and maintain computer programs or software packages to handle specific jobs, such as tracking inventory, storing or retrieving data, or controlling other equipment. Consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes. Perform or direct revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements. Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic. Write or contribute to instructions or manuals to guide end users. Correct errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced. Conduct trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct. Compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program. Investigate whether networks, workstations, the central processing unit of the system, and/or peripheral equipment are responding to a program's instructions. Prepare detailed workflow charts and diagrams that describe input, output, and logical operation, and convert them into a series of instructions coded in a computer language. Perform systems analysis and programming tasks to maintain and control the use of computer systems software as a systems programmer. Consult with and assist computer operators or system analysts to define and resolve problems in running computer programs. Perform unit testing Assist in system and user testing Fix errors and bugs that are identified in the course of testing.

• Qualifications: 3-7 years of experience (2 years min relevant experience in the role); Bachelor’s degree
• Should be proficient in Software Engineering Techniques, Software Engineering Architecture, Software Engineering Lifecycle and Data Management.
• Should have progressing skills on Business Analysis, Business Knowledge, Software Engineering Leadership, Architecture Knowledge and Technical Solution Design.

Required skills - 4 to 6 years of experience
- Must be proficient in SQL and PL/SQL, with hands-on PL/SQL development on Oracle 11g / 12c
- Must have Design and develop PL/SQL objects and programs, including packages, procedures, functions, triggers, views, materialized views, and indexes
- Oracle utilities like SQL* Loader, Export/Import –Intermediate to Expert level
- Unix Shell Scripting Intermediate level to Expert
- Should have good working experience with AutoSys & cron scheduling tool
- Should have acquired high analytical mindset and have organized troubleshooting abilities
- Will have to work with peers offshore as well as domestic locations and should have very good communication
- Knowledge of best practices when dealing with relational databases
- Proficient understanding of code versioning tools such as {{Git / SVN}}?
- Discuss with customers, analyze, understand and document requirements
- Involvement in designing and coding software components. Fixing defects
- Developing and testing multiple forms of test cases before and after delivery to the client
- Conducting Integration testing
- Coordinating with clients users and performing the requirements analysis
- Preparing workflows and mapping client business processes
- Design and develop database components such as stored procedures, functions,triggers, etc
- Converting the requirements into small programming specifications and coordinating with programmers for application development
- Project status reporting to the steakholders
- Supervise, trains and mentor junior level programmers and new team members to bring them up to speed
Good to Have -
- Any experience on java batch jobs is a plus
- Any main frame experience is a plus
- Any domain knowledge on applications like survey application, accounting application in healthcare domain is a plus
- User of JIRA/rally tool is a plus

Behavioural Skills:
- Excellent communication
- Supervise, trains and mentor junior level programmers and new team members to bring them up to speed

Skills
Skill Proficiency Years Experience Percent Used
PL/SQL
3 - 6100%
SQL
Any100%
ETL
Any75%
Oracle
Any75%
PL/SQL Developer
Any75%
Stored Procedure
Any50%
Triggers
Any50%
.NET
Any25%
Agile Methodology
Any25%
Java
Any25%
Project Management
Any25%
Software Engineer
Any25%
UNIX
Any25%
Related Positions
View all of our positions