Lead Software Engineer

3 Days ago • All levels

Job Summary

Job Description

This Lead Software Engineer position at Capgemini involves collaborating with ESRI Solution Architects to implement GIS Spatial Database Engine (SDE). The role includes leading data migration strategies, developing and optimizing SQL queries, and mitigating technical risks. The responsibilities also include using ETL tools like FME, applying Agile methodologies, and ensuring compliance with data integrity and security best practices. Capgemini is a global leader helping organizations to accelerate their dual transition to a digital and sustainable world.

Must have:

Collaborate on SDE implementation with ESRI architects.
Lead data migration strategy and execution.
Develop and optimize SQL queries for geospatial data.
Identify and mitigate technical risks.
Utilize FME for efficient data migration.

Good to have:

Analyze and present geospatial data to meet requirements.
Work with managed SQL databases and geodatabases.
Deliver technical requirements for ESRI GIS systems.
Collaborate with enterprise architects and technical teams.
Maintain strong communication skills for technical concepts.

7 skills required

7 skills required for this role

Add these skills to join the top 1% applicants for this job

sql

postgresql

communication

agile-development

risk-mitigation

risk-management

team-management

Job Details

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Primary Skills

Collaborate with ESRI Solution Architect for SDE Implementation: Work closely with the ESRI solution architect to define and deliver requirements related to the GIS Spatial Database Engine (SDE). This includes creating and configuring SDE geodatabases, ensuring data integrity, and planning the migration of data to the cloud.
Lead Data Migration Strategy and Execution: Take ownership of migrating ArcSDE databases to cloud-based environments such as SQL Server and PostgreSQL. This involves upgrading databases, managing users and versions, and ensuring seamless transition with minimal data loss or downtime.
SQL Development and Optimization: Develop and optimize SQL queries and scripts to support geospatial data operations, transformations, and validations as part of the migration and integration process.
Risk Mitigation and Strategic Planning: Partner with the ESRI solution architect and client teams to identify technical risks and finalize a robust data migration strategy that aligns with business goals and technical constraints.
ETL and Interoperability Expertise: Utilize FME as an ETL tool and apply ESRI Data Interoperability (DI) techniques to facilitate efficient and accurate data migration across platforms and formats.
Agile Delivery and Change Management: Apply Agile, Scrum, and iterative development methodologies to manage project execution. Ensure adherence to change management processes for smooth implementation and stakeholder alignment.

Secondary Skills

Analyze, interpret, and present geospatial data to meet client-specific requirements.
Work with managed SQL databases, geodatabases, and related objects.
Deliver technical requirements for ESRI GIS systems and geospatial data presentation.
Collaborate with enterprise architects, business leaders, and technical teams to develop and deploy solutions.
Maintain strong communication skills to articulate technical concepts and business outcomes.
Experience with ESRI GIS system upgrades or migrations is a plus.
Proficiency in SQL Server concepts and database management.
Ensure compliance with best practices in data integrity and security.

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.