One among our US primarily based shoppers are searching for a SQL Developer with 5+ years’ expertise extracting information from a wide range of platforms, performing information mapping, information transformation, and loading information to the goal system. The place requires robust system and course of evaluation, ETL (SSIS), and T-SQL expertise. The SQL Developer can be chargeable for constructing and sustaining an information warehouse, together with all information modeling, ETL, and growth.
- Design database objects as essential to fulfill ongoing enterprise wants for reporting
- Tables, Views, Saved Procedures, Features, Jobs, and so forth.
- Preserve and assist current saved procedures, features, views, and so forth.
- Assist Supplier information repository performance and clean-up effort
- Assist QC information integration; question current information to provide correctly formatted textual content information primarily based on design specs supplied
- Doc new ETL processes
- Design, construct, take a look at, and execute ETL packages (utilizing SSIS)
- Automate ETL jobs for recurring imports
- Create information file extractions and scripts (utilizing T-SQL) to carry out information associated imports and information associated duties
- Work with information homeowners to grasp legacy information and collect information necessities from the enterprise. Be capable of produce detailed information mapping paperwork
- Carry out information evaluation and advocate information optimization/efficiency alternatives
- Growth and implementation of Energy BI
- Different duties assigned as wanted
- 5+ years of superior expertise utilizing Microsoft SQL Server, SSAS, SSRS, SSIS, and TSQL languages. (SQL Server 2016 most well-liked)
- Applicant should have a stable understanding of community and message processing applied sciences together with HTTP, TCP/IP, TELNET, and Sockets
- Intensive expertise creating queries, reviews, and types in database applications.
- Should show data of ETL (Extract-Rework-Load) ideas
- Will need to have prior expertise creating ETL applications utilizing SSIS
- Expertise retrieving information from numerous database platforms, internet service APIs, flat information, and so forth.
- Knowledge Modeling – understanding of normalization, transactional vs. reporting pushed design, and information warehousing ideas
- Advanced Question Design
- Saved Procedures, Views, Features
- SQL Agent – Job creation, schedule creation
- SSIS – Design, develop, take a look at and deploy packages
- Expertise creating with Energy BI a plus.
Flexibility working in US/SA hours – Absolutely Distant – Full-time – Lengthy-term Contract
- Knowledge Modelling
- Energy BI
- SQL Server
Desired Work Expertise:
- 5 to 10 years Knowledge Evaluation / Knowledge Warehousing
Desired Qualification Degree:
About The Employer:
– Place is Absolutely Distant
– Full Time roles
– Work in each US/SA hours (50/50)
– Worldwide publicity
Employer & Job Advantages: