Global Channel Management, Inc
Lead Data Architect
Woodbridge Township, New Jersey, United States
$ 91.00 - 92.00 (US Dollar)
Iselin, NJ & Charlotte , NC
Hybrid
Good communication skills and good team player
Experienced in Technologies like E-R Modeling for OLTP OLAP Multi-Dimensional Data Modeling techniques like Star Schema Modeling, Cube-processing, Snow-flake Dimension modeling, Fact and Dimension Modeling using Erwin Tool. Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments. Strong experience working with conceptual, logical and physical data modeling considering Meta data standards. Experience in Financial services and other domains using Data Modeling, Extraction, Transformation, Loading reporting processes. Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing. Experience in performance analysis and created partitions, indexes and Aggregate tables where necessary. Work experience with UNIX operating system, Shell scripting and Automation of ETL process. Experience in writing, testing, and implementation of the triggers, stored procedures, views, cursors, packages, functions at Database level and form level using PL/SQL. Knowledge in business intelligent software ,Export Import, Performance Tuning of Database, Backup and Recovery, SQL Loader. Experience in integration of various data sources like Oracle, SQL Server, Oracle, MS Access, and Flat files into the staging area.
Define and maintain data architecture based on business and data strategy
Define and maintain reference architecture for enterprise data assets and processes
Define standards and enterprise patterns for data movement/data processing
Work with different business stakeholders and convert business requirements to technical specifications
Engage with enterprise architecture team and define optimal solutions for existing problems
Research on next-gen and emerging technologies and determine/document/recommend optional solutions
Good communication skills and good team player
#J-18808-Ljbffr
$ 91.00 - 92.00 (US Dollar)
Iselin, NJ & Charlotte , NC
Hybrid
Good communication skills and good team player
Experienced in Technologies like E-R Modeling for OLTP OLAP Multi-Dimensional Data Modeling techniques like Star Schema Modeling, Cube-processing, Snow-flake Dimension modeling, Fact and Dimension Modeling using Erwin Tool. Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments. Strong experience working with conceptual, logical and physical data modeling considering Meta data standards. Experience in Financial services and other domains using Data Modeling, Extraction, Transformation, Loading reporting processes. Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing. Experience in performance analysis and created partitions, indexes and Aggregate tables where necessary. Work experience with UNIX operating system, Shell scripting and Automation of ETL process. Experience in writing, testing, and implementation of the triggers, stored procedures, views, cursors, packages, functions at Database level and form level using PL/SQL. Knowledge in business intelligent software ,Export Import, Performance Tuning of Database, Backup and Recovery, SQL Loader. Experience in integration of various data sources like Oracle, SQL Server, Oracle, MS Access, and Flat files into the staging area.
Define and maintain data architecture based on business and data strategy
Define and maintain reference architecture for enterprise data assets and processes
Define standards and enterprise patterns for data movement/data processing
Work with different business stakeholders and convert business requirements to technical specifications
Engage with enterprise architecture team and define optimal solutions for existing problems
Research on next-gen and emerging technologies and determine/document/recommend optional solutions
Good communication skills and good team player
#J-18808-Ljbffr