Should have 5-8 total test experience with 3 to 6 years of relevant ETL experience experience in Informatica, Unix, SQL, Python
Analyze/profile data to meet project needs, create test beds and seed test data using Structure Query Language (SQL), or by other means based on environment, to ensure complete coverage of business requirements, functional and technical specifications are met.
Experience and working knowledge of tools such as ALM and JIRA
Experience of testing services in Investment Banking Domain
Good working knowledge of UNIX.
Strong in ETL data validation using Informatica Power Centre or other ETL environments
Experience in testing ETL loads, stored procedures and databases.
Exposure to Hadoop eco system. Working knowledge on HIVE would have an edge.
Ability to run ETL Jobs and test scripts to process in Test environment for end-to-end validation.
Self-motivated, able to work independently and perform multiple tasks under minimal supervision.
Strong interpersonal, written and verbal communication skills, particularly in a multi-cultural environment.
Develop complex SQL scripts that validate business requirements and source to target mapping within the data warehouse. Ability to run ETL Jobs and test scripts to process in Test environment for end-to-end validation.