Data Analyst || Bethpage, NY || GC and Citizen || Phone & Face to Face

[saurabh jangid]

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 ***@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: [phone]

Email: ***@tresourceinc.com | Web: www.tech-resource.com

Gtalk: trg.saurabh | YIM : saurabh4jangid