Hi Associates, Greetings!! Please find the specs of the requirement below; kindly send suitable profiles to
*srikanth.acha...@keyseries.us <srikanth.acha...@keyseries.us>* Please find below a new req for BNY Mellon. Candidates must have in depth knowledge of Erwin modeling tool. Please let me know if you have any available consultants. Position: Data Modeler Location: Brooklyn, NY Duration: 9+ Months Client: BNY MELLON Job Description : The Data Modeler/Analyst will create, maintain and enhance data models and will work closely with requirements analysts and data analysts to understand business needs and to translate the specific requirements into appropriate database designs. The Data Modeler will ensure that the data models created conform to the strategic goals of the business. Skills: • 7+ years of experience as a Data Modeler/Analyst •Design and maintenance of conceptual and logical data model for OLTP and other analytical applications, using ERWIN • Understands the differences in data management solutions around operational data, and analytical data. •Analyzing functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models •Facilitating data modeling sessions ranging from information gathering to model validation •Reverse and Forward Data Modeling •Providing support to analyze data requirements and data stored in a disparate set of systems and designing a robust relational structure for the future •Developing a solution to extract data out of the existing systems and store in the future system •Defining a data model and database design that is based on business needs •Conducting Business Requirements Analysis and educate the various project teams on the proper usage of data structures •Conducting data profiling and data analysis on source and target systems •Excellent Oracle SQL skills with the ability to validate data model functionality and performance using SQL •Must have good communication skills and ability to work in a fast-paced environment • Ability to work proactively in order to meet tight deadlines • Flexible and self-motivated Responsibilities: •Maintain data models in Erwin data modeling software •Participate in requirements gathering, project estimation and management •Utilize data modeling phase methodology leveraging conceptual, logical, and physical development to arrive at model solutions •Review and creation of architecture documents and diagrams: Data models, Data mapping, Data dictionaries, Metadata •Review and generate business rules for data •Research and document data flows •Research and document application integration solutions, ETL, SQL, etc. •Provide thought leadership regarding: Industry practices around collecting data, staging data, cleansing data, standardizing data, and publishing data into data marts. •Ensure data modeling deliverables conform to data modeling standards •Support integration of models and ensure definitions are consistent across the enterprise for shareability and reusability. --------------------------- Thanks & Regards Srikanth Acharya Kindly submit your consultant profile to above Email ID. Email is the best way to reach me out. -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.