Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

ETL Developer (1093 views)

Raleigh, NC
October 19, 2020

***** Direct Client Requirement*****                     

Title                      :  ETL Developer

Location              :   Raleigh, NC

Rate                     : DOE /If your experience and skills match call us immediately for submission

Duration              : 6+ Months

Interview Type   : Skype or Phone

Work Status       : Successful applicants must be legally authorized to work in the U.S.

Job Type              : C2C,C2H, W2

Experience         : 5+ YEARS

Prefer W2           : U S C/ G C /H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted

Position Overview

The ETL Developer will be responsible for mapping, design, development, unit test and deployment of Extract Transform Load (ETL) processes using SSIS or other tools designated for the purpose.

  • Source to target mapping
  • Writing SQL code using both T SQL and PL SQL
  • Set up ETL OLEDB, flat file and other source and destination connection managers
  • Create various SSIS transformations and tasks as per requirements and best practices
  • Create dynamic file paths, archival paths, for each loops, variables, parameters and expressions
  • Deployments of ETLs between Dev, QA and Prod using SSSI config files and scripts
  • Hands on Experience with deploying, checking in and out, exporting ETL packages using SVN
  • Best practices/standard procedures for SQL, except SSIS
  • Trouble shooting issues with ETL solutions
  • Trouble shooting issues with script tasks using both C# and VB
  • Familiar with different versions of Visual Studio and most recent additions
  • Performance tuning SQL queries and SSIS solutions etc.
  • Strong interpersonal and communication skills, proactive mindset and ability to multitask
  • Enhancing and Automating (as applicable) current manual processes
  • Debugging and monitoring SQL agent, syslogs and audit logs
  • Handled at least 5 TB of data load
  • In depth experience and knowledge about data warehousing methodologies and best practices
  • Experience with generating data/files for front end applications
  • Experience in health care domain, specifically claims, ADT and enrollment data

******Referral Bonus Available: Refer your friends or colleagues, get referral bonus******

Apply here or Please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true
Twitter: https://twitter.com/SohanITInc1

Position Keywords: SQL, except SSIS,ETL,C# and VB

Pay Rate: DOE/If your experience and skills match call us immediately for submission

Job Duration: 6 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 2426

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox