| Urgent Onsite Position || SQL ETL Developer @State of Alabama at Alabama, New York, USA |
| Email: [email protected] |
| Email from Technix LLC Direct client position Position: SQL ETL Developer Duration: 11 Months Location: Alabama (Onsite from day one) Client: State of Alabama Agency: CUST3820841 Job ID: #890 JOB 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. REQUIRED SKILLS : 8+ years of IT experience focusing on 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.) Analysing 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). 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 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 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 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. PREFERRED SKILLS: 8+ years of IT experience focusing on 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.). Analysing 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). QUALIFICATION REQUIRED: Bachelors degree in related field Thanks & Regards S@ndhya Pandey : [email protected] Direct - 480-389-2901 -https://www.linkedin.com/in/sandhya-pandey-44635425a/ Phoenix, AZ, 85050 Note: We respect your online privacy. If you would like to be removed from our mailing list, please reply with "Remove" in the subject and we will comply immediately. We apologize for any inconvenience caused. Please let us know if you have more than one domain. The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient, be advised that the unauthorized use, disclosure, copying, distribution, or the taking of any action in reliance on this information is strictly prohibited. We are an equal opportunity employer with a diverse workforce. Technix LLC | Phoenix, AZ | phoenix, AZ 85050 US | Update Profile | Constant Contact Data Notice Keywords: csharp business intelligence information technology Arizona Idaho Urgent Onsite Position || SQL ETL Developer @State of Alabama [email protected] |
| [email protected] View all |
| Tue Oct 29 20:11:00 UTC 2024 |