Role:Senior SQL Developer

Location:Philadelphia, PA

Summary:

• The Sr. SQL Developer will primarily be responsible for understanding, documenting, and designing processes, system interfaces, and configurations with an emphasis on ETL and EDI processes.
• Specific duties and responsibilities are outlined below. Additional duties and responsibilities may be required as the position evolves.
  

Essential Duties and Responsibilities:

• All essential duties and responsibilities listed below must be performed as assigned and within specified timelines.
  
• Write high-quality source code to provide the required functionality for a given assignment. The source code may be required to be written in COBOL, SQL, CL, or XML.
  
• Create detailed test plans for unit testing and integration testing.
  
• Perform unit and integration testing before launch.
  
• Participate in the creation of functional requirements and technical specifications.
  
• Participate in identifying individual steps and tasks for the creation of an overall project plan.
  
• Evaluate existing source code to reprogram, update and add new features.
  
• Develop and maintain technical documentation to accurately represent the design and functionality of the process.
  
• Create data mapping documentation for system interfaces.
  
• Consult with the users for clarification of functions to be automated, objectives, desired features, report structure, and interface mapping.
  
• Proficient use of AQT (Advanced Query Tool or similar GUI database retrieval tool), RDi (Rational Developer for iSeries), Sequel Viewpoint, Ipswitch WS_FTP Professional (or other FTP Client application), iSeries OS and DB2 relational database concepts.
  
• Participate in general problem definition and resolution activities. Analyze existing system logic and provide practical solutions.
  
• Participate in the application on-call support rotation.
  
• Participate in the data upload responsibilities