( PLEASE SEND RESUMES TO prasa...@sagarsoft.com ) Hi , This is Prasanna with Sagarsoft,
Staying current with technology, finding great consultants and exceeding our clients' expectations are our primary objectives. Thanks for your time and attention to this e-mail. Please let me know if you are available *Title: ETL Architect* *Location: Horsham, PA* *Duration: 12 Months* *Required Skills:* * Description We are currently seeking a replacement for resigned ETL Architect/Developer with advanced ETL Architecture and data modeling skills to work as part of the Enterprise Data Management. This role will be involved in ETL Architecture for Insurance Solutions. The new hire will be working on strategic projects that focus on complex business requirements. Responsibilities:Provide onsite development including responsibility for the day-to-day performance, maintenance, and monitoring of the Data Warehouse system and its technical interfaces.Design architecture, map business rules and processes into technical solutions.Designing and leading the development of production SQL and database changes as well as assistance with the design of efficient database and storage structures.Perform analysis, development, and evaluation of data mining in a data warehouse environment that includes data design, database architecture, metadata, and repository creation.Develop design specifications, unit test plans, and troubleshoot client issues. Work with a diverse project team with an emphasis on repeatable processes and technical documentationPerform hands-on design, development and testing within the ETL tool environment using a mixture of GUI driven tools and hands-on SQLAnalyse, design and implement User Interface (reports and dashboards)Educate client management and business users on business value and capabilities of data warehousing and business intelligenceProvide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodologyAssist in identifying and prioritizing business information needs, and defining business benefit of data warehousingAssist in evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administrationResponsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiativesPerforms table and interface design, development of logical and physical data model/database, ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements Required Skills: Development and maintenance of various data subject area data models (e.g. Provider, Customer, Individual, Clinical, Claims)Defining relationships and touch points between data subject areasRequirements gathering sessionsRequirements mapping and gap analysisAnalyzing complex data structuresSemantic transformation specificationsComposition of accurate and complete definitions for entities and attributesBuild, develop, and manage a SQL Server relational database using datawarehousing best practices.Hands-on ETL development and Review ETL load jobs for consistency and quality.Provide ETL design, development and testing estimations based businessrequirements and research into data that is currently sourced.Design of views, data mart solutions , and cubes.Implement Data Management strategies which include validation of source data and the use of data in management reporting.* *Awaiting for your reply.* *Prasanna* Sagarsoft Inc. 860-993-1058 *prasa...@sagarsoft.com <prasa...@sagarsoft.com>* www.sagarsoft.com -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To unsubscribe from this group and stop receiving emails from it, send an email to business_intelligence+unsubscr...@googlegroups.com. To post to this group, send email to business_intelligence@googlegroups.com. Visit this group at http://groups.google.com/group/business_intelligence. For more options, visit https://groups.google.com/groups/opt_out.
