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.dwivedi@nityo.com
Gtalk: ajeetitrecruiter
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment