MS SQL Developer

Job Title: MS SQL Developer

Locations: NJ and TX USA :: Hybrid

*Manager anticipates extending position through December 2024.

Locations:

1. 999 West main street, Freehold, NJ

2. 600 Hidden Ridge, Irving, TX

***NO REMOTE CANDIDATES. Will need to work 2 days a week in office ( Tuesday & Thursday). The work in office may increase up to three days based on management decision which contractor will need to follow.

MUST HAVE SKILLS (Most Important):

• Minimum 10 years of MS SQL server T SQL development experience with SQL utilities (Backup, replication, SSIS etc )
• Proficient in understanding and create complex SQL queries
• Experience in Agile development using Jira
• Experience of version control practices and procedures (GIT)
• Some Teradata development experience with ETL and Teradata utilities (BTEQ, MLOAD, FLOAD, FAST EXPORT)
• Experience in Unix shell scripting

DESIRED SKILLS BUT NOT MANDATORY:

• Experience in any reporting tool set like Qlik or Tableau

EDUCATION/CERTIFICATIONS:

• Bachelor or Master’s degree in computer science/information technology or relevant engineering field with minimum 8 to 10 years of experience
• Documentation: Possess strong oral and written communication skills, including ability explain complex concepts simply. Can communicate effectively across with higher management and to audiences of varying technical prowess. Ability to clearly and simply organize information that conveys a story using PowerPoint.
• Strategic Planning/Vision: Ability to define the future state, as well as identifying the path to get there.
• Problem Solving: Ability to investigate and solve complex technical problems and data discrepancies. Ability to develop solutions that align tactical solutions with strategic goals.
• Self-Starter: Able to work independently, and multi-task under short deadlines, based upon general directions.
• Candidate will work in a team spread around multiple locations and expected to be a good team player within global setting

-Strong TSQL experience in MS SQL server.

-This is developer position. Experience in Teradata is major plus factor for this position but not mandatory.

JOB DUTIES: Position will be responsible specific to

• Research complex MS SQL/Teradata programs and address data issues
• Provide batch application support
• Create and Enhance MS SQL/Teradata components as per project requirements
• Create and Enhance MS SQL store procedures/Teradata BTEQ scripts
• Build new batch processes to load data from different sources
• Work with the onshore and offshore team in application design and build using the technologies defined in the must have skills
• Communicate status of the activities effectively with management or clients