drjobs SQL Developer

SQL Developer

Employer Active

drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Alexander City - USA

Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Job Description

Position: SQL Developer

Duration: 10 months

Location: Montgomery AL (Onsite from day 1)

Position Description

The SQL ETL Developer requires the ability to work on the analysis design and development of ETL packages and SSRS reports for DHR Dashboards project. Require a consultant who can work with all aspects of Data warehouse and DataMart for DHR Dashboards project. He/She should be responsible for developing scheduling and implementing SSIS packages for loading data from multiple resources into SQL Server Database. Assisting the Project Manager Database Administrator and Power BI developer with requirements gathering migration planning Security Access and implementation of Dashboards.

Skills/Experience Required:

  • 8 years of IT experience focusing on o Data warehousing Data modeling Data integration Data Migration ETL process and Business Intelligence o Data analysis and/or reporting along with strong knowledge of database and related technologies (SQL OLAP etc.)
  • Analyzing the multiple source systems and based on the business requirements build the transformation rules to extract transform and load the data into target systems
  • SQL Server database with ETL (SSIS SSAS) and reporting tools (SSRS).
  • Developing complex SSRS reports using SSIS packages. o Implementing .Net C# script tasks in SSIS
  • Deep understanding of the Data Warehousing SDLC and architecture of ETL reporting and BI tools.
  • Strong understanding of Data Modeling (Relational dimensional Star and Snowflake Schema) Data analysis and implementations of Data warehousing o Strong skills in ETL mappings to load the data from various sources into the Data warehouse with different transformations like Source Qualifier Expression Lookup Aggregate Update Strategy and Joiner.
  • Developing stored procedures functions Views and Triggers Complex queries using SQL Server and TSQL
  • Database Development and Analysis
  • Scheduling ETL and Data Refresh scripts
  • Strong communication decision making and organizational skills along with outstanding analytical and problemsolving skills to undertake challenging jobs.
  • Able to work well independently and also in a team by helping to troubleshoot technology and businessrelated problems Technical Skill
  • Database Microsoft SQL Server 2018
  • ETL tools Microsoft SSIS SSAS SSRS
  • BI & Reporting Microsoft Power BI Tools
  • Data Modeling Logical Modeling Physical Modeling Relational Modeling ER Diagrams Dimensional Data Modeling (Star Schema Modeling Snowflake Schema Modeling FACT and Dimensions Tables) Entities Attributes Cardinality
  • SQL Stored procedures Functions Views and triggers

Skills Preferred:

  • 8 years of IT experience focusing on Data warehousing Data modeling Data integration Data Migration ETL process and Business Intelligence
  • Data analysis and/or reporting along with strong knowledge of database and related technologies (SQL OLAP etc.)
  • Analyzing the multiple source systems and based on the business requirements build the transformation rules to extract transform and load the data into target systems
  • SQL Server database with ETL (SSIS SSAS) and reporting tools (SSRS).

Qualification Required:

Bachelors degree in related field

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.