| SQL Developer|| Remote || No H1b at Remote, Remote, USA |
| Email: [email protected] |
| From: Vaibhav, Winorbit technology [email protected] Reply to: [email protected] Title: ETL Developer Visa: No H1B/CPT Location: Remote, Residents near Madison can choose Duration: 12 months Primary Skills: ETL, SSIS, SQL, PowerBI, Azure DevOps Looking for an ETL Developer for a contract position in Madison, WI. This position is responsible for providing technical expertise and services regarding the extract, transfer, and load of data for a the Department, including creating SSIS packages for the nightly build of the agencys data warehouse. The position is also responsible for creating ED Facts federal reporting files and fulfilling other state and federal data reporting requirements. The person in this position is responsible for peer testing of the work of their teammates including other ETL developers and dashboard developers. This position can either be on-site, hybrid or 100% remote. WI residency is not required. Residents near Madison can choose to come into the office if they desire Top Skills & Years of Experience: Expert knowledge and use of SQL Expert knowledge and use of SSIS (SQL Server Integration Services) Experience working on an Agile/Scrum team Nice to Have: Relevant Certification Experience with K-12 education data sector Knowledge of Power BI Candidate Qualities: Organized, self-motivated, independent worker needing limited managerial oversight. Team player who can communicate clearly and thoroughly. Enthusiastic in learning new technologies with excellent problem solving and analytical skills. Very good communication and interpersonal skills and has the ability to work independently as well as in a team environment. Example tasks: Complete SSIS programs for the Edvantage/WISEdash data warehouse based on completed ETL data mappings. Complete automation and schedules for extraction and load process. Provide recommendations and solutions for business rules, SSIS package development, and data structures. Support / troubleshooting of the development and production environments. ETL developer on high priority cross agency projects such as the Digital Equity Gap collection and reporting project. Gather and analyze end user requirements for new data loads for the data warehouse. Complete functional & technical specifications to load data from disparate source systems into the data warehouse for reporting and analysis. Design and develop Microsoft SSIS packages required to extract, transform, and load data into the data warehouse. Complete testing of packages and deploy to production. Maintain master build and the scheduling / automation for the nightly SSIS load. Add new packages to master build and scheduler as needed. Complete SSIS configuration tasks, troubleshooting of failed jobs and/or processes, issue identification and resolution. Knowledge about the scrum methodologies and agile practices Working with MS SQL Server 2016+ and Oracle databases Write queries /views/functions/stored procedures as needed Complete performance tuning tasks as necessary. Create operational processes including test cases & user documentation Using TFS (Visual Studio/Azure Dev Ops) for source code control, project related document sharing and team collaboration Regular maintenance of assessment loads in the data warehouse as it includes several districts Upgrading the SSIS packages in both file system and package deployment model to latest versions (currently upgraded to 2016) Work on generating the EDFacts files used for Federal reporting Develop Power BI Desktop reports and public to Power BI service. Work with Microsoft Azure databases and SSIS packages Other duties as assigned relating to the data warehouse project. Thanks and Regards Vaibhav Phone: +1 831-731-8629 Email: [email protected] Keywords: |
| [email protected] View all |
| Thu Nov 17 01:54:00 UTC 2022 |