ETL Engineer/DBA (SQL)

$68,700 - $120,100/Yr

CGI - Lafayette, LA

Full-time - Mid Level

Hybrid - Lafayette, LA

Professional, Scientific, and Technical Services

About the position

The ETL Engineer/DBA (SQL) position at CGI Technologies and Solutions, Inc. involves working on a dynamic data migration project, utilizing cutting-edge technologies to enhance government services. The role focuses on designing and developing ETL processes, managing Azure SQL Server databases, and ensuring data integrity and performance optimization. This position offers a collaborative and agile work environment, with opportunities for significant impact on high-stakes data conversions.

Responsibilities

• Design and develop ETL processes using SQL Server Integration Services (SSIS) for data migration.
• Manage, maintain, and optimize Azure SQL Server databases, including performance tuning and security.
• Implement post-conversion validation processes to ensure data accuracy and completeness.
• Monitor ETL performance and implement tuning solutions to improve efficiency.
• Leverage Azure Boards for tracking ETL development tasks and project timelines.

Requirements

• 5+ years of experience as an ETL Engineer/DBA with expertise in SSIS.
• Strong experience in administering and optimizing Azure SQL Server databases.
• In-depth knowledge of data mapping, transformation, and validation techniques.
• Proficiency in SQL scripting for complex queries and reporting.
• Experience with ETL error handling and performance monitoring.

Nice-to-haves

• Experience with Aperture Data Studio
• Experience with Oracle Database Management Systems

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid parental leave
• Learning opportunities and tuition assistance
• Wellness and Well-being programs