*Need passport number with Visa and DL copy for H1B/opt.* *For Fast Submission please share Passport number and Visa copy with resume.*
*Rate:: $50/hr on C2C Max( Not Negotiable)* Hi, I have an urgent requirement with one of my client, please find requirement below. If you are comfortable please send me your updated resume with expected *rate* Asap. * Position: Database Modeler* Location: Peapack, NJ Duration: 12+ months Job Description: *Technical/Functional Skills -MUST HAVE 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. *Roles & Responsibilities* · 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, Abhay Tiwari IDC TECHNOLOGIES INC | 1851 McCarthy Boulevard, Suite 116, Milpitas, CA , USA, 95035 Phone No.: 408-418-5778 Ext 3061I Email: *abha...@idctechnologies.com* <abha...@idctechnologies.com> I Gtalk: *abhaytiwari9...@gmail.com* <akt....@gmail.com> Web: *www.idctechnologies.com* <http://www.idctechnologies.com/> "Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list." [image: Description: Description: Description: Description: IDC-Technologies.gif] -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.