ETL Test Lead

Infosys is seeking an ETL Test Lead,

As a QA Test Lead, you will act as a validation and quality assurance expert and review the functionality of existing systems. You will conduct requirement analysis, define test strategy & design and lead execution to guarantee superior outcomes. You will also be required to design an optimal test environment to simulate real-time scenarios. You will have the opportunity to collaborate with some of the best talent in the industry to create innovative high quality and defect-free solutions to meet our clients' business needs. You will be part of a learning culture, where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.

Required Qualifications:

• Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of Information Technology experience.
• All applicants authorized to work in the United State are encouraged to apply
• Work location is Raleigh, NC. This position may require travel.
• At least 4 years of working experience in QA Testing
• Strong communication skills.
• Knowledge and experience with full SDLC lifecycle
• Experience with Lean / Agile development methodologies.

Preferred Experience :

• 4 years of experience in test strategy and test Design
  4 years of experience in test execution analysis & reporting.
  • 4 Years of ETL Testing & Report Testing
  • Hands on working experience in cloud technologies ( MS Azure)
  • Clear understanding on cloud data applications and databases ( MS Azure)
  • At least 2 years of experience in Big data Testing
  • Knowledge of Java to test MapReduce Jobs
  • Knowledge of JUnit, MRUnit framework for testing
  • Hands on knowledge of Hive, Pig
  • Use RDBMS/HIVE to execute the test scripts, modify the scripts as required, identify, classify and raise defects, and participate in defect triages
  • Understand the test cases / scenarios, design and develop simple scripts using specialized testing tool(s).
  • Create test cases for complex modules based on the defined test strategy for the assigned module
  • Strong expertise in SQL and understanding transformations and converting them to SQL/HQL queries for data validation
  • Execute test cases as planned for the assigned modules with special focus on key modules using knowledge of test execution process for both functional and non-functional type of testing.
  • Create test analysis report for the assigned modules. Implement specific activities of the Defect Prevention Plan
  • Exposure to Healthcare Domain with clear understanding on claims, membership, provider & clinical subject areas
  • Exposure to Database testing using DB2, Oracle and other relational databases
  Nice to have
  
  • Expertize in developing Estimations, Develop Big data/ETL test Strategy and implement them.
  • Nice to have Test data management experience
  • Nice to have Data migration testing experience
  • Nice to have UNIX knowledge and Automation skills
  • should have strong co-ordination, communication & reporting, analytical skills
  • should have Strong leadership skills
  • should have experience in Agile and Devops methodology
  • Ability to work in team in diverse/ multiple stakeholder environment
  • Communication and Analytical skills
  • Experience and desire to work in a Global delivery environment
  • Strong expertise in ETL tools like Informatica or SSIS or other ETL tool.

The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Travel may be required as per the job requirements.