| SQL ETL Developer || onsite || Montgomery AL || USC GC GCEAD H4EAD at Montgomery, Alabama, USA |
| Email: [email protected] |
| Title: SQL ETL Developer Location: Montgomery AL (Onsite) Visa:- USC GC GCEAD H4EAD Position Description The SQL ETL Developer requires the ability twork on the analysis, design, and development of ETL packages and SSRS reports for DHR Dashboards project. Require a consultant whcan 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 intSQL Server Database. Assisting 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 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 textract, transform and load the data inttarget 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 Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, and implementations of Data warehousing Strong skills in ETL mappings tload the data from various sources intthe 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 tundertake challenging jobs. Able twork well independently and alsin a team by helping ttroubleshoot technology and business related problems Technical Skills 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. Thanks & Regards Ankit Rav Sr. Technical Recruiter : [email protected] Linkedin:- linkedin.com/in/ankit-choudhary-944b99238 Sibitalent Corp. Website: www.sibitalent.com 101 E. Park Blvd., Suite 600, Plano, TX - 75074 -- Keywords: csharp business intelligence information technology green card Alabama Texas SQL ETL Developer || onsite || Montgomery AL || USC GC GCEAD H4EAD [email protected] |
| [email protected] View all |
| Fri Oct 25 20:49:00 UTC 2024 |