Sr. Data Architect
Hope you are doing good...
Please find the below requirement and share the suitable profile as per JD
Location: Irvine, CA
Duration: long term
Interview process: Telephonic (30 mins) round followed by a Skype/Inperson interview (1 hr)
End Client: Corelogic with TekStorm
Visa type: USC/GC/H1B
Required Skills:
· Minimum 13+ years' experience modeling complex databases using 3rd party modeling tools such as ERWin 9.2
· Experience designing and building large financial services data warehouses with very strong data analysis skills
· Have good knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments.
· 3-5+ years of hands-on experience in data management, data warehousing, data transformation, metadata and reference data management and business intelligence tools.
· 3+ years of experience with advanced SQL query techniques using TOAD, SQL Navigator. Basic UNIX would be a Plus.
· Significant experience with System Development Life Cycle (SDLC)
Responsibilities:
• Capture business requirements and rules, design the associated logical models, and create all required documentation to support, communicate, and validate the data model.
• Design, build and maintain the logical and physical data models to support the business requirements in a dynamic, expanding business environment.
• Map data elements of data sources into the domain data models.
• Maintain documentation of data models, including relationships, constraints and metadata.
• Publish and conduct model reviews with business and technical project teams.
• Review database design changes with the team to determine the impact to the physical database and other systems.
• Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues.
• Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization
• Architect with an eye toward high performance, scalability, and high availability.
Click here to unsubscribe
Comments
Post a Comment
Thanks