| Urgent Position || SQL ETL Developer @ AL (Onsite) (ETL Tools & Database Tools) at Montgomery, Alabama, USA |
| Email: [email protected] |
| Email from Technix LLC Direct client position Position: SQL ETL Developer Duration: 10 Months Location: Montgomery, Alabama (Onsite) 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). o 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. o 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 o 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 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 o 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 Thanks, PRATIIK DESHMUUKH TECHNICAL RECRUITER Mail: [email protected], www.technixonline.com Direct: 480-389-2903 Phoenix, AZ, 85050 Technix LLC | Phoenix, AZ | phoenix, AZ 85050 US | Update Profile | Constant Contact Data Notice Keywords: csharp business intelligence information technology Arizona Urgent Position || SQL ETL Developer @ AL (Onsite) (ETL Tools & Database Tools) [email protected] |
| [email protected] View all |
| Mon Oct 28 19:03:00 UTC 2024 |