*Location*: MI
*Data Analyst * Technology Consultant supporting and enhancing using SSIS This project is for a healthcare Insurance provider utilizing *BI tools from Microsoft.* The analyst joining this position will be part of a big team consisting of developers, testers and support using Microsoft tools to build and support a data mart. The position will be more aligned with *Production support role*. Desired candidate will coordinate functional activities of system integration testers participating on cross-functional teams for specific product development efforts. On a day to day routine the analyst would be required to monitor data processed by various ETLs (SSIS packages) in Production. Based on the analysis/pre-defined procedures would have to report business stakeholders. In case of any issues, they would find the root cause and provide possible solutions. The Analyst would also be required to do performance tuning of such queries that take long time (these queries are utilized in data validations). The Analyst would also actively participate in design sessions for production. As this position requires a lot of interaction with data, ideal candidate would have perspective to understand and derive conclusions from the data while supporting ETLs and data generated out of it. The position will also include working with business and technical resources to analyze problems encountered in testing and determining changes required to correct problems. *Top 3 Skills/Experience:* - Write and troubleshoot SQL queries and stored procedures. (8 years) - Experience in SSIS and SSRS (6 Years) - Experience in ETL and Data ware house testing (7+ Years) *Required Skills/Experience:* - Extensive experience in leading complex projects with division or company wide scope. - Strong skills required in communications, leadership, presentations to senior management, problem-solving, project management, team development and organization. - *10+ years of experience* specifically with leading *System Integration (SIT) and User Acceptance Testing (UAT)*. - Extensive experience in *SQL server 2008 platform.* - Experience in Data centric testing. Should be able to verify data loaded in tables as per the algorithms - Must be able to understand Data transformation rules, and able to validate principal totals. - Experience in *testing data warehousing applications.* - *Expertise in Data analysis,* Data modeling, Database design, Data migration, and Business intelligence solutions. - Solid understanding of relational database concepts, SQL and *procedural SQL* in Teradata - Expertise in processing data available in *Message Queues, Flat Files and Relational Databases* - Create processes to ensure the data quality of the information collected. - Extensive hands-on experience on writing Excel macros. Extracting data from tables and formatting and dumping in files -- Thanks&Regards, Ram, ram.r...@gmail.com -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-users+unsubscr...@googlegroups.com. To post to this group, send email to oracle-users@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/d/optout.
