| Required Data Architect (Remote). 15+ Resumes Please. at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=863926&uid= Role: Data Architect Location: Remote Duration: Long Term Contract Start Date: After Thanks Giving LinkedIn Profile: Should be impressive. Send me Resumes with LinkedIn Profile Links, Work Authorizations & Rates. Job Description: Years of experience in Designing, Developing, Analyzing and maintaining Relational database applications (on-prem and cloud) 5+ year of experience project management, team building, coaching, mentoring Participated in Master data management, Metadata management and data standard development tasks as a part of the data governance effort Played active role in developing enterprise data development strategy, that includes baselining, reverse engineering and re-engineering of the existing databases Strong experience in end-to-end data management - data acquisition, data model, data storage, data transportation. Data transform and data access Worked in Big Data environment for 7 years Lead several projects involving data architect for OLTP and data warehouse Managed the data development life cycle that involves Conceptual data model, Logical data model and Physical data model Managed Source System analysis by doing data profiling to facilitate DW design and S2TM Strong in 3NF (Third Normal Form) technique to ensure data integrity Expert in applying denormalization techniques to refine the enterprise physical database design for improving performance of the application Strong experience of requirement analysis and development of logical/ physical models Strong experience of SQL Server 2008/2014/2019- Database environment setup for Development and Testing phase of the project Proficient in Dimensional modeling, Star Schema & Snowflakes, OLAP cube - data warehouse designing Knowledge of Teradata's FSLDM and CLDM Experience working on banking regulations like CCAR, LCR reporting, AML compliance, KYC compliance, Dodd-Frank Act stress testing, BASSEL III Knowledge of ETL tool like SSIS and Informatica Knowledge of RDBMS platforms like SQL Server, Teradata, MySQL, GBQ of GCP, RDS of AWS Familiar with data profiling tool like Talend and IDQ Experience of using Kimball and Inmon methodology for data warehouse database design Proficient in ER Diagram, Normalization up to third normal form Experience in domain modeling to represent business requirements and support DDD approach SKILLS: Database Designing Tool: ERwin/ ER studio - Embarcadero, Power Designer IBM's InfoSphere Data Architect (RDA) Database Designing Technique: ER diagram, Normalization, Denormalization, Dimensional modeling, Star schema, Snow-flakes, Domain modeling, Cube, JAD, Object modeling, Traceability Matrix. ETL Designing: Includes Source system analysis, source to target mapping (S2TM) Other Modeling Technique/ Tool: Use Case analysis, Reverse Engineering, Data Profiling, Data Dictionary Domain modeling in Domain Driven Design (DDD) environment Types of data models: Conceptual, Logical, Physical, Enterprise, Dimensional, Star Schema, Hub and Spoke, Cube Data Governance that includes Metadata management, Data Quality, Data Standards, Reference Data Management, Master Data Management, Data Error Management ETL tool: Informatica, SSIS Industry models/ framework: Teradata s FSLDM,Teradata s CLDM, IBM s BDW, Zachman, IBM s Data Governance Maturity model RDBMS On-prem/ cloud: SQL Server,DB2, Oracle, MySQL, Teradata, Snowflake, BigQuery/GBQ of GCP, RDS of AWS Data visualization tool: Looker Project Management: Agile methodology, Waterfall methodology, Rational iterative, Onshore Offshore model Keywords: http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=863926&uid= |
| [email protected] View All |
| 11:56 PM 16-Nov-23 |