SQL ETL Developer
Gdh Consulting, Inc.

Job Info

---

Job Description:
GDH Consulting is hiring a highly skilled and experienced SQL ETL Developer 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.

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 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 o 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 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
  • 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 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

Experience Required:

• 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).
• 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.
• Strong understanding of Data Modeling (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
• 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 in a team by helping to troubleshoot 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

Education Required:

• Bachelor's degree in related field

About GDH:
At GDH, we believe in the power of people and the importance of caring. Our culture statement, "We care about people," isn't just a tagline - it's the core of everything we do. GDH is a premier staffing and talent solutions company dedicated to helping businesses find the best talent and assisting job seekers in finding their dream jobs.

Who We Are:
GDH, founded in 2001, has grown into a leader in providing staffing solutions across various industries. We specialize in IT across several sectors, connecting top talent with leading enterprises. As a Best of Staffing firm recognized for excellence in client, employee, talent, and women's services, we pride ourselves on our commitment to quality and service.

Benefits of Working for GDH:

• Professional Development
• Competitive pay
• Full health insurance
• 401k Plan
• Holiday Pay
• Gym Membership Reimbursement
• Weekly Paycheck & Direct Deposit
• & More!

GDH provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetic information, veteran's status or any other category protected by law. In addition to federal law requirements, GDH Consulting, Inc. complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities and/or employees. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, benefits and training. Applicants with disabilities that require an accommodation or assistance in applying and/or for interviewing, please contact our HR Department.

Please visit our notice of collection for California applicants.

---