Browse Jobs
Explore open roles across India.Explore active software roles. Sign up to apply and get AI match scores.
Top MatchesTop Job Matches
Loading jobs…
Back to Browse Jobs
Hitachi Careers
Data Engineer - SSIS IRC298320
Hitachi Careers
Bengaluru•Hybrid•1-4 Yrs•3 days ago
Job description
Hybrid
Overview
This role focuses on developing and maintaining data integration solutions using SQL Server Integration Services (SSIS) and SQL Server technologies, enabling seamless data ingestion and delivery of outbound data feeds.
Responsibilities
- Exp- 4 to 6 Years
- Build and Maintain Data Integrations Using SSIS
- Design, develop, and deploy ETL processes to enable data ingestion of eligibility, medical, pharmacy claims, and other partner data.
- Configure SSIS workflows for outbound data feeds and file-based data exchanges.
- Implement and maintain error-handling mechanisms in SSIS to ensure robust and reliable processes.
- Develop and Optimize Database Processes Using T-SQL
- Write and optimize T-SQL queries and stored procedures to support integration pipelines.
- Develop scripts to ensure efficient data processing and transformations.
- Add error-handling and logging to database processes to ensure data integrity and process transparency.
- Troubleshoot Errors and Monitor Integration Processes
- Diagnose and resolve errors in SSIS workflows, T-SQL queries, and overall integration pipelines.
- Develop tools or procedures to monitor and alert for integration issues proactively.
- Analyze integration anomalies and apply root-cause analysis to ensure long-term reliability.
- Collaborate with Analysts and Business Stakeholders
- Partner with Data Analysts and Business Partners to gather and validate integration requirements.
- Ensure integration processes align with business needs and data quality standards.
Qualifications
- This role focuses on developing and maintaining data integration solutions using SQL Server Integration Services (SSIS) and SQL Server technologies, enabling seamless data ingestion and delivery of outbound data feeds. The ideal candidate is also adept at troubleshooting errors and implementing robust error-handling mechanisms to ensure process reliability.
- 1-5 years of experience in SQL Server and relational database technologies.
- 2-4 years of experience with SQL Server Integration Services (SSIS).
- 1-2 years of experience with data warehousing concepts and ETL best practices.
- Strong understanding of relational database concepts (normalization, constraints, indexing, etc.).
- Proficient in T-SQL, including writing complex queries, stored procedures, and performance tuning.
- Proficient in troubleshooting data integration issues, including root-cause analysis and resolution.
- Familiarity with data modeling and cloud integration technologies (preferred).
- Excellent troubleshooting skills for resolving data integration and performance issues.
- Strong written and verbal communication skills to interact with technical and non-technical stakeholders.
- Ability to work within company policies to protect sensitive data and maintain compliance.
Benefits
- Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.
- Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment - or even abroad in one of our global centers or client facilities!
- Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.
- Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.
- Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.
- Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!
- About GlobalLogic
- GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world's largest and most forward-thinking companies. Since 2000, we've been at the forefront of the digital revolution - helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.