Asd
SQL ETL Developer - 2251
Asd, Montgomery, Alabama, United States, 36136
Advanced Systems Design is seeking a
SQL ETL Developer
for our client located in
Montgomery, AL .This position is onsite in Montgomery, AL, and requires in-person availability starting day 1.Job Overview:The SQL ETL Developer must be able to analyze, design, and develop ETL packages and SSRS reports for the DHR Dashboards project.Require a consultant who can work with all aspects of Data Warehouse and DataMart for the project.The candidate will 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.Required Qualifications: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 databases and related technologies (SQL, OLAP, etc.)Analyzing the multiple source systems and based on the business requirements building 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 SSISDeep 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 TSQLDatabase Development and AnalysisScheduling 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 problemsTechnical 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 Required:Bachelor’s degree in related fieldAdvanced Systems Design, Inc. is:A leading Information Technology provider for Federal, State & Local government agencies.A certified minority-owned small business government contractor with capabilities related to Public Health IT, Criminal Justice, Transportation, and Defense.A certified service-disabled veteran-owned company with a proud 42-year track record of providing successful innovative solutions for our government customers.A drug-free workplace in accordance with the Drug-Free Workplace Act of 1988.For additional information regarding Advanced Systems Design, please check out our
WEBSITE
or click
HERE
for all current job openings.Advanced Systems Design is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
#J-18808-Ljbffr
SQL ETL Developer
for our client located in
Montgomery, AL .This position is onsite in Montgomery, AL, and requires in-person availability starting day 1.Job Overview:The SQL ETL Developer must be able to analyze, design, and develop ETL packages and SSRS reports for the DHR Dashboards project.Require a consultant who can work with all aspects of Data Warehouse and DataMart for the project.The candidate will 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.Required Qualifications: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 databases and related technologies (SQL, OLAP, etc.)Analyzing the multiple source systems and based on the business requirements building 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 SSISDeep 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 TSQLDatabase Development and AnalysisScheduling 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 problemsTechnical 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 Required:Bachelor’s degree in related fieldAdvanced Systems Design, Inc. is:A leading Information Technology provider for Federal, State & Local government agencies.A certified minority-owned small business government contractor with capabilities related to Public Health IT, Criminal Justice, Transportation, and Defense.A certified service-disabled veteran-owned company with a proud 42-year track record of providing successful innovative solutions for our government customers.A drug-free workplace in accordance with the Drug-Free Workplace Act of 1988.For additional information regarding Advanced Systems Design, please check out our
WEBSITE
or click
HERE
for all current job openings.Advanced Systems Design is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
#J-18808-Ljbffr