Senior ETL Tester

• Overall 9+ yrs of ETL experience
• Proficient in Python programming / Ability to write and execute Python scripts
• Extensive experience in performing data analysis on data mapping and functional design documents to understand ETL processing
• Validate data landed from source to target is correct
• Understand source to target mappings
• Understand business rules to meet user requirementsProfile data
• Work with workstream leads and developers as neededCreate and execute test cases
• Report and retest defects
• Understand and Interpret logical design document and data model diagrams to understand requirements
• Effectively communicate issues and raise concerns to work stream leads
• Obtain and maintain a working knowledge of customers data flows and business models
• Effectively communicate project status to workstream leads
• Manage and control changes in project scope while communicating impact to work stream leads
• Proactively work to identify, communicate and resolve project issues and risks that interfere with project execution or success
• Work effectively on multiple assignments, activities or projects
• Manage individual work load and assist other team members as needed
• Help to identify, isolate, and communicate data problems within environments
• Ability to work individually and within groupsEnsure appropriate project controls are met

Qualifications

• 9+ years of relevant experience in a data warehousing role
• 9+ years of experience with relevant software, including: Microsoft Office applications, MS Project, Visio and data modeling tools
• 9+ years of quality assurance experience
• 9+ years of quality assurance methodologies
• Ability to create and execute complex queries for large data sets using SQL or big data technologies
• Sound Experience in analyzing dataExperience with data profiling
• Experience in translating business requirements into conceptual and logical models
• Strong analytical and problem-solving skills
• Good background working with data schemas
• Excellent oral and written communication skills
• Excellent visual information skills (e g data-oriented use cases)
• Experience with agile (Scrum and Kanban)
• Experience with data movement tools such as Informatica
• Bachelors degree, or work equivalent, in data sciences, computer science or related field3 must haves
• ETL Testing - 4/5Advance SQL- 4/5Python - 4/5