ETL Tester

About Ascendion

Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.

Ascendion | Engineering to elevate life

We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:

• Build the coolest tech for worlds leading brands
• Solve complex problems and learn new skills
• Experience the power of transforming digital engineering for Fortune 500 clients
• Master your craft with leading training programs and hands-on experience

Experience a community of change makers

Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

About the Role:

Tittle Data QA/ETL Tester

Job Description

• 5 to 10 years of experience in Data/ETL/Datawarehouse Testing.
• Strong experience in Control-M tool, or experience in any other scheduling tools .
• Experience in writing SQL queries, data modeling and analytical skills on large data sets.
• Prior experience executing, debugging and leading RCA in failures on control jobs.
• Strong expertise in SQL Server, handling all the SQL objects.
• Strong understanding of End-to-End data warehousing systems from Data modeling to Reporting
• Experience in Informatica preferably, or experience in any ETL tool and knowledge in Informatica
• Experience in Agile Project are preferred.
• Knowledge or experience in IDQ and Tableau is an added advantage.
• Execute workflows in informatica and debug and do RCA in failures are found.
• Experience in preparing the Test artifacts needed for project delivery.
• Experience in working with Business and UAT for demo of Test scenarios.
• Experience in working with offshore and delegate the work properly on day to day basis.

Requirements

• 5-8 Year of ETL Testing Experience in Large Data warehouses.
• Ability to understand the scope of the work and ask clarifications and escalate to the right leads in case of issues/delays
• Advanced SQL skills. Including complex PL/SQL coding skills.
• Should have prior experience working with Control-M.
• Prior experience working/ troubleshooting Control M
• Proved track record creating complex PL/SQL scripts.
• Prior Experience in creating testing artifacts like Test Plan, Test Strategy, RTM, Defect Report and Test Closure.
• Prior experience as a data tester. Experienced in preparing test plans and executing test case.
• Prior Experience in working with Business/ UAT /Offshore.

Location : Dallas TX (Hybrid)

Salary Range: The salary for this position is between $90000 to $105,000 annually. Factors which may affect pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.

Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: [medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [long-term disability insurance] [short-term disability insurance] [5 personal days accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State] [10-15 days of paid vacation time] [6 paid holidays and 1 floating holiday per calendar year] [Ascendion Learning Management System]

Want to change the world? Let us know.

Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table.

Lets talk