Sign in

Data Analyst - Chiacago, IL

Company:
XTGlobal- Sankar
Location:
Chicago, IL
Posted:
November 08, 2019

Description:

Location: Chicago, IL

Interview: Phone Screen and Onsite Interview – MUST BE LOCAL IN ILLINOIS

Rate: DOE

Data Analyst

(Min 10 yrs. of experience with ERP application)

• Work closely with business, IT teams and help team to understand and document requirements

• Work with application teams, SME’s to understand source systems and produce mapping documents for new solutions.

• Study / Analyze source application documents, data models, data profiling and flush out technical requirement documents.

• Good understanding of Database Design, Integrity, and optimization process.

• Good understanding and prior experience in working with ERP conversion/migration projects for data analysis and data conversions.

• Write SQL Code for Data Profiling, Data Quality & Data Validation

• Work with technical teams to build the desired solution as per requirements

• Perform Data validation

• Functional testing of applications

• Strong Analytical and problem solving skills

• Perform data extraction and transformation activities

• Strong SQL / Advance SQL Skills (SQL Server, Oracle)

• Good to have knowledge of Data Modeling, Data Warehousing and data virtualization concepts.

• Good to have knowledge of data Integration, application integration experience

• At least 10 - 12 years of experience in data analysis and SQL

• Be able to write analyze and tune complex SQL scripts

• Able to derive transformation rules from complex SQL scripts

• Expert level experience in using relational databases Oracle,SQL Server with SQL and PLSQL

• Have excellent communication skills and partner with both Business & Technology stakeholders

• Analyze existing data platform and sources and formulate new designs and capabilities

• Devise logic procedures, prepare flowcharts, perform ETL/coding, and test/debug output

• Develop conversion and standardization plans

• Prepare and obtain approval of system and programming documentation

• Recommend changes in development, maintenance, and system standards

Thanks & Regards,

Sankar

Business Development Executive

sankar@xtglobal.com

2701 Dallas Parkway, Suite 550

Plano TX, 75093

Direct: 972.996.1009

Fax: 888-614-8206