Sr SQL Developer in Egg Harbor Township at Spencer's and Spirit Halloween

Date Posted: 9/23/2019

Job Snapshot

Job Description

Come work with us at Spencer's & Spirit Halloween, where you'll be working with the best and brightest colleagues as you help us deliver the most fun experience and product possible to our guests. We're fast-paced and take our work seriously, but we always have a good laugh at the end of the day. Walk through our stores or the halls of our corporate office and you'll see firsthand that we're laidback and irreverent. We're firm believers in being true to YOU, so tattoos and piercings are as common as watercooler convos. Whether it's critiquing our new exclusive costumes or quality testing newly implemented software technology, our teams understand the importance of working collaboratively to challenge status quo and achieve our goals. We keep pushing ourselves to go above and beyond and are looking for top talent to become a part of our team!

We offer the following benefits:

  • 30% discount on merchandise
  • competitive salary
  • career advancement
  • Bonus opportunity
  • an excellent benefits package including Vacation/Sick/Holiday pay, Medical/Dental/Disability/Life and AD&D insurance & 401k.


The Sr. SQL Developer will be responsible for SQL application development, maintenance, and data integration, as well as all ETL functions to integrate with new data sources. This individual must be flexible to perform varying related tasks as the needs arise and be able to work as part of a team in support of operational and project related activities including building software applications utilizing SQL. All SQL will be developed and maintained on an IBM iSeries utilizing GUI tools.

Essential Duties and Responsibilities:

  • Write high-quality source code to provide the required functionality for a given assignment. The source code may be required to be written in 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

Position Requirements:

  • Bachelor's degree (B.A.) from a four-year college or university; or five plus years of related experience and/or training; or equivalent combination of education and experience.
  • 5+ yrs. Complex SQL and embedded SQL required. Must have Senior level SQL Development skills, ability to write SQL Queries, create, tune, and debug SQL Code utilizing complex tables, statements, functions, and joins.
  • Position requires diverse skillset, initially requiring strong traditional iSeries, DB2, and SQL skills but will morph over the coming years into more modern programming technologies such as C#/.net, ETL technologies and possibly additional platforms.
  • Experience with table creation (DDL) and design.
  • Experience with integration testing in the SQL environment.
  • Excellent communication and collaboration skills required.
  • Experience with XSD/XML files is a plus.
  • Demonstrates hands-on experience in full development life cycle of software applications.
  • 3-4 yrs. CL experience on an iSeries is desirable.
  • Experience in Retail and Logistics is desirable.
  • Experience with the following is desirable: WebServices, SEQUEL Reporting Tool, RDi Developer Software, Turnover Change Management software, AQT (Advanced Query Tool), OS/400 Operating System, ROBOT iSeries Scheduler.
  • Able to effectively communicate with technical and non-technical personnel.
  • Must be a self-starter and be able to work either in a team environment or work independently as needed.
  • Able to maintain control in stressful situations and be able to define problems, collect data, establish facts, and draw valid conclusions.
  • Ability to interpret a variety of technical instructions in various forms and dealing with abstract and concrete variables is a must.