Expertise in data modeling, reporting, analysis, mining, design, development, migration, implementation, and database testing
Proficient in E-R modeling for OLTP and OLAP, multi-dimensional data modeling techniques, normalization, de-normalization, and data transformation
Strong knowledge of technologies like Star Schema Modeling, Cube-processing, Snow-flake Dimension modeling, and Fact and Dimension Modeling using Erwin Tool
Experience in conceptual, logical, and physical data modeling following metadata standards
Background in financial services and other industries utilizing data modeling, extraction, transformation, loading, and reporting
Skilled in performance analysis, partitioning, indexing, and creating Aggregate tables
Proficiency in UNIX operating system, Shell scripting, and automating ETL processes
Capable of writing, testing, and implementing triggers, stored procedures, views, cursors, packages, functions using PL/SQL
Knowledge of business intelligence software, Export Import, Performance Tuning of Database, Backup and Recovery, SQL Loader
Experience integrating data sources like Oracle, SQL Server, MS Access, and Flat files into staging areas
Responsibilities Of a Lead Data Architect
Define and maintain data architecture aligned with business and data strategy
Establish and manage a reference architecture for enterprise data assets and processes
Define standards and patterns for data movement and processing at an enterprise level
Translate business requirements into technical specifications in collaboration with business stakeholders
Collaborate with the enterprise architecture team to devise optimal solutions for current challenges
Research and evaluate next-gen and emerging technologies, documenting and recommending applicable solutions
Demonstrate strong communication skills and teamwork abilities
Employment Type: Full-Time
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Staffing and Recruiting
Referrals increase your chances of interviewing at Global Channel Management, Inc. by 2x