• 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 :- ( )

• Post :- 24th Aug 2022

ETL Developer
Description: 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)