This job is closed
We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.
ETL Engineer/DBA (SQL)
$68,700 - $120,100/Yr
CGI - Lafayette, LA
posted 2 months ago
Full-time - Mid Level
Hybrid - Lafayette, LA
Professional, Scientific, and Technical Services
About the position
The ETL Engineer/DBA (SQL) position at CGI involves designing and developing ETL processes, managing Azure SQL Server databases, and ensuring data integrity during migrations. This role is crucial for supporting a dynamic data migration project aimed at improving government services through innovative technology. The position offers a collaborative and agile work environment, with opportunities to influence high-impact data conversions.
Responsibilities
- Design and develop ETL processes using SQL Server Integration Services (SSIS) to migrate legacy data into modern solutions.
- Manage, maintain, and optimize the performance of Azure SQL Server databases, including index optimization and query tuning.
- Implement error handling and SSIS best practices to ensure efficient and reliable data migrations.
- Develop and implement post-conversion validation processes to ensure data accuracy and completeness after migration.
- Monitor ETL performance, diagnose issues, and implement performance tuning solutions to improve efficiency.
- Leverage Azure Boards for tracking and managing ETL development tasks and project timelines.
Requirements
- 5+ years of experience as an ETL Engineer/DBA with expertise in SQL Server Integration Services (SSIS).
- Strong experience in administering and optimizing Azure SQL Server databases, including performance tuning and security management.
- In-depth knowledge of data mapping, transformation, and validation techniques.
- Proficiency in SQL scripting for complex queries and reporting.
- Experience with ETL error handling, SSIS logging, and performance monitoring.
- Familiarity with the Azure Microsoft Database stack, including Azure Data Factory.
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 the 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
