Hi Associates, *((Backfill Position))((Monday Start Date))* Data Analyst SpringField,MA 6 months contract
*Technology Q&A* *1.) Client has numerous systems and they don’t have a catalog of database types used, the majority is Oracle but one major system is DB2. 2.) Client uses Business Objects for reporting. They use toad with Oracle for writing queries including profiling queries.3.) Client currently doesn’t have a profiling tool in place although in the future it may be Quality Stage. If you have used ANY profiling tool and have an understanding of profiling methodology, it would be a plus.* Job Description The Senior Data Analyst will play a key role in the design and delivery of systems that extract and move data into and through the data-warehousing environment. A key responsibility includes performing data profiling and analysis through development of custom code or through use of data profiling tools. You will work closely with application source matter experts and business partners to determine appropriate data sources and to define integration, transformation and cleansing rules. Additionally, you will participate in all phases of data warehouse and business intelligence solution delivery to include supporting requirements gathering, dimensional model review, source to target mappings and ETL development. Responsibilities Works with application source matter experts to understand data management, data flows and transformations between systems in order to determine best sources of data to support business intelligence and analytics. Conducts thorough data profiling, including column analysis, structural analysis, simple and complex rule analysis to understand the source system data, including its definition, condition and technical functions (e.g., identifiers, format, nulls, etc). As an outcome of data profiling and analysis, proposes options to solve for the business data challenges. Works with ETL developers to define effective transformation rules in order to populate data into unified data repositories. Develop data extraction process using Informatica to stage data for analysis and movement to the Data Warehouse environment. Essentials: Analytical mind-set with hands-on skills in writing SQL queries to profile and analyze data present in application and data warehouse systems. Familiarity with data profiling tools a plus. Experience with and understanding of relational and dimensional data structures. Experience with development of ETL processes for Data Warehouse and Business intelligence solutions using Informatica or Data Stage. Experience health care systems highly preferred. Minimum Requirements: 5+ years in Data Analysis, SQL / Informatica / Cognos or Business Objects / RDBMS / ETL tools. Involved in Design/Implementation/QA of Business Intelligence/ Data Integration projects Experience dealing with externally sourced third party data Experience developing source/target mappings, data lineage to support ETL Development Experience providing Support, Incident management and resolution of data issues in SQL / Informatical / Cognos / other ETL tools. Ability to profile and test data, implement Data Analytics/Statistics to measure the quality of data Thanks and Regards, Ryan Marshall SR.Technical Recruiter, Panzer Solutions LLC 45 Stuart Ave, K Norwalk CT 06850 USA Direct:203 652 1444 Ext 127| Fax: 203-286-1457 , E-mail:ryan.marsh...@panzersolutions.com www.panzersolutions.com -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-source-erp-crm+unsubscr...@googlegroups.com. To post to this group, send email to open-source-erp-crm@googlegroups.com. Visit this group at http://groups.google.com/group/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.