• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 2nd Sep 2022

ETL Developer Description: UST Global® is looking for a talented and creative ETL Developer for one of the leading healthcare providers in the United States. This is an excellent opportunity to work in a growing environment. The ideal candidate must have strong skills in ETL, Microsoft SSIS, PL/SQL at the same time be able to put their creative hat in a problem-solving environment. Excellent written and verbal communication skills with the ability to collaborate effectively with domain experts and IT leadership team is key to be successful in this role.

Responsibilities for ETL Developer:

Primary and required

Good understanding of ETL framework and concepts, Microsoft SSIS

Informatica- Develop and support Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate SQL Server tables and flat files

Develop and deploy the code in Informatica for import/export of data into the application

Experience with complex SQL Server PL/SQL, Stored Procedures, Views

Experience with Oracle PL/SQL, Procedures, Package development

Implement stored procedures and effectively query a database.

Develop SSRS reports, Test and deploy.

Create SQL Server Stored Procedures.

Develop and deploy the job scheduling in Tidal.

Troubleshoot ETL process and Query tuning

Provide support and fix issues in the ETL packages.

Author and execute unit test scripts.

Optimize database systems for performance efficiency.

Database programming, SQL performance tuning, data modeling, ETL job scheduling, Windows batch scripting.

Secondary

Programming languages - C#, JavaScript, Typescript(good to have)

Possess knowledge on XML & JSON– structure, elements

FACETS knowledge(nice to have)

Tools

JIRA, Confluence , Atlassian tools, Subversion, Bitbucket

Scrums Agile, Dev Ops’(Nice to have)

Additional

Good Communication Skills

Health Care Knowledge - Domain certifications(nice to have)