Hi , This is Saurabh Jangid from Technology Resource Group Inc.
You can reach me at 408-709-1760 ext 984. kindly share your Updated Resume At sjan...@tresourceinc.com *Job Description :* *Role : Data Analyst* *Location : Bethpage, NY* *Duration : 6+ Months* *GC and Citizen* *Local Only* *Skills :* - Bachelor’s Degree in Computer Science, Mathematics, Statistics, other applied science field - *3-5 years analytical work experience* - *4+ experience in data quality testing, with a minimum 1 year experience in enterprise data warehouse environments* - Strong hands-on SQL coding experience - Experience testing data for data marts, data warehouses, and data integration solutions - Experience with ETL tools such as Informatica is a plus - *Experience in test automation using tools such as Query Surge, Trillion, QTP* - Excellent verbal and written communication skills - Good Excel, Powerpoint, Word and Visio skills - Experience of working with offshore or outsourcing teams is highly sought - Strong working knowledge of SQL – Able to query complex datasets and derive conclusions, including using all types of joins between multiple tables - Competency in data manipulation and analysis: accessing raw data in varied formats with different methods and analyzing and processing data. - Ability to communicate the results of analyses in a clear and effective manner - Positive attitude with lots of energy - Highly detail oriented and organized with the ability to multi-task and work in a very fast paced environment - Ability to exercise discretion on sensitive or confidential matters . *End to end data quality process for ETL/BI and Reporting projects includes:* *Data Collection* a) Check compliance for data quality parameters like completeness, accuracy, consistency, etc. b) Risk assessment for integrating data in new applications. c) Ensuring that all data has been transformed correctly during the extract-transform-load (ETL) process. d) Ensuring that the ETL process correctly rejects, substitutes default values, corrects or ignores and reports invalid data. *Data Integration* e) Check compliance and define approach with custom SQLs for integration rules. f) Validate results based on business rules and integration rules. g) Provide data quality reports. *Data Mart* h) Validate all the measures and measure groups (including derived measures, aggregations). i) Validate all the dimensions (including Slowly Changing Dimensions), attribute hierarchy, etc. *Regression Testing* j) Ensuring existing functionality remains intact each time a new release of code is completed. *Data Presentation* k) Ensure data from the data mart is mapped & designed correctly for reports. Validate data for derived metrics and ‘non-aggregatable’ metrics THANK YOU, Saurabh Jangid Technical Recruiter *Technology Resource Group Inc.* 3736 Hills-dale Court Santa Clara, CA 95051 Office: 408-709-1760 , Ext: 984 | Fax: 408-884-2409 Email: sjan...@tresourceinc.com | Web: www.tech-resource.com Gtalk: trg.saurabh | YIM : saurabh4jangid -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.