BI Architect

Location: Pasadena, CA, United States
Date Posted: 12-21-2017
Job Title :BI Architect
Location:  Pasadena, CA​.
Optional Ref#:EGPSJP00003101

Assist the Healthcare BI team in analyzing requirements to design, develop, test and support SSIS packages that implement complex ETL processes
• Design MS SQL Server 2012 SSIS jobs, and reusable components to help KP implement specified business requirements
• Troubleshoot and optimize ETL code; interpret ETL logs, perform data validation, dissect SSIS code, understand the benefits and drawbacks of parallelism, apply best practices using change data capture, expressions, scoping of variables, commonly used transforms, event handlers and logging providers, understand and optimize the surrogate key generation and inconsistent data type handling
• Create technical specifications documents and design process diagrams
 • Develop functional specifications for data acquisition, transformation and load processes
• Develop scripts for data file processing and process integration tasks
• Define job parameters, reference lookups, filter criteria
• Conduct performance analysis and optimize SSIS jobs, custom SQL and T-SQL jobs
• Prepare unit test, integration test plan documents and perform unit test, system integration test; document test results
• Provide technical input for Healthcare Change Requests (CRQs) and Work Orders (WOs) as requested by the KP Sponsor or designated KP SQL Team Project Managers
• Provide weekly residency status reports to the Healthcare sponsor Terms Summary

Central Business Solutions, Inc,
37600 Central Ct.
Suite #214
Newark, CA 94560.
Central Business Solutions, Inc(A Certified Minority Owned Organization)
Checkout our excellent assessment tool:
Checkout our job board :
Central Business Solutions, Inc
37600 Central Court Suite 214 Newark CA, 94560
Phone: (510)-713-9900, 510-573-5500 Fax: (510)-740-3677
this job portal is powered by CATS