*Job Title* *Data Tester – ETL Testing, DW, SQL, Big Data*
*Project Location* *Roseland, NJ* *Duration* *6+ Months contract * *Interview Process: Phone + F2F* *Visa: USC, GC, EAD-GC Only* *Job Description* *Responsibilities:* • Define ETL testing process and validate business rules and policies to data and transformations including all data pipelines on *Hadoop Clusters, monitoring data activities in Kafka, Spark, etc* • *Understand the data model and ETL flow* • Validate the data from the data sources through each step of the extract and transformation process including final load in the data warehouse • Develop and review test plans and test scripts • Ensure accurate data and reporting, in terms of content and infrastructure by researching and identifying source of errors *•* *Write SQL scripts to extract data from various databases and systems and compare against data warehouse* • Perform root cause and trend analysis to identify recurring patterns of errors • Ensure data standards/integrity are maintained in order to deliver the highest quality products • Develop and automate integration, functional, and system test scripts • Present the findings to project stakeholders *Minimum Qualifications:* • Experience in large scale data warehouse projects • *Solid understanding of data architecture and ETL workflows* • *Strong SQL analysis skills with experience writing simple to complex SQL queries* • *Exposure to big data testing, Kafka and Spark streaming* *•* *Knowledge in Java & Informatica preferable, but not required* • Excellent communication, documentation and presentation skills *•* *Experience with working on Agile/Scrum method of product implementation and delivery* Thanks & Regards <http://www.tekshapers.com/> Udbhav Mathur Technical Recruiter Ph:248-565-4747 *130 Email:- umat...@tekshapers.com <tar...@tekshapers.com> Smart Works, for smart IT solutions A Certified WMBE Company http://www.tekshapers.com -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.