*Title: Database Designer / Modeler* *Location: Raleigh, NC*
*Length: 12+ Months* *KEY EXPERIENCE:* Acts as the principal designer for major systems and their subsystems utilizing a thorough understanding of available technology, tools and existing designs. Provides comprehensive consultation to business unit and IT management and staff at the highest technical level on all phases of application programming and processes for diverse development platforms, computing environments (e.g., host based, distributed systems, client server, software, hardware, technologies and tools, etc.). Works closely with client and IT management and staff to identify application development solutions, new or modified programs, reuse of existing code through the use of program development software alternatives, or integration of purchased solutions or a combination of the available alternatives. Researches and evaluates alternative solutions and recommends the most efficient and cost effective application programming solution. May code new or modified programs, reuse existing code through the use of program development software alternatives and/or integrates purchased solutions. Documents, tests, implements and provides on-going support for the applications. Bachelors degree in Computer Science or a related discipline, at least eight, typically ten or more years of solid, diverse work experience in IT with a minimum of six years experience application program development, or the equivalent in education and work experience. *Major Roles and Responsibilities: * • Design and maintain services for data movement, transformation and management of claim data from multiple source applications to the Claim Read Only Data Store (RDS). • Design and maintain services for creating data extracts, Marts, etc to support downstream needs of the Claim RDS. • Data profiling source systems across multiple computing environments (e.g., host based flat files, host and distributed RDBMS) using native SQL and tools • Create source to target mapping, including transformation rules. • Collaborate across IT and business to ensure design is consistent, accurate, flexible and scalable. • Provide governance and oversight of development resources to ensure solution meets design requirements. • Serves as an expert resource on matters of data design in all phases of data warehouse and data mart development, implementation and support. • Ensure all design artifacts are maintained across multiple implementations *Skills:* - In depth knowledge of end to end Medical Claim processing and data flows (Cigna source application knowledge of Proclaim, PMHS, Facets a plus). - Experience with High volume, high transaction Data Warehousing Systems - Experience in data profiling. - SQL expertise with solid data research and analysis skills - Hands on technical expertise in operating and developing applications that make use of Oracle databases - Hands on technical expertise in data integration tools (e.g. Informatica, IBM InfoSphere Datastage) - Hands on technical expertise of Information Management concepts: Massive Parallel Processing warehouse platforms, Data quality, Metadata management, Data Integration/ETL, EAI, and CDC platforms - Ability to successfully work within multiple requirements, design, and development approaches and methodologies (agile, iterative, waterfall, etc.) - Able to work collaboratively as part of a team - Excellent communication, presentation and facilitation skills - Self-motivated - Self-learner *Education/Experience*: Bachelors degree in Computer Science or a related discipline. At least eight, typically ten or more years of solid, diverse work experience in IT with a minimum of 6 years experience application program development, or the equivalent in education and work experience. Regards, *Bhargavi* Horizon Softech Inc *An E- Verified Company * Ph: 248-434-8892 Fax: 313-397-0860 [email protected] <[email protected]> www.horizonsoftech.net -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/groups/opt_out.
