TalentBurst
SQL ETL Developer
TalentBurst, Montgomery, Alabama, United States, 36136
SQL ETL DeveloperMontgomery, AL/ 100% onsiteLong term contract
Position DescriptionThe SQL ETL Developer requires the ability to work on the analysis, design, and development of ETL packages and SSRS reports for DHR Dashboards projectRequire a consultant who can work with all aspects of Data warehouse and DataMart for DHR Dashboards projectHe/She should be responsible for developing, scheduling and implementing SSIS packages for loading data from multiple resources into SQL Server DatabaseAssisting the Project Manager, Database Administrator, and Power BI developer with requirements gathering, migration planning, Security Access, and implementation of Dashboards
Skills Required
8+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business IntelligenceData 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 systemsSQL Server database with ETL (SSIS, SSAS) and reporting tools (SSRS)Developing complex SSRS reports using SSIS packages.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 warehousingStrong 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 scriptsStrong communication, decision making and organizational skills along with outstanding analytical and problem solving skills 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 2018ETL tools - Microsoft SSIS, SSAS, SSRSBI & Reporting - Microsoft Power BI ToolsData Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling (Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables), Entities, Attributes, CardinalitySQL Stored procedures, Functions, Views and triggers
Education RequiredBachelor's degree in related field
Additional Information-Candidate will work onsite, full timeNO remote work will be considered-In person interviews are preferred, however will video interview for non localIt may be asked that you provide details from your video interview of candidates that are submitted whare only available for vide(ID/details/screenshot) -2 completed professional references may be requested -This is strictly a contract position
#TB_EN
Position DescriptionThe SQL ETL Developer requires the ability to work on the analysis, design, and development of ETL packages and SSRS reports for DHR Dashboards projectRequire a consultant who can work with all aspects of Data warehouse and DataMart for DHR Dashboards projectHe/She should be responsible for developing, scheduling and implementing SSIS packages for loading data from multiple resources into SQL Server DatabaseAssisting the Project Manager, Database Administrator, and Power BI developer with requirements gathering, migration planning, Security Access, and implementation of Dashboards
Skills Required
8+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business IntelligenceData 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 systemsSQL Server database with ETL (SSIS, SSAS) and reporting tools (SSRS)Developing complex SSRS reports using SSIS packages.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 warehousingStrong 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 scriptsStrong communication, decision making and organizational skills along with outstanding analytical and problem solving skills 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 2018ETL tools - Microsoft SSIS, SSAS, SSRSBI & Reporting - Microsoft Power BI ToolsData Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling (Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables), Entities, Attributes, CardinalitySQL Stored procedures, Functions, Views and triggers
Education RequiredBachelor's degree in related field
Additional Information-Candidate will work onsite, full timeNO remote work will be considered-In person interviews are preferred, however will video interview for non localIt may be asked that you provide details from your video interview of candidates that are submitted whare only available for vide(ID/details/screenshot) -2 completed professional references may be requested -This is strictly a contract position
#TB_EN