Software Engineer 3 - Contingent

About the position

A client of Innova Solutions is immediately hiring for a Software Engineer. As a Software Engineer, you will develop and maintain scalable ETL pipelines using PySpark and Informatica. You will write, test, and optimize SQL queries to support data transformation and reporting, work with Microsoft SQL Server to manage and query large datasets, and collaborate with business and technical teams to gather requirements and deliver data solutions. You will ensure data quality, integrity, and security across data workflows, troubleshoot and resolve issues in data pipelines and processing systems, and participate in data reviews to continuously improve engineering processes.

Responsibilities

• Develop and maintain scalable ETL pipelines using PySpark and Informatica.
• Write, test, and optimize SQL queries to support data transformation and reporting.
• Work with Microsoft SQL Server to manage and query large datasets.
• Collaborate with business and technical teams to gather requirements and deliver data solutions.
• Ensure data quality, integrity, and security across data workflows.
• Troubleshoot and resolve issues in data pipelines and processing systems.
• Participate in data reviews and continuously improve engineering processes.

Requirements

• Strong SQL development and query optimization skills.
• Hands-on experience with Microsoft SQL Server.
• Proficiency in PySpark for data processing and transformation.
• Solid understanding of ETL concepts and best practices.

Benefits

• Medical & pharmacy coverage
• Dental/vision insurance
• 401(k)
• Health saving account (HSA)
• Flexible spending account (FSA)
• Life Insurance
• Pet Insurance
• Short term and Long term Disability
• Accident & Critical illness coverage
• Pre-paid legal & ID theft protection
• Sick time
• Other types of paid leaves (as required by law)
• Employee Assistance Program (EAP)