Skip to Main Content
← Back to Jobs

.Net SQL Developer

V12 Data Matawan, NJ
  • Expired: over a month ago. Applications are no longer accepted.

Job Responsibilities:

  • Design and develop automation tasks for high volume data processing.
  • Apps development.
  • Automation of many of the jobs we do in-house.
  • Developing front-end and back-end applications.
  • Create database objects such as tables, views, UDFs and UDPs etc
  • Design packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL Server 2012 or later.
  • Responsible for data profiling as well as SQL and database tuning / optimization
  • Analyze the client requirements and design technical solutions based on those requirements.
  • Develop testing and implementation strategy, conduct appropriate functional and performance
  • testing to identify and resolve process bottlenecks and data quality issues
  • Reviewing query performance and optimizing code
  • Designing and coding database tables to store the application’s data
  • Data modeling to visualize database structure
  • Working with application developers to create optimized queries
  • Creating table indexes to improve database performance and apply appropriate index maintenance
  • Participate in the maintenance of data warehouse

Qualifications:

  1. Bachelor’s Degree in Computer Science (CS), Information System (IS), Management of Information System (MIS), Statistics, Analytical Finance, etc.
  2. .Net at least 7+ years of strong experience
  3. MSSQL 2012 with 7+ years of strong experience, SSIS, ETL as well as T-SQL (Transact SQL) stored procedures and triggers
  4. Strong Javascript/Typescript, preferably on AngularJS/Angular, at least with 2+years of experience
  5. Distributed Architecture with cloud based technology, good RESTful services development.
  6. Strong knowledge in Object oriented design and development.
  7. Good understanding of design patterns, refactoring and unit testing & experience.
  8. Go/NodeJS with at least 2+ years of experience
  9. Experience in Linux environment is a plus
  10. Interest in working with complex data sets and leading edge analytic technologies such as machine learning and Power BI
  11. Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints.
  12. Perform daily file import/exporting using SQL Bulk Insert/BCP
  13. Setup ad-hoc or automated data hygiene processes
  14. Troubleshoot file import/export issues
  15. Troubleshoot existing SQL scripts/tasks
  16. Exhibit excellent analytical, problem solving and troubleshooting abilities
  17. Excellent communication and analytical skills
  18. Ability to work in team environment and client interfacing skills.

V12 Data

Why Work Here?

Great benefits and lots of room to grow.

V12 is the leader in providing marketers omnichannel data to power right time connections. Our depth and breadth of marketing data, technology capabilities, and innovative products coupled with a commitment to helping our clients succeed in the new world of fast data drive our culture and our growth. V12 is one of the leaders in the data and marketing services ecosystem.

Address

Matawan, NJ
USA