*Position: **Onsite Database Modeler* *Location: Peapack, NJ*
*Duration: 12 Months* *Skills:* · Expertise in Dimensional Modeling and Data Migration. · Experience in Data Transformation, Metadata, Data Dictionary, Data Loading, Modeling and Performance Tuning. · Data consolidation and harmonization. · Database schema and architecture design. · Should have hands on experience writing SQL queries · Experience in Data Warehouse & ODS/Data Mart. · Expertise in Creating ‘Source to Target’ data mapping. · Experience in data migration projects · Conduct JAD sessions with business and technical teams. · Experience in analyzing/troubleshooting and providing technical support for Oracle/Unix applications and their interfaces. · Extensive experience on Business Intelligence (and BI technologies) tools such as OLAP, data warehousing, reporting and querying tools, data mining and spreadsheets. · Data consolidation and harmonization. · Experience in data alignment and data cleansing. · Vast experience of working in the area data management including data analysis, gap analysis and data mapping. · Worked extensively with Dimensional Modeling and Data Migration. · Experience in Data Transformation, Metadata, Data Dictionary, Data Loading, Modeling and Performance Tuning. · Experience in DBMS/RDBMS implementation using object-oriented concept and database toolkit. · Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data. · Extensive experience on collaborating with SME's to define data standards, Business data definitions, Business rules, Critical Business information, Master Data, Data Quality and ETL creation and updating processes. · Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and interface requirements documents. · Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes. · Have knowledge of creating reports using SSRS and SAP Business Objects. · Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes. · Coordinated and prioritized outstanding defects and system requests based on business requirements. Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements. · Experience with Star Schema modeling and knowledge of Snowflake dimensional modeling. · Experience with SQL, PL/SQL objects. Involved in creating packages, writing procedures and functions. Tuning using various types of Partitioning and Indexes. · Experience in providing Production Batch support. · Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators. *Thanks & Regards* *Ajeet Dwivedi* (IT Recruiter) Email: ajeet.dwiv...@nityo.com Gtalk: ajeetitrecruiter -- You received this message because you are subscribed to the Google Groups "R-help-archive" group. To unsubscribe from this group and stop receiving emails from it, send an email to r-help-archive+unsubscr...@googlegroups.com. To post to this group, send email to r-help-archive@googlegroups.com. Visit this group at https://groups.google.com/group/r-help-archive. For more options, visit https://groups.google.com/d/optout.