5 - 7 years
Posted 160 days ago
Role: Sr. Consultant
Location: RTP, NC
Experience: 6 years
looking for profiles with hands on in DWH, ETL (informatica) and QA along with basic HRMS knowledge.
* Technical knowledge in Oracle HRMS,Workflows,ADF, databases with hands on experience in Oracle PL/SQL and should be able to developed complex SQL queries for querying data against different data bases for data verification process and data Reconciliation. Should also be able to perform data quality analysis using advanced SQL skills.
* Strong QA experience with hands-on experience in Data reconciliation, DW and ETL tools. Experience in preparing the Test Plan and Testing Strategies for Data Warehousing Application along with preparing ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
* Knowledge in the business process workflows and mappings indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types in DWH.