Data Analyst - 3 to 5 years experience
Responsibilities
Good in communication, both written and verbal
- Must have an minimum of 3yrs hands-on experience in Datawarehouse and Data migration testing
- Validates the accuracy, completeness, and integrity of data moved between systems, ensuring business rules are applied correctly
- Ensure data accuracy, completeness, and consistency after migration..
- Ability to perform migration testing of static data and transaction data from one core system to another
- Strong SQL skills (joins, unions, subqueries).
- Define and track quality assurance metrics such as defects, defect counts, test results and test status
- Experience in analyzing DMS mapping documents and create SQL scripts
- Experience in Reports and Dashboard testing
- Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes
- Performing data reconciliation, and verifying data transformations.
- Data warehouse testing experience
- Experience testing Waterfall/Agile Development Projects
- Hands on experience in relational databases and database architecture. Understanding data models and ER diagrams
Qualifications
Bachelors Degree/MCA/BE
Essential Skills
DB2, SQL, SQL Server 2008 / 2010, Oracle ,UNIX, Informatica/Data Stage, Python, Cloudera Hive
Experience
3 to 5 Yrs