Senior Data Engineer – ETL Modernization & Python/Snowflake Specialist
Job Summary:We are looking for a highly skilled and self-motivated Senior Data Engineer with a deep background in Python and SQL development, and hands-on experience working with Snowflake. This role is critical to our R&D initiatives aimed at analyzing, interpreting, and modernizing IICS (Informatica Intelligent Cloud Services) logic into scalable, high-performance Python-based data pipelines. The ideal candidate thrives in ETL-heavy environments and is passionate about reverse engineering and optimizing legacy data solutions.
Roles & Responsibilities:Conduct detailed analysis of existing IICS workflows, mappings, and transformation logic.
Translate IICS logic into efficient, scalable, and maintainable Python scripts and SQL-based processes.
Build, test, and maintain data pipelines targeting Snowflake as the primary data warehouse.
Prototype and evaluate ETL frameworks to support modernization and future scalability.
Collaborate cross-functionally with data architects, engineers, and analysts to ensure solutions are robust and aligned with business and architectural standards.
Provide technical documentation for R&D findings, proof of concepts, and finalized components.
Participate in code reviews and contribute to the standardization of ETL design patterns and best practices.
Act as a subject matter expert in ETL modernization and data integration processes.
Must-Have Skills:5+ years of professional experience with Python and SQL in data engineering or ETL development roles.
Strong hands-on experience with Snowflake and data warehousing concepts.
Proven ability to design and develop scalable ETL/ELT pipelines.
Experience analyzing and understanding data integration tools and frameworks.
Solid understanding of IICS (Informatica Intelligent Cloud Services) or similar data integration tools.
Strong analytical and reverse engineering skills.
Experience with version control systems (Git) and CI/CD pipelines.
Excellent communication and documentation skills.
Good-to-Have Skills:Direct experience with migrating from IICS or other ETL platforms to Python-based frameworks.
Knowledge of cloud platforms such as AWS, GCP, or Azure.
Familiarity with data modeling and data governance principles.
Exposure to containerization (e.g., Docker) and orchestration tools (e.g., Airflow, Prefect).
Experience in agile or R&D-driven development environments.