Sogeti · 1 day ago
Data Engineer
Sogeti is part of the Capgemini Group, focused on delivering technology solutions that drive business value. The Data Engineer role involves gathering requirements, designing data solutions, and monitoring data pipelines to ensure efficient data processing.
Responsibilities
Ability to gather and understand requirements by studying features/ user stories created for requirements and work on implementing them
Design and development for the change requests from client
Ability to analyze existing data flow and suggest for any enhancements/ improvements based on technical expertise
Preparing test scenarios/ test cases for the user stories and sharing the unit testing results as part of the development completion
Monitor data extract, transform, and load (ETL) jobs, pipelines and work to fix the job failures
Troubleshooting to identify data issues and solving any data discrepancies and providing business intelligence insights
Provide support to the users on any data related questions/issues reported during UAT and PROD cycles
Qualification
Required
Expertise/ at least 7+ years of experience in Microsoft SQL Server
Expertise/ at least 7+ years of experience in Database and ETL design concepts
Expertise/ at least 7+ years of experience in T SQL
Expertise/ at least 7+ years of experience in SQL server Analysis server
Expertise/ at least 7+ years of experience in Azure Synapse – including creating scripts for ETL using Python(pyspark)
Expertise/ at least 7+ years of experience in Experience with excel – includes creating data pivots to different sources for analyzing
Bachelor's Degree
Preferred
Fluent in DAX queries (good to have)
Good to have prior experience with Microsoft projects, process, and tools (like VSTS, VSO)
Benefits
Flexible work options
401(k) with 150% match up to 6%
Employee Share Ownership Plan
Medical, Prescription, Dental & Vision Insurance
Life Insurance
100% Company-Paid Mobile Phone Plan
3 Weeks PTO + 7 Paid Holidays
Paid Parental Leave
Adoption, Surrogacy & Cryopreservation Assistance
Subsidized Back-up Child/Elder Care & Tutoring
Career Planning & Coaching
$5,250 Tuition Reimbursement & 20,000+ Online Courses
Employee Resource Groups
Counseling & Support for Physical, Financial, Emotional & Spiritual Well-being
Disaster Relief Programs
Company
Sogeti
Part of the Capgemini Group, Sogeti makes business value through technology for organizations that need to implement innovation at speed and want a local partner with global scale.