W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    ETL

  • Job Title:

    ETL (SSIS) and SQL Developer

  • Location:

    Huntington Beach,CA

  • Duration:

    7 Months

  • Domain Exposure:

    Healthcare, Insurance, Education, IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

 DUTIES AND RESPONSIBILITIES :

  • Designing and developing (enhancements and maintenance) new ETL and Business Intelligence Solutions using the Microsoft SSIS and SQL Server Relational Database technologies
  • Participate and deliver on new cloud data warehouse project and later work as the main ETL support member after the go-live
  • Monitor production jobs, maintain, and enhance legacy ETL processes on a regular basis. Improve slow running jobs with the help of redesign and better ETL processes to meet business needs
  • Work very closely with the existing DBA to design, model, develop, and maintain existing and new SQL databases objects required for all business solutions.
  • Take directions, follow recommendations, and share status reports to his/her manager

REQUIREMENTS :

  • Over 5 years of experience in developing ETL and Business Intelligence Solutions using SSIS, SSRS, and expertise in designing and implementing Relational Database modelas per business needs
  • Experienced in extracting, transforming and loading ETLdata from excel, flat file. And PDF files. C and C# used for scripting in Script Tasking in SSIS to control the flow of SSIS package
  • Very good working experience of T-SQL. Proficiency in complex stored procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA)
  • Implemented incremental load for many SSIS packages. Experience in error handling, debugging, error logging for production support in SSIS. Experience in bulk importing CSV, XML and Flat files data using Bulk copy program (BCP)
  • Hands on experience in performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes
  • Experienced in normalizing and de-normalizing the tables and maintaining referential integrity by using triggers and primary and foreign keys

Apply Now
Equal Opportunity Employer

DIGITAL TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DIGITAL TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DIGITAL TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract