Lead Data Architect

Lead Data Architect needs 7+ years' experience in Data Modeling, Data Reporting, Analysis, Mining, Design, Development, Data Migration, Implementation and Testing of Database
Lead Data Architect requires:
-Iselin & Charlotte
-Hybrid
-Data architecture
-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.
Lead Data Architect duties:
-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
Employment Type: Full-Time
Salary: $ 92.00 Per Hour