Job Title: Solution Database Engineer
Work Location: Bangalore
Shift timings: 8.00am to 5.00pm OR 12.00pm to 9.00pm IST
Work mode: Hybrid - 3 Days office
Role Summary:
We are seeking an experienced Data Warehouse Developer to design, develop, and maintain enterprise data integration solutions that support business intelligence, analytics, operational reporting, and data-driven decision-making. The successful candidate will be responsible for building and optimizing ETL processes, developing SSIS packages, designing data warehouse solutions, and creating efficient SQL queries and stored procedures to extract, transform, merge, and deliver data from multiple systems.
This role requires strong expertise in Microsoft SQL Server technologies, data modeling, data governance, performance tuning, and large-scale data integration.
Key Responsibilities
Data Integration & ETL Development
Design, develop, test, and maintain SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL).
Integrate data from multiple internal and external sources, including SQL Server databases, flat files, APIs, cloud platforms, and third-party applications.
Develop robust error handling, logging, and monitoring mechanisms within ETL processes.
Troubleshoot and resolve ETL failures, performance bottlenecks, and data quality issues.
Data Warehouse Development
Design and maintain enterprise data warehouses, data marts, and staging environments.
Develop dimensional models including star and snowflake schemas.
Implement data cleansing, transformation, and standardization processes.
Collaborate with business stakeholders to translate reporting and analytics requirements into scalable warehouse solutions.
SQL Development & Performance Optimization
Write complex, highly optimized T-SQL queries, views, functions, and stored procedures.
Develop efficient data retrieval and transformation logic across large datasets.
Analyze execution plans and optimize database performance through indexing, partitioning, and query tuning.
Ensure scalable and maintainable database solutions that support growing business needs.
Data Quality & Governance
Implement data validation processes to ensure accuracy, completeness, and consistency.
Identify and resolve data discrepancies across systems.
Support data governance initiatives and maintain metadata documentation.
Ensure compliance with organizational security and data management standards.
Reporting & Analytics Support
Support reporting teams by developing data structures optimized for BI tools such as Power BI, SSRS, or Tableau.
Create and maintain reusable datasets and reporting views.
Assist analysts and business users with complex data requests and ad-hoc analyses.
Documentation & Collaboration
Create and maintain technical documentation for ETL processes, data mappings, warehouse structures, and database objects.
Participate in architecture and design reviews.
Collaborate with developers, DBAs, business analysts, and project managers throughout the SDLC.
Support production deployments and post-implementation troubleshooting.
Required Qualifications
Experience
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 working with large enterprise databases and high-volume transactional systems.
Required Technical Skills
Database Technologies
Microsoft SQL Server 2016/2019/2022
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
SQL Server Agent
SQL Development
Advanced T-SQL programming
Stored Procedures
Key Competencies
Success Measures
Bachelor's degree in Computer Science, Information Systems, Software Engineering, Data Engineering, or a related discipline.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins works with the biggest companies in the world to ensure the products they supply are safe, their ingredients are authentic, and labelling is accurate. Eurofins believes it is a global leader in food, environmental, pharmaceutical and cosmetics products testing and in agroscience CRO services. It is also one of the global independent market leaders in certain testing and laboratory services for genomics, discovery pharmacology, forensics, CDMO, advanced material sciences and in the support of clinical studies. Eurofins PSS Insourcing has an exciting and rewarding opportunity for a Business Development Manager to join our team.  We are searching for a business development professional with proven experience selling and implementing high-value sales.  Someone who thrives on identifying and closing new business caring for the client through the process will succeed in this role. This position offers the excitement of hunting for new clients with the goal of diversifying our offerings and client base as well as the opportunity to foster and expand partnerships with key clients.  This is a hybrid role working remotely from a home office, travelling locally and within the region for prospect and current client meetings as well as full days spent at current client sites to maximize networking and relationship building opportunities. A successful candidate will have a proven track record and is comfortable reaching out to and meeting with high level decision makers including C-Suite.  This position will manage the strategic sales process including identifying client needs, defining and presenting how PSS can address them, as well as managing the implementation process for new programs. If you’re looking for a rewarding career, a place to call home, apply with us today!