Fresher & Experienced IT Jobs: {SAP JOBS USA:149951} Data Analyst || Bethpage, NY || GC and Citizen || Phone & Face to Face

Monday, July 6, 2015

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 sjangid@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

Gtalk: trg.saurabh | YIM : saurabh4jangid

Search This Blog