Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Administration SSIS ETL Developer VB Script QA Developer
(Jobs in Ontario, CA)
 
Requirement id 62664
Job title Developer
Job location in Ontario, CA
Skills required Biz Talk Development, SQL, Administration, SSIS ETL Developer VB Script QA
Open Date 17-Jul-2017
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Developer: Biz Talk Development, SQL, Administration, SSIS ETL Developer VB Script QA

Client Info : UHG - OptumRx - Cypress

Job Description :


BizTalk/SSIS Developer/Admin

6 month contract (potential for extension)

Ontario, CA


Client is looking for a BizTalk and ETL developer to join the team.

this resources need to know BizTalk on the Development and Administrative side. (support backups recovery administration and development)


Needs to also be SSIS Developer, ETL Developer, SQL and Oracle, they have a small Biz talk environment but they are looking to expand, 30% biz right now, but again they are looking to grow it,


The Biz talk is the more important and a few years of SSIS but the more the better,


BizTalk / SSIS Developer

Overview:
The BizTalk / SSIS Developer is responsible for managing and supporting the BizTalk interfaces, as well as the creation, support, and administration of ETL processes.

Responsibilities:
•Manage, support, and update BizTalk application that processes electronic medical claims
•Along with other key personnel, ensure the overall data integrity and conformity of the information gathered. Manage data quality tasks through the ETL processes.
•Work with DBA Group, Development Teams, and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.)
•Map Import/Export Files to source system data. Map source data to data warehouse models.
•Develop and test extraction, transformation, and load (ETL) processes.
•Develop and maintain ETL scripts and workflows, SQL queries, VB/C++ script components, schedules, etc. using SVN for version control.
•Understand and maintain appropriate data release documentation and approvals according to company policies and procedures
•Define and capture metadata and rules associated with ETL processes.
•Develop processes to identify and analyze data quality issues and recommendations to resolve.
•Document, including diagrams, the architecture and components of the Reporting data warehouse.
•Modify existing ETL processes to improve performance and adapt to changing requirements.
•Use SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issues.
•Perform daily review of production data processes to ensure successful completion
•Provide expertise in the review and correction of data integrity and / or reporting issues
•Review, understand, and provide feedback on functional requirements from a database perspective
•Provide data analysis/troubleshooting/creation support to QA, Developers, Support and others allowing them to complete their assignments.
•Develop, test, and debug new functionality, and maintain/enhance existing functionality in using SQL, stored procedures and APIs
•Will ensure ETL process and project documentation is updated and current for all release cycles.
•Performs performance tuning of queries and stored procedures.



Qualifications:
•Has 5+ years BizTalk experience managing interfaces to/from various applications and databases
•Has 3+ years SSIS experience
•Design, customize, develop, and test BizTalk services in a multi-tier software systems environment.
•Full understanding of Extract Transform Load (ETL) concepts and technologies
•Full understanding of the processes of data quality, data cleansing, and data governance
•Must be able to clearly communicate in writing and orally to both technical and non-technical teams
•Medical experience preferred


1 resources to be here on site in Ontario, CA, M-F on site,
Interview process, 1 and done web
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 62664 while calling.
 
Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2),
 
 Biz Talk Development job openings in other states
Jobs List

Biz Talk Architect - 4631
Create date: 11-Feb-2021
On-site/Remote:
On-site

Description:

Responsibilities

Are you energetic and enthusiastic, as well as uniquely talented? We have a 30-month project with our client in Albany, NY that requires a BizTalk Architect, Expert

Day-to-Day Tasks include, but not limited to:

Execute full secu.... (This job is for - job Jobs in NY Albany Architect - (in Albany, NY))

Project Manager - NTTJP00019326
Create date: 18-Apr-2019
Start Date :5/28/2019
End Date :05/27/2021
Submission Deadline:4/24/2019

Description:
we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our ability to help our clients sta.... (This job is for - EMR EHR Jobs in NY NewYork Manager - (in New York, NY))

BizTalk Developer - J-11-251-661
Create date: 04-Aug-2017
Start Date : 08/14/2017
End Date : 12/29/2017
Submission Dead Line : 08/09/2017
Description :

Experis is partnered with a national association located in Arlington, VA in need of a BizTalk Developer who is skilled in BizTalk development and infrastructure such that they assist them in further refinin.... (This job is for - JSON Jobs in VA ARLINGTON Developer - (in ARLINGTON, VA))

US-IT Developer/Engineer V - J-11-155-649
Create date: 22-Aug-2016
Start Date : 09/01/2016

End Date : 08/31/2017

Submission Deadline : 08/26/2016

Description :

BizTalk/ FTS/ Web Services

Biztalk development and administration, installation, troubleshooting, configuration and coding, web service orchestration and file transfer/movement. Set direction and provid.... (This job is for - job Jobs in AR CONWAY Engineer - (in CONWAY, AR))

Expert Biztalk Tech Architect- 457436
Create date: 12-May-2016
Description:


This position will build, configure, maintain, monitor and report on the BizTalk platform and TFS SOA Collection, each within a multi-tiered environment.
The SOA BizTalk Administrator will be responsible for deployment and administration of BizTalk and configuration of the SOA Collection within Team Foundation Ser.... (This job is for - Jobs in NC Raleigh Architect - (in Raleigh, NC))
 
 
(Developer: Biz Talk Development, SQL, Administration, SSIS ETL Developer VB Script QA in Ontario, CA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us