|
|
|
|
 |
If this is a scam, MLM, or Home Based "Opportunity" then Mark as SPAM
|
 |
Thank you for helping! This job will be reviewed by us shortly. Undo
|
| Employer Name: Sri Phani Kiran Yerubandi |
SpiderID: 9031913 |
| Location: Dallas, Texas |
Date Posted: 10/14/2019 |
| Wage: |
Category: Information Technology |
| Job Code: CCI-DA-10/14/2019 |
|
| Number Of Openings: 1 |
|
Job Description:
Architect the Enterprise data warehouse BI Solution with MSBI Suite
Job Requirements:
Logical & Physical data model database design, modelling & Implementation of enterprise for subject areas like OBGYN, ICU, Transplant and Oncology.
Work closely with other architects, executives & end users to develop the requirements and system architecture for new EDW
Work with analysts to remediate reporting requirements and provide support needed.
Work with physicians and research team to scope and plan the deliverables of the reporting requirements
Develop design standards for using normalized, de-normalized and dimensional data structures by defining common design patterns for modelling various types of relationships.
Build Proof of concept for end to end SDLC of new data warehouse which involves in audit framework & control process.
Create automated scripts to extract data from EPIC Clarity & Cerner power forms applications.
Create architectural documentation and road map for development cycle.
Create data integration and technical solutions for Azure Data Lake Analytics, Azure Data Lake Storage,Azure Data Factory, Azure SQL databases and Azure SQL Data Warehouse for providing analytics
Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
Manage ADF Custom activities
Work with OnPrem-Azure SQL Databases and Azure SQL DataWarehouse
Create linked services to connect to Azure Storage, on-premises SQL Server and Azure HDInsight
Conduct code walkthroughs, peer reviews, and produce technical documentation
Dynamically show/hide sheets , handled Null Values
Worked on complex aggregate functions and gave the desired output across the combinations.
Created optimized QVDS which loads faster and helps to improve the performance.
Experience with QlikView functions like fabs, peek, previous, isnull etc.
Created pop up text box on button click which will prevent it working where user can navigate to that sheet only after making required selections in that page.
Worked on enhancements and Performance tuning on existing dashboards.
Deployed an application on Qlikview server.
Scheduled data refresh on applications on QEMC.
Provided User meetings and training on QlikView Dashboard functionality.
Up on Special Request from the user’s new tables are added to the existing schema for the Transformation purpose and created Application objects on top of them for the SSRS Reports.
In order to support the special reports a new reporting table created in schema.
Designed and Developed Schema Tables, Attributes, Facts, Hierarchies, Metrics, Filters, Prompts, Custom Groups, Consolidations, and Reports
Job Criteria:
Start Date:
Position Type: Full-Time Permanent
Years of Experience Required:
Education Required: Bachelors
Overnight Travel:
Vacation Time:
Contact Information:
| Contact Name: Human Resource |
Company Type: Employer |
| Company: Cod Cores Inc |
|
|
|
| City: Farmers Branch |
|
| State: Texas |
|
| Zip: 75234 |
|
|
|
|
|
|
|
|