hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Data Architect, Analyst

5.00 to 7.00 Years   Gurugram   15 May, 2019
Fiserv India Pvt Ltd
Job LocationGurugram
EducationNot Mentioned
SalaryNot Disclosed
IndustryIT - Software
Functional AreaStatistics / Analytics
EmploymentTypeFull-time

Job Description

The developer should have experience on Senior ETL tester having 5-7 years- Experience with requirements gathering, technical analysis, and writing technical specifications- Candidate must have strong database fundamentals. This is a developer position which will not lead a team.-Flexibility to travel onsite is preferred.-Good Communication skills are required.-Capability to work in a distributed team environment with minimal supervision is required for this profile.-The position doesnt require working in shifts, however flexibility to overlap with US hours is required.- Should have expert knowledge in writing SQL commands, queries and stored procedures- Strong knowledge of DB and DW concepts. Early joining is preferred.- Verify the Tables in the Source System e.g.

  • like Count check
  • Reconcile records with the source data
  • Data type check
  • Ensure no spam data loaded
  • Remove duplicate data
  • Check all the keys are in place
- Transformation logic is applied before loading the data. It involves the following operations-
  • Data threshold validation check, for example, age value shouldn t be more than 100.
  • Record count check, before and after the transformation logic applied.
  • Data flow validation from the staging area to the intermediate tables.
  • Surrogate key check.
- Data is loaded from the staging area to the target system. It involves the following operations-
  • Record count check from the intermediate table to the target system.
  • Ensure the key field data is not missing or Null.
  • Check if the aggregate values and calculated measures are loaded in the fact tables.
  • Check modeling views based on the target tables.
  • Check if CDC has been applied on the incremental load table.
  • Data check in dimension table and history table check.
  • Check the BI reports based on the loaded fact and dimension table and as per the expected results.
- ETL testers are required to test the tools and the test-cases as well. It involves the following operations-
  • Test the ETL tool and its functions
  • Test the ETL Data Warehouse system
  • Create, design, and execute the test plans and test cases.
  • Test the flat file data transfers.
,

Keyskills :
sqlwritingtechnicalanalysisdatamodelingtestcasestargetcommunicationsystemdataarchitecterwinsupervisiondatawarehousingcommunicationskillsistinfmatica

APPLY NOW

Data Architect, Analyst Related Jobs

© 2019 Hireejobs All Rights Reserved