Search by job, company or skills

Virtusa

Data Migration Tech Lead

6-8 Years
new job description bg glownew job description bg glownew job description bg svg
  • Posted a month ago
  • Be among the first 20 applicants
Early Applicant
Quick Apply

Job Description

  • More than 8 years of experience with data architecture, large-scale data modelling, database design, and business requirements analysis
  • Data Migration expert and it is must skills, - Work along with the Senior Data Lead / Architect to develop the Migration Framework / scripts
  • Responsible for overall data architecture for all areas and domains of the enterprise, including data acquisition, ODS, data warehouse, data provisioning, and ETL
  • Gather and analyse business data requirements and model these needs
  • Expert level understanding of relational database concepts, dimensional database concepts and database architecture and design, ontology, and taxonomy design
  • Experience with using CA Erwin to develop Enterprise Data Models
  • Set standards for data management, analyse current state and conceive desired future state, and conceive projects needed to close the gap between current state and future goals
  • Strong understanding of the best practices in data modelling techniques including in-depth knowledge of the various normalization, dimensional modelling and their appropriate usage in various solutions
  • Provide guidance on technical specifications, data modelling, and reviews proposed data marts, data models, and other dimensional uses of data within the Data Warehouse
  • The Data Architect will oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
  • Experience and Knowledge of Talend Data Integration Platform
  • Analyse the account structure, contact, pricing and other related objects and to make sure the required data is moved from source system(s) ( Innovative or cForce) to iQuest
  • Map data attribute(s) and create mapping documents as required
  • Create / Write ETL (Extract transform Load) to read data from source and load data to destination - Data Migration
  • Cleanse ( De-dup , etc) and write transformation logic for data transformation
  • Develop error handling strategy to handle exception / missing values along with the data lead and incorporate them into the scripts
  • Develop roll back mechanism for rinse-and -repeat activities
  • Assist in QA and UAT activities
  • Liaison with the Change management teams as required.
  • Assist in QA and UAT activities

More Info

Job Type:
Function:
Employment Type:
Open to candidates from:
Indian

About Company

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.
Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.
Virtusa is an Equal Opportunity Employer. All applicants will receive fair and impartial treatment without regard to race, color, religion, sex, national origin, ancestry, age, legally protected physical or mental disability, protected veteran status, status in the U.S. uniformed services, sexual orientation, gender identity or expression, marital status, genetic information or on any other basis which is protected under applicable federal, state or local law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government-issued ID during each interview. All candidates must be authorized to work in the USA.

Job ID: 118078627