Search Jobs
Browse the latest opportunities at TPI Global.
TPI Global (formerly Tech Providers, Inc.)
https://techproviders.com/wp-content/uploads/2022/06/Logo-Color.png
http://www.tpiglobalsolutions.com
http://www.tpiglobalsolutions.com
true
SQL ETL Developer
Posted: 10/23/2024
2024-10-23
2024-12-04
Job Number: 23398021
Job Description
Title: SQL ETL Developer
Location: Montgomery, AL, 36104 (Onsite)
Duration: 12+ month contract
Locals willing to go for in-person interview Preferred
Position Description
Experience Required
Location: Montgomery, AL, 36104 (Onsite)
Duration: 12+ month contract
Locals willing to go for in-person interview Preferred
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.
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
Meet Your Recruiter
Share This Job:
Related Jobs:
There are currently no related jobs. Please sign up for Job Alerts.
Loading...
Login to save this search and get notified of similar positions.
About Montgomery, AL
Discover exciting job opportunities in Montgomery, Alabama! Nestled in the heart of the South, Montgomery offers a unique blend of history, culture, and charm. From the historic Civil Rights landmarks like the Rosa Parks Museum and Dexter Parsonage Museum to the vibrant arts scene at the Montgomery Museum of Fine Arts and Alabama Shakespeare Festival, this region has something for everyone. Enjoy the delicious Southern cuisine, catch a game with the Montgomery Biscuits minor league baseball team, or explore the lush parks and scenic riverfront. Take the next step in your career journey and explore our job listings in Montgomery today!
Are you sure you want to apply for this job?
Please take a moment to verify your personal information and resume are up-to-date before you apply.