Required Skills

Data architect sql server data modelling etl

Work Authorization

  • Us Citizen

  • Green Card

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- Any UG - Not Required

  • PG :-

Other Information

  • No of position :- ( 1 )

  • Post :- 25th Jan 2021

JOB DETAIL

Our Data Architecture team is responsible for establishing and maintaining an adaptable data infrastructure in order to provide access to high quality, consistent data in an easy and convenient manner to all authorized end users and applications of our client and its subsidiaries.

Our team is looking for a highly organized person who has architected and supported critical applications in an insurance / financial environment and is experienced in well-known DBMS system. This seasoned professional will need to interface with multiple client groups and IT senior management, providing them with data architecture solutions. timely and accurate status updates, short-term / long-term plans, release plans, etc. in a clear consistent manner that emphasizes performance metrics, strategic planning, continuous improvement and adherence to industry best practices.

·         

·        Responsibilities:

 

Data Modeling:
Develop, document and maintain logical and physical data models that accurately reflect the existing environment and update for new projects/enhancements.
Work with DBA and other staff as necessary, to instantiate physical databases based on the models.

Data Analysis & Design:
Review data sources and assess data quality; determine the appropriate data inputs, outputs and integration rules and strategy.
Create functional design specifications to be used by the developers.

Model Management:
Version and configuration manage data models so that they are consistent with development testing and production deployment environments.

Information Dissemination:
Publish models and metadata in the form of web pages, graphics and reports to projects, management and other interested parties in order to raise the organizational knowledge of what data exists where.

Cross-Organizational Coordination:
Interface with business units, internal IT, customers and management in the performance of duties.

·         

·        Mandatory Skills Description:

10+ Years of IT industry experience, with 5+ years of experience as a Data Architect or in data related areas.
Relational database concepts; Strong experience in SQL Server and related technologies.
ETL concepts, preferably Informatica or Syncsort
Proficient in data modelling tools -- preferably Erwin.
Strong RDBMS knowledge.
Significant experience interfacing with both customers and management.

·         

·        Nice-to-Have Skills:

Familiarity with Big Data technologies like Hadoop and Data Lake
Familiarity with Mainframe data structures in VSAM and DB2
Insurance domain knowledge; preferably with an insurance carrier.
HIPAA and other regulations that govern the access of data

Company Information