Senior Software Engineer - ETL
- Beyond Key
- 5 - 6 years
- Indore
- 2 months ago
- Email to a friend
- Report this job
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 ProductFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse DeveloperEmployement Type: Full timeContact Details:
Company: Beyond KeyLocation(s): Indore+ View Contact
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
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in