*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 "International SAP Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to international-sap-projects+unsubscr...@googlegroups.com. To post to this group, send email to international-sap-projects@googlegroups.com. Visit this group at https://groups.google.com/group/international-sap-projects. For more options, visit https://groups.google.com/d/optout.
