Analyst(ETL) Remote

Eden Prairie, MN - USA

Monthly Salary: Not Disclosed

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

Description:

7. What is the specific title of the position

Sr. Data Analyst

8. Work location

MN101

9. Work Location Type

100% Telecommute

9a. How many days would the resource need to come into the office

10. Work hours (ex. 9am-5pm day/night shifts rotating shifts etc)

9am - 5pm ET

12. What skills/attributes are required (please be detailed as to number of years of experience for each skill)

5 years of experience with Informatica PowerCenter.
5 years of experience in Oracle & PL/SQL with strong coding and performance tuning skills.
2 years of experience in scripting languages (Python Shell etc.).
2 years of experience in data analysis.
Experience with data modeling techniques for data warehouse environments.
2 years of healthcare data experience (Medicaid Medicare Exchange or commercial payer).
Strong understanding of data warehouse and database design principles.
Experience with performance tuning and optimization.
Excellent problem-solving skills attention to detail and ability to work independently and collaboratively.
Strong communication and collaboration skills.
Experience with Informatica Data Quality and Test Data Manager.

13. What skills/attributes are preferred (what will set a candidate apart)

Knowledge of HIPAA regulatory security requirements.
Experience with 834 837 NCPDP transactions.
Familiarity with modern technologies such as Snowflake Databricks Azure AWS.
Advanced Oracle experience.

14. Does this position require a professional license or certification

14a. Please list all necessary professional license or certifications

15. Can you please provide a summary of the project/initiative which describes whats being done

We are seeking a skilled and motivated Informatica ETL Developer to join our team. This role is responsible for designing and delivering ETL frameworks and components within a multi-terabyte Oracle Exadata environment that integrates public and private healthcare encounter and enrollment data from New York State (NYS) healthcare plans. Using Informatica you will synthesize data to support the management evaluation and analysis of the NYS healthcare system. This is a hands-on technical role requiring comprehensive knowledge of the Informatica product suite including:
PowerCenter
Test Data Manager
Master Data Management
Metadata Manager
Data Quality You will be accountable for sourcing data from NYS healthcare plans staging auditing cleansing enriching and loading data into the NY All Payer Database (APD) reporting structures in Oracle.

16. What does the ideal candidate background look like (ex: healthcare specific background etc.) We want to be as specific as possible with our firms so they can find the type of candidate youre looking for.

healthcare specific background

17. Of the required skills listed which would you consider the top 3 Please list your expectations regarding years of experience for each requirement.

18. What experience will set candidates apart from one another

healthcare specific background

19. (If a Contract to Hire) Are you open to candidates that cannot convert to FTE without sponsorship

Yes

20. What does the team structure look like how many members and what is the break-down of the teams skill sets (ex: 1 PM 4 Developers etc.)

1 Project Manager 4 Developers

21. What does the interview process look like

a. How many rounds

b. Video vs. phone

Video

c. How technical will the interviews be

Technical

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No

N/A

Stipend :true

Description:7. What is the specific title of the positionSr. Data Analyst8. Work locationMN1019. Work Location Type100% Telecommute9a. How many days would the resource need to come into the office10. Work hours (ex. 9am-5pm day/night shifts rotating shifts etc)9am - 5pm ET12. What skills/attributes ...