SQL ETL Developer

TPI Global Solutions


Date: 4 weeks ago
City: Montgomery, AL
Contract type: Contractor
Title: SQL ETL Developer

Location: Montgomery, AL, 36104 (Onsite)

Duration: 12+ month contract

Position Description

Locals willing to go for in-person interview Preferred

  • 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.

Experience Required

  • 8+ years of IT experience focusing on o Data warehousing, Data modelling, 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 o 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 Modelling (Relational, dimensional, Star and Snowflake Schema), Data analysis, and implementations of Data warehousing
  • 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 problem-solving skills to undertake challenging jobs.
  • Able to work well independently and also in a team by helping to troubleshoot technology and business-related problems

Technical Skills

  • Database - Microsoft SQL Server 2018
  • ETL tools - Microsoft SSIS, SSAS, SSRS
  • BI & Reporting - Microsoft Power BI Tools
  • Data Modelling - Logical Modelling, Physical Modelling, Relational Modelling, ER Diagrams, Dimensional Data Modelling (Star Schema Modelling, Snowflake Schema Modelling, FACT and Dimensions Tables), Entities, Attributes, Cardinality
  • SQL Stored procedures, Functions, Views and triggers

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Legal Operations Associate - US

EvenUp, Montgomery, AL
$50,000 - $58,000 per year
1 week ago
EvenUp is on a mission to support injury law firms across America in providing a consistent and high standard of representation, ensuring that every injury victim who seeks legal assistance can expect a fair resolution. We’ve helped thousands of victims get fair compensation by empowering their representation with best-in-class insights, automation, and document creation.Legal Ops Associates help ensure that the...

Postal Mail Processor - No Experience Required

Postal Jobs Source, Montgomery, AL
$24.63 - $39.27 per hour
3 weeks ago
POSTAL MAIL PROCESSORNo Experience Required – Paid Training Provided – Job SecurityThe Postal Service is the largest government related agency in terms of employees. The Postal Service currently employs nearly 1 million people and is hiring nationwide. There is NO experience required, paid training is provided for all job openings. There are MANY different positions available. The job openings range...

Contracts Coordinator (Remote)

8VC, Montgomery, AL
$64,800 - $81,000 per year
3 weeks ago
At Iron Mountain we know that work, when done well, makes a positive impact for our customers, our employees, and our planet. That’s why we need smart, committed people to join us. Whether you’re looking to start your career or make a change, talk to us and see how you can elevate the power of your work at Iron Mountain.We...