Sr. ETL Developer | 100% Remote | W2 Profiles

Title: Sr.

ETL Developer Location: Remote Job Description: Responsibilities: Design, develop and implement scalable and high-performance data pipelines that performs ETL loads into enterprise repositoryCollaborate with various business units to gather requirements, transforms the requirements into technical solutionsWrite efficient store procedures/packages, provide operational support, diagnose, and resolves production issues, superior troubleshooting skillsDevelop code to extract data from various cloud environments (Azure, Snowflake) and stage the data on PremCreate dataset from staged environment for AI team, upload the dataset to AI cloud environmentCollaborate with AI team to understand the data requirements, perform data mapping, extract the required data from multiple source systemsProficient in writing advance T SQL’s, write store procs, developing SSRS reports, troubleshoot existing reports, suggest, and apply appropriate fixes Independently review and schedule new jobs, resolves performance issues stemming from inefficient queriesLead efforts in troubleshoot query performance issues, pro-actively collaborate with DBA team to resolve query/database lockingReview the existing integrations (ETL – Extract Transform Load) of legacy/new systems process, suggest and lead design modifications Lead effort in peer code review before promoting to production, ensures production stability is maintainedSupport, maintain and document BI functionality, regularly review and update document on share-point