Senior Database Engineer (SSIS)
Eurofins Scientific SE6 days ago
Bengaluru, IndiaSenior
Responsibilities
- Design, develop, test, and maintain SQL Server Integration Services packages and enterprise ETL solutions.
- Integrate data from databases, flat files, APIs, cloud platforms, and third-party applications.
- Develop enterprise data warehouses, data marts, staging environments, dimensional models, star schemas, and snowflake schemas.
- Write and optimize complex T-SQL queries, views, functions, stored procedures, common table expressions, and window functions.
- Analyze execution plans and improve performance through query tuning, indexing, and partitioning.
- Implement data cleansing, validation, reconciliation, governance, metadata documentation, and data quality controls.
- Create reporting views and reusable datasets to support Power BI, SSRS, Tableau, analysts, and business users.
- Troubleshoot ETL failures, performance bottlenecks, data discrepancies, and production issues.
- Maintain technical documentation and collaborate with developers, DBAs, business analysts, project managers, and stakeholders.
- Support architecture reviews, production deployments, post-implementation troubleshooting, and automation of manual data processing.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, or a related discipline.
- 5+ years of hands-on experience in data warehouse development.
- 5+ years of SQL Server development experience.
- 3+ years of experience developing and supporting SSIS packages and ETL solutions.
- Experience with large enterprise databases and high-volume transactional systems.
- Advanced T-SQL programming and experience with stored procedures, views, functions, common table expressions, window functions, query optimization, execution plan analysis, and indexing strategies.
- Knowledge of ETL/ELT methodologies, dimensional modeling, star and snowflake schemas, slowly changing dimensions, fact and dimension tables, data governance, and master data management.
- Experience with Azure DevOps or Git, data validation, reconciliation, and root cause analysis.
- Preferred experience with Azure Data Factory, Azure SQL Database or Synapse Analytics, Power BI semantic models and datasets, and data lake or modern analytics architectures.
- Microsoft DP-203, DP-300, or related certifications are preferred.
- Strong analytical, problem-solving, communication, organizational, customer-focused, and continuous-improvement skills.
Benefits
- Hybrid work arrangement with 3 days in the office in Bangalore.
- Work hours are either 8:00 AM to 5:00 PM IST or 12:00 PM to 9:00 PM IST.
Tech Stack
GitMicrosoft SQL Server
Categories
Data Engineering
About Eurofins Scientific SE
Eurofins Scientific SE provides laboratory-based analytical testing and contract research for food, environmental, pharmaceutical, cosmetic, and clinical diagnostics customers. Its fee-for-service model spans a global network of roughly 900 laboratories across 50+ countries, delivering methods for safety, identity, and regulatory compliance. Founded in 1987 in Nantes and headquartered in Luxembourg, it is publicly traded on Euronext Paris.