ETL DEVELOPER

Role: ETL DEVELOPER

Location: Remote

Job Description:

This role supports organizational utilized payment integrity applications. Primary responsibilities will be to analyze, design, develop, implement and maintain technical solutions SQL Server Integration Services (SSIS) and T-SQL.

JOB ROLES & RESPONSIBILITIES:

1. Partner Business Analysts and other stakeholders to build and clarify requirements as appropriate.

2. Using SSIS and T-SQL in a SQL Server environment:

3. Utilizes system design expertise to extract data from various sources as appropriate.

4. Transforms data according to business requirements

5. Effectively loads data to various targets as necessary.

6. Develop and migrate to Azure - appropriately leveraging Azure Data Lake, Azure SQL Pools, Apache Spark, Synapse, Azure Data Factory/Synapse pipelines as necessary.

7. Builds performant and fault-tolerant solutions.

8. Effectively troubleshoots production data loading issues.

9. Utilizes expert proficiency in SQL development to build and implement process improvements.

10. Collaborate, coordinate, and communicate across disciplines and departments.

11. Ensure compliance with HIPAA regulations and requirements.

12. Demonstrate Company's Core Competencies and values held within.

13. Please note due to the exposure of PHI sensitive data -- this role is considered to be a High Risk and privileged Role.

14. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.

JOB SCOPE:

This role works under minimal supervision in completion of the roles day-to-day responsibilities and effectively keeps the needs of external and internal customers as a priority when making decisions and taking action. Work performed within the roles day-to-day tasks will likely often be varied and complex in nature.

REQUIREMENTS:

• Minimum Bachelors Degree 8%2B years of development experience with Informatica Power Center on Data Integration and Data management projects.

• At least 2%2B years Experience in Informatica Intelligent cloud services(IICS Must) Creates ETL Informatica Objects Involved in complete end to end ETL project lifecycle.

• Experience in Healthcare X12 Standards, Flat Files and various source and target file processing Strong analytic, problem-solving, multitasking and organizational skills.

• Debug and tune data integration processes; analyze data warehouse architecture, normalize/denormalize, troubleshoot and recommend improvements and alternate methodologies Excellent SQL/PLSQL knowledge and ability to write the complex queries keeping performance aspects in mind.

• Experience with analysis of business requirements, designing and writing technical specifications to design. Hands-on experience with UNIX shell scripting, GitHub and Jenkins.

• Participate in testing and issue resolution to validate functionality and performance. Good in Agile development methodology.

• Exceptional written and verbal communication skills Having IDMC Admin experience is a Plus