Your browser does not support javascript! Please enable it, otherwise web will not work for you.

Senior Software Engineer - ETL @ Beyond Key

Home > DBA / Data warehousing

 Senior Software Engineer - ETL

Job Description

We are seeking an experienced ETL Developer with over 5 years of expertise in data transformation, integration, and visualization. The ideal candidate will have extensive experience in developing and maintaining ETL processes, data cleansing, data analysis, and implementing end-to-end BI solutions using the MSBI stack. Proficiency in SQL Server, T-SQL, and Azure cloud services is essential for this role.

Key Responsibilities:
  • ETL Development: Design, implement, and maintain ETL processes using SQL Server Integration Services (SSIS) for efficient data extraction, transformation, and loading.
  • Data Transformation Integration: Develop data transformation and integration solutions, ensuring data consistency and accuracy across systems.
  • Data Cleansing Validation: Perform data cleansing, validation, and enrichment to ensure high-quality data for reporting and analysis.
  • Data Analysis Mining: Analyze large datasets to uncover trends, patterns, and insights; perform data mining to support decision-making processes.
  • Data Visualization: Create and maintain visualizations to present data insights effectively to stakeholders.
  • Database Development: Develop and maintain database objects including tables, stored procedures, triggers, and user functions within a SQL Server environment.
  • BI Solutions: Implement end-to-end BI solutions using the MSBI stack, including SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).
  • Data Warehousing: Design and manage data warehouse solutions, including star schemas, snowflakes, and dimensional modeling.
  • Performance Optimization: Optimize T-SQL query performance, including query tuning, removing unnecessary columns, and establishing efficient joins.
  • Reusable Components: Create and manage reusable SSIS components for streamlined ETL processes.
  • Database Design: Contribute to physical and logical database design, data mapping, and table normalization.
  • Data Migration: Identify dimensions, facts, measures, and hierarchies for data migration to SQL Server databases.
  • Performance Tuning: Utilize DMV s, SQL Profiler, and Extended Events for database performance optimization, debugging, and tuning.
  • Cloud Services: Work with Microsoft Azure cloud services including Azure Blob Storage, Azure SQL Server, and Azure Data Factory.
  • Version Control: Use GIT (Azure DevOps) for version control and collaboration.
  • Agile/SCRUM: Participate in Agile/SCRUM methodologies for project management and development.
Required Qualifications:

  • Experience: Minimum of 5 years of experience in ETL development and data warehousing.
  • Technical Skills: Advanced proficiency in T-SQL, SSIS, and SQL Server database management.
  • BI Tools: Experienced with MSBI stack including SSRS and SSAS.
  • Data Warehousing: Strong knowledge of data warehousing methodologies and concepts such as star schemas, snowflakes, and dimensional modeling.
  • Performance Optimization: Skilled in optimizing T-SQL queries and database performance.
  • Azure Services: Experience with Microsoft Azure cloud services.
  • Agile/SCRUM: Familiarity with Agile/SCRUM project management methodologies.
  • Version Control: Proficient in GIT version control and Azure DevOps.
Preferred Qualifications:

  • Bachelor s degree in Computer Science, Information Systems, or a related field.
  • Certifications in Microsoft SQL Server or Azure Data Technologies.
  • Experience with additional BI tools and data visualization platforms.

Job Classification

Industry: Software Product
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Data warehouse Developer
Employement Type: Full time

Contact Details:

Company: Beyond Key
Location(s): Indore

+ View Contactajax loader


Keyskills:   Performance tuning Data analysis Data migration Database design Project management SSRS Debugging Stored procedures SSIS Data mining

 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Senior Specialist Cloud Database Engineer

  • Atlasrtx
  • 4 - 8 years
  • Pune
  • 3 days ago
₹ Not Disclosed

Senior IBM CMOD Developer

  • Luxoft
  • 5 - 10 years
  • Hyderabad
  • 3 days ago
₹ Not Disclosed

Technology Operations Analyst - Distributed apps

  • Ameriprise Financial
  • 2 - 4 years
  • Noida, Gurugram
  • 3 days ago
₹ Not Disclosed

Senior Technical Operations Analyst

  • Ameriprise Financial
  • 4 - 7 years
  • Noida, Gurugram
  • 3 days ago
₹ Not Disclosed

Beyond Key

Company DetailsBeyondKey