Hi, Please find the requirement below and email resumes to va...@aclatinc.net
*Position: IT/ Programmer - Database Engineer_Advanced* * Location:Simsbury, CT * *Duration: 12+ Months * *Job Description: *The Data Modeler is responsible for all data related aspects of a project. At a macro level this comprises working with Data Architects in understanding the architectural roadmaps that support and fulfill business strategy. At a micro level this comprises working with individual projects as a contributing member, designing Logical Data Models and stewarding the data design of the project and ensuring alignment with the larger roadmap goals. The position is primarily a self-directing individual contributor with skills at matrixed and virtual team contribution/integration and with experience in leading and directing other team members. Thoughtful analysis, option development, and delivery estimation and planning rigor are requisite. *Dress Codes: *Business Casual *Skills: Category Name Required Importance Level Last Used Experience * Database Platforms Data Analysis No 2 Expert 9-10 6 + Years Development Tools Datamart No 4 Expert 9-10 2 - 4 Years Miscellaneous Database Design No 5 Intermediate 7-8 2 - 4 Years Programming Languages Data Modeling No 1 Expert 9-10 6 + Years Programming Languages Data Warehousing No 3 Expert 9-10 4 - 6 Years *Additional Position Requirements: *Job Responsibilities: • Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems; Ensure data design follows the prescribed reference architecture and framework; Ensure design reflects appropriate business rules, and facilitates data integration, data conformity and data integrity; Ensure data structures are designed for flexibility to support future business needs and enhancements. • Develop Hierarchical modeling and dimensional modeling constructs; Develop and maintain the Data Warehouse Bus Matrix Architecture; • Design and govern data services messaging constructs in XSD format. • Understand the relationships across business information and units of data; collaborate with Business Analysts, Data Stewards and Business Customers to identify data usage patterns and to formulate Business names, definitions and data quality rules for data elements. • Perform source data analysis and data discovery and data profiling. • Maintain Data Mapping documents, Bus Matrix and other Data Design artifacts that define technical data specifications and transformation rules; • Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modeling solutions; provide data structures optimized for information entry and retrieval; • Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures; support development team during process design and during performance tuning; support QA team during Test Strategy and test case development; • Adopt quality assurance practices to include following an appropriate modeling methodology; helping to establish department standards and procedures; reviewing and critiquing data models produced by others, participating in walkthroughs and audits; ensuring appropriate documentation is produced at all points in the process; • Pursue continuous improvements based on lessons learned and industry best practices. All processes include consideration for data integrity and data quality; • Ensure work product deliverables are accurate and delivered on a timely basis; • Participate in both business and IT planning, and in the development and management of project plans; • Understand the goals and risks associated with the business and technical requirements, and offer counsel on risk mitigation and the alignment of data solution with objectives; • Educate project team members and the business community on the impact of proposed and alternative data solution and technologies; • Demonstrate a team orientation by working closely and effectively with business partners, development teams and outside services; • Demonstrate solid business and organizational skills, and leadership in the use of data analysis and design tools and methodologies. *Qualifications:* * Masters or Bachelor’s degree 7+ years of experience in Data Modeling, data warehousing and data design Very Strong hierarchical and dimensional modeling and 3NF skills Strong Analytical Skills Strong Communication & Presentation skills Strategic thinking Strong background in Data Management Best Practices, Data Integration, Data Rationalization and Data Patterns. P&C Insurance expertise Additional Qualifications: Experience with Metadata Management and Products Experience with industry data models like ACORD Experience with XML Experience with Canonical Modeling & Dictionary Modeling* Best Regards *Venkat* Aclat Inc. Office:847-577-3501 Ext 3504, E-mail:va...@aclatinc.net -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/groups/opt_out.