*Greetings !!!* *Senior ETL/DW Tester*
*Milwaukee, WI – f2f interview* *6+ months * Experience writing complex queries to validate large volume of data. Write multiple sub queries using complex joins. Derive relationship from multiple tables to validate the transformation using logical statements. Understanding and writing complex queries using DIM and data Marts. Hands on experience in using SQL analytical functions to manipulate data and validate transformation. Experience in data setup including creating test data and data mockup for various sources like Flat File, Data base and MainFrame files. Understanding of ETL concepts and experience validating Data Marts, Online Transactions Processing (OLTP) and predictive analysis. Preparing SQL queries for data transformation and data quality during and after data load. Hands on experience in validating the transformation logic across databases and sources like - Sybase, DB2, Flat File, MySQL MainFrame File. Nice to have • Automating data validation SQLs using Unix script • Hands on experience in scheduling and running jobs *Thank you,* *Vijay,* *|| Phone: 732 694 6000 Ext 784 || E-mail ID : vij...@astirit.com <vij...@astirit.com> ||* -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
