TransCore (TRN), a subsidiary of ST Engineering is the global leader in intelligent mobility solutions. For over 80 years TransCore has partnered with transportation authorities to conceive, design, implement, support, and maintain transportation hardware and software systems that enable safer, more efficient transit of people and goods. Our technology helps make highway travel smoother and get you from point A to point B better. We are seeking a full time Extract, Transform, Load (ETL) Programmer, to join our team in Orlando, FL.

Job Summary: The ETL Programmer is responsible for designing, managing, and optimizing MySQL database migration process in support of a transition from an existing DB environment to a new staging DB environment to be consumed into a new system. This includes working closely with system managers and developers to gather DB relationships, design a staging DB environment, and develop queries for both pulling data and analyzing the import/export process to ensure proper data movement from the production DB environment to the staging DB environment.

Key Responsibilities:

• Design, develop, and maintain ETL processes to extract data from various sources, transform it according to business rules, and load it into target databases.
• Collaborate with cross-functional teams to define, design, and implement software solutions to deploy a staging database.
• Optimize ETL workflows for performance, scalability, and reliability.
• Develop and maintain technical documentation related to ETL processes and data integration projects.
• Perform data profiling, cleansing, and validation to ensure data accuracy and consistency.
• Troubleshoot and resolve issues related to ETL processes, data quality, and performance.
• Participate in architecture and design discussions to drive the technical direction of the project.
• Work closely with stakeholders to understand project requirements and translate them into technical specifications.

Qualifications:

• Experience: Minimum of 5 years of experience with MySQL or equivalent RDBMS, experience in ETL programming and data integration, with a strong background in ETL tools such as Informatica, Talend, SSIS, or similar.

• Technical Skills:
  • Proficiency in ETL tools and technologies, such as Informatica, Talend, SSIS, or equivalent.
  • Experience with SQL, data warehousing, and relational databases (e.g., MySQL, Oracle, SQL Server).
  • Strong understanding of data integration best practices, data quality, and data governance.
  • Experience with scripting languages and tools for producing ERDs and DB data dictionaries.
  • Experience writing and optimizing complex SQL and T-SQL
• Soft Skills:
  • Excellent communication, documentation, analytical and interpersonal skills.
  • Ability to work independently and as part of a team.
  • Strong analytical thinking and attention to detail.
  • Able to manage shifting priorities and work in a team environment.
  • Excellent problem-solving skills and the ability to work under tight deadlines.
  
  
• Education: Bachelor's degree in computer science or equivalent from a four-year College or university or equivalent combination of education and work experience required, or a related field. Advanced degree preferred.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

---