Manual Tester with Marketing domain and Data experience

Manual Tester with Marketing domain and Data experience

Full Time

Location - Culver City, CA (Los Angeles)

Marketing Domain - and Data Experience(Need Data person) need hands on data testing or tools

10+ years

Comm skills

Can deal with Business

Automation knowledge - will be add on

Video streaming exp.(Good to have)

Content based testing exp.(Good to have)

Submit with Photo ID and Day 1 culver City confirmation email

Panel is available Monday and Friday 7:30 am - 8:30am CST and 5:30pm to 6:30pm CDT - Submit with candidates' slot for both days.

You will find the actual JD below under "Campaign Data QA" below,

Soft skills /Experience:

• A lead with min 5-8years of customer facing experience.( most important for a seed role)
• Should be able to collaborate and co-ordinate with multiple internal teams to present and resolve issues. (Cross functional)
• Should be able to quickly understand the client system architect( data architecture) and suggest changes/improvements.
• Able to contribute towards creating case studies, RFP's and engage in Value added services( Automation, Macros, Data automation)
• Knowledge of Automation tools ( Ex Uipath or RPA) would be an added advantage.

Testing:

• Testing experience ( min 10-12years) with good Knowledge of Test lifecycle, defect management and UAT.
• Proven track record in creating Test, Data , & UAT strategy/plans.
• Able to write test scenarios and test cases from Business requirements and data mapping sheets to enable migrations, integrations and transformations.(any ETL tool must have)
• Perform RCA's, build analytics dashboard and monitor trends.( QE testing mindset)
• Good Knowledge of QET and Automation tools ( any)
• Played SDET roles in previous engagements ( Will be an advantage)

Data testing:( Min 10 year's experience )

• Hands on Strong SQL(Very comfortable with complex queries)
• Hands on Data Migration testing experience.
• Hands on Debugging and troubleshooting data errors or mismatch ( Any tool)
• Hands on experience in identifying data discrepancies by comparing data sets of different formats.

Domain:

• Marketing /media

Job Description

Campaign Data QA

Data Tasks

• Initial partner data QA - confirm partner provided spend/clicks/impressions data matches what is displayed in Singular
• Identifying discrepancies across Dalton/Partner/Singular data sets and escalate for further investigation if needed
• Validate that data fixes (run by Singular/Vendor/MM Eng) were successful

QA/Checking for BoF conversions after launch of new placements, vendors

• When new trafficking bases or new vendors are launched/tested, all data needs to be QAed Cirrus/Dalton.
• In the event that BoF does not come through in those reporting files/or that dataset...
  • Someone can check to see if that data exists in Singular (but for some reason is not coming through into Dalton file)

Capturing events that would cause major data issues, like Tracking Errors, as notes for Analytics (MANUAL)

• Summary: Sometimes there are issues with datasets (BoF missing) that cannot be fixed. There is not currently a good way to capture/note these events in datasets for historical reference. Examples:
  • URLs/Tagging being broken because of Vendor mis-trafficking (biggest/most recent examples from Samsung and Roku for TV+ Disto Marketing)
  • Tracking being broken because of LP or UI issues caused by Apple
  • App Store: Sometimes the LoB experiences under-deliveries and spend gets re-allocated to another partner - this context is a bit challenging to obtain and it's impact on data can be difficult to discern

Vendor Communications

• Partner data repair requests - submit requests to partners to update minor issues w/data (e.g. incorrect Metadata IDs used, data missing for specific dates, etc)
• Partner schema update requests - submit minor schema update requests to vendors and monitor progress
• Confirm existing vendor(s) are capable of providing data for new LOB
• Assist in configuring conversion data sharing w/vendor (e.g. configure postbacks, kick-off

Other

• Assist with URL QA requests
• Assist in maintaining data schemas / vendor and lob lookups
• Airtable debugging