*Hi,* *Hope you are doing great.*
*Please find the requirement below and send me matched resumes to **raj...@spgamerica.com <raj...@spgamerica.com>** (OR) **732-343-7688 x 3049* *.* *Job Title : Data Warehouse Analyst* *Location:* *Bloomington, MN Duration:* 6 months *Need US Citizen/GC ONLY* *ACCOUNTABILITIES:* · Gather functional business specification requirements from business and users · Translate functional business requirements into data design and technical specifications that adhere to the architectural framework · Develop technical specification for integration components and collaborate closely with ETL developers on ETL map development and testing · Participates in design reviews, the quality assurance and testing process, and follows the defined SDLC process · Performs a technical data role and drives tasks to conclusion · Troubleshoots and resolves technical challenges within timelines and budget · Collaborates with interface teams and business owners to control scope and makes necessary decisions to complete the project on time · Follow the HealthPartners Data strategy with regard for the Enterprise Data Warehouse architecture - including but not limited to the Research, Health Plan and Clinical Care Delivery · Follow Data Warehouse standards, policy, and processes for HealthPartners Enterprise Data Warehouse architecture in regards to the development of the Research Data Warehouse · Ensure expected requirements are met according to HealthPartners standards and principles · Develop data models and data designs for Enterprise Data Warehouse deliverables with Data Modeler and Data Architect · Performs other duties as assigned *REQUIRED QUALIFICATIONS:* · Bachelor’s degree or equivalent experience · Minimum 3 years of experience in designing & developing logical & physical data model using data warehouse methodologies, including Star schema - Star-joined schemas, conformed dimensions data architecture, early/late binding techniques, and data modeling · Hands-on technical knowledge of Data Warehouse Architecture, ETL, Database & SQL performance tuning · Experience with Data Modeling Tools such as Erwin, Embarcadero · Solid understanding of and experience in ETL (extract, transform, load) processes · Hands on experience in Oracle 11g (features, functions, & utilities) · Excellent knowledge of SQL: PL-SQL, T-SQL, SQL scripting · Technical specification development experience · Ability to estimate data development efforts · Ability to manage tasks and work independently · Strong documentation and diagramming skills · Excellent verbal and written communication skills · Problem solving skills · Patience and strong customer service skills · Multi-tasking ability · Interpersonal communications skills *PREFERRED QUALIFICATIONS:* · Understanding of data models, staging, landing and data cohorts, ODS, OLAP, multi-dimensional analysis, and various schemas · Experience with successfully demonstrating the ability to create industry proven standards, models and concepts that meet the needs and requirements of the Management team · Experience using ETL Tools such as SSIS, DataStage, Informatica · Hands on experience in SQL Server 2012 (features, functions, & utilities) · Experience with large / complex data warehouse environments preferably in a clinical care delivery environment · Hands on experience in Data Warehouse Data Analysis (Source Systems), Data Architecture, Data Modeling, and Data Propagation design and specification · Solid Knowledge of Dimension Modeling and Data Warehouse concepts · Good understanding of Query optimization technique used in Data Warehouse domain · Health Care Research experience · Experience working with healthcare related data and applications including but not limed to Health Plan and Clinical Care Delivery · General knowledge about the health care industry, understanding of underlying business functions · Knowledge and/or experience with Cache and Microsoft SQL Server database technologies · Experience with Data Quality tools & processes · Knowledge of data warehouse software development lifecycles (SDLC) including Project Management and BI analytics using Lean and Agile *Thanks for your Time and Support* *Rajesh | Technical Recruiter* *Software Programming Group* *15 Corporate Place South, Suite #421, Piscataway, NJ - 08854* *Tel: **732-343-7688 x 3049* *|| Fax: **732-343-7689* *Email: **|raj...@spgamerica.com* <%7csamb...@spgamerica.com>* | URL : * *www.spgamerica.com* <http://www.spgamerica.com/> *Hangout:bvrajeshgowd* *IT Services || Consulting* *USA || INDIA* -- You received this message because you are subscribed to the Google Groups "US_IT_ Jobs" group. To unsubscribe from this group and stop receiving emails from it, send an email to chandrakants+unsubscr...@googlegroups.com. To post to this group, send email to chandrakants@googlegroups.com. Visit this group at https://groups.google.com/group/chandrakants. For more options, visit https://groups.google.com/d/optout.