Business System Analyst(Strong SQL & Healthcare must)

Role: Business System Analyst (Strong SQL & Healthcare must)

Location: Philadelphia, PA / hybrid (1-2 days a week on site client site)

Duration: 12+ months

Contract: C2C

Job Description:

Required Exp: 10+ Years Must

Healthcare Background is a must.

Strong in SQL: Hands on experience in Writing Complex SQLs using various functions like Ranking, Partition, Aggregations etc., analytical functions and UAT including critical problem-solving experience.

Business Analyst: Experience in Analyzing and defining end to end Business Process for Data warehouse ETL applications and support postproduction activities.

Data Analysis & Profiling: Experience in data cleansing, transformations, normalizations and discover information's from multiple sources. Having good analytical skills to identify logic to remove erroneous data and provide solutions to transform data for business requirements.

Data Warehouse: Experience in Slowly changing Dimension concepts, facts, dimensions, and different schemas. And modeling expertise is a plus.

BSA Documentation: Experience in creating Business Requirement Documents, Functional Requirement Documents and Source-to-Target Mapping documents for the development of Data Warehouse ETL applications. And provide walkthroughs to Dev/Test teams and perform UAT for requirement conformance.

Communication: Excellent verbal & written skills.

Healthcare: Good knowledge in Payer, Provider, Membership and Claim.

"Here is the detailed outcome for the interview":

Please go through the questions for better understanding.

SQL QUESTIONS

JOINS -

PARTITION BY

ROW_NUMBER

RANK

SCENARIO ON JOIN

UNION

DIFFERENCE BETWEEN JOIN AND UNION

GROUP BY

AGGREGATE FUNCTION

DATA WAREHOUSING QUESTION

NORMALIZATION

SCD TYPE

SCENARIOS ON NORMALIZATION

DOMAIN QUESTION/ETC

HEALTHCARE DOMAIN LIKE CLAIMS, AUTHS

BSA DOCUMENTS WORKED ON

DATA PROFILING

GAP ANALYSIS

IMPACT ANALYSIS.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.