Hi ram,
Hope you are doing well.
Role: Business System Analyst (Healthcare & strong ETL exp must)
Location: Philadelphia / hybrid
Duration: Long term
Contract: C2C
Required Exp: 12 Years must.
Job Description:
Healthcare Background is a must.
· Healthcare: Good knowledge in Payer, Provider, Membership and Claim.
· Strong experience in ETL
· 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 post production 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.
Required Skills:
SQL:
· 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.
