Hi ram,
Hope you are doing well.
Please share the suitable profiles (Strong SQL & Healthcare- Required Exp: 10+ Years 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.
