Seeking a skilled Data Migration Engineer to translate complex Informatica workflows into modern Python EL scripts and dbt transformation models. This role focuses on building robust data pipelines and ensuring data integrity.

Join a dynamic team to drive innovative data solutions and contribute to significant data migration projects. The position offers a remote work arrangement.

Transform Informatica sessions, mappings, and parameterizations into Python EL scripts and dbt models.

Develop high-volume data ingestion pipelines using Python and relevant database tools. Design and implement dbt transformation models following best practices.

Create comprehensive data validation tests and orchestrate scripts using Airflow. Contribute to CI/CD pipelines for code quality and deployment.

Conduct peer code reviews, troubleshoot performance issues, and document processes effectively.

Proficiency in Python, Informatica, and dbt is essential. Experience with SQLAlchemy, cx_Oracle, pyodbc, Oracle Data Pump, and SQL Server BCP is required.

Familiarity with Airflow for orchestration and GitLab CI/CD for pipeline management is needed. Strong analytical skills for troubleshooting and performance tuning are crucial.

Ability to contribute to technical documentation and collaborate effectively within a team environment.