Senior Software Engineer
Carrollton, TX, United States
ABOUT VIAPLUS :
ViaPlus is a global mobility company in the Intelligent Transportation Systems (ITS) market, specializing in revenue and services management solutions for the transportation industry. Our customer operations, data analytics, and full-featured, single-account back-office technology facilitate the high-volume transactions required for seamless multimodal mobility. As a VINCI Highways subsidiary, we are committed to technical innovation and to promoting a positive mobility experience for all.
We are pioneers in the transportation transaction and mobility industry, with a decade of proven global experience in providing solutions focused on the tolling and transit industries. ViaPlus is headquartered near Dallas, Texas, and maintains offices across the United States, France, India, and Ireland. We are part of the global network of VINCI Concessions, an international player in transport infrastructure with projects in 23 countries. Our vision has evolved to provide a fully automated, end-to-end transportation solution that significantly improves revenue collection and efficiency while effectively lowering costs for our agency clients.
We serve enterprises that require high-volume, real-time transaction processing with the highest levels of accuracy, especially where revenue reconciliation and customer account management are key deliverables to the customer experience. Our flagship back-office system (BOS) enables Mobility-as-a-Service (MaaS) with a "one account" feature that supports multimodal transportation solutions. In a rapidly changing environment, ViaPlus maintains a strong focus on technology and continuous R&D to improve agency efficiencies, reduce operating expenses, and maximize revenue - all while providing exceptional customer service.
Learn more: http://www.viaplus.com
ABOUT VINCI HIGHWAYS
VINCI Highways, a VINCI Concessions subsidiary, is a leader in road concessions, operations and mobility services. We design, finance, build and operate highways, bridges, tunnels, urban roads and mobility services on a network of more than 3,360 km in 15 countries. VINCI Highways leverages its expertise to deliver the highest performance and safety standards and provide drivers with a positive experience.
More information:
https://www.vinci-concessions.com/en/vinci-highways
https://www.linkedin.com/company/vinci-highways/
@VINCIConcess
JOB PROFILE : Senior Software Engineer - SQL/Data Migration Specialist
JOB LOCATION: Carrollton, TX
JOB RESPONSIBILITIES:
• Designing and implementing database structures, including tables, indexes, views, triggers, functions, and stored procedures, based on application requirements and performance considerations.
• Writing and optimizing SQL queries to improve database performance, minimize execution time, and reduce resource consumption.
• Developing logical and physical data models to represent the relationships between different data entities and ensure data integrity and consistency.
• Collaborating with stakeholders to gather and analyze data migration requirements, including data sources, target systems, data mapping, and transformation rules.
• Profiling source data to assess data quality, identify anomalies, inconsistencies, and data cleansing requirements, and develop data quality improvement strategies.
• Defining data mapping and transformation rules to map data elements from source systems to target systems, ensuring data integrity and consistency during migration.
• Cleansing, transforming, and enriching source data to meet the requirements of the target system, including data validation, standardization, deduplication, and enrichment.
• Developing and implementing ETL (Extract, Transform, Load) processes or data migration scripts to extract data from source systems, transform it according to predefined rules, and load it into the target system.
• Planning and executing data migration testing, including data validation, reconciliation, and error handling, to ensure the accuracy and completeness of migrated data.
• Managing change control processes to track and document changes to data migration requirements, mappings, and processes, ensuring compliance with project scope and timelines.
• Optimizing data migration processes to minimize downtime, maximize throughput, and meet performance objectives within the constraints of available resources.
• Creating documentation for data migration processes, including data migration plans, technical specifications, and user guides, and providing training and support to end users as needed.
• Providing post-migration support and troubleshooting assistance to address any issues or discrepancies identified after data migration, ensuring a smooth transition to the new system.
• Provide guidance and mentorship to junior developers on best practices for SQL query optimization and database performance tuning.
• Identify opportunities for process improvements, automation, and innovation in database development, data migration, and performance optimization.
QUALIFICATIONS:
• Should have a good experienced and dedicated SQL Developer with a strong background in data migration.
• Should have strong experience in SQL, data migration, and ETL processes
• Strong experience in database design, normalization, and indexing
• Strong experience in SQL Server performance tuning and optimization techniques
• Excellent problem-solving skills and attention to detail
• Effective communication skills for collaborating with technical and non-technical team members.
• Experience in working with Agile methodologies and practices.
• Continuous learning mindset to stay updated with evolving technologies and best practices.
EDUCATION & EXPERIENCE:
• Any Graduate with a B. E / B. Tech, MCA, or equivalent degree with more than five (5) years of relevant work experience.
• Relevant work experience should include the use of SQL and related software such as SQL Server, preferably on a data migration project
SUPERVISORY RESPONSIBILITIES
N/A
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform essential functions. While performing the duties of this job, the employee is regularly required to use hands and reach with hands and arms, hear, and talk. The employee will be working and navigating on a computer. The employee occasionally is required to stand, sit, stoop, kneel, crouch, and walk. The employee may occasionally be required to lift and/or move up to 20 pounds. The work environment is usually moderate to loud.