Job Description
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, NJ & Charlotte, NC
• 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