Second Menu

Thursday, September 1, 2016

Onsite Interview : Database Developer | San Francisco CA |

We are in need of a strong SSIS database developer for a 6+ mo. contract in San Francisco. Must be local, great communication, hardworking and available to be onsite M-F for the beginning of the project.

Client will be open to some remote after candidate has proven themselves.

 

Position: SSIS Developer

Location: San Francisco, CA

Duration: 6+ mos contract

Qualifications:

  1. Develop SSIS packages to automate workflow
    1. Stage policy and claims data
    2. Perform lookups and transformation
    3. Configure audit trails
  2. Assist in data migration projects
    1. Effectively communicate with teams to define requirements
    2. Document workflow and field mapping
    3. Design ETL process and follow appropriate development life cycle
  1. T-SQL scripting
    1. Write stored procedures to retrieve data for Tableau reporting and APIs
    2. Ad hoc query
  1. Build relational database to house insurance rates/data
  2. Database source control
  3. Administer AWS servers (database and web) running Server 2012 R2
    1. Monitor server/storage volume status from AWS console
    2. Configure inbound/outbound firewall rules
    3. Maintain/configure OpenVPN access
  1. Maintain SQL Server 2012 instance
    1. Backup and recovery
    2. Promote databases/scripts across environments
    3. Design and maintain indexes
    4. Manage security rules
    5. Manage SQL Agent jobs
  1. Develop SSRS packages

Requirements:

  • Microsoft SQL developer with special expertise in the area of ETL and using SSIS. 
  • San Francisco local that can work in the downtown i3 WeWork office.
  • Preferably younger in age that brings energy and creativity.
  • Skills above and beyond MSQL/SSIS/ETL are a tremendous bonus.

 

logo 

Anupam Amita | Module/Team Lead- Recruitment  | Apetan Consulting LLC

Phone: 201-620-9700 * 107

Email ID: anupam@apetan.com

Mailing Address: 72 Van Reipen Avenue pmb#255, Jersey City, NJ 07306

Corp. Office:  15 Union Avenue, office # 6, Rutherford, New Jersey 07070

Web link:  www.apetan.com

https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.pngcid:image006.jpg@01D16D8B.24928980

Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at remove@apetan.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.

 

 

 

 

--
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment