Hiring: Senior Data Integration Engineer – IICS | Snowflake | Openflow | DBT
Experience: 8+ Years
Employment Type: Contract
Work Mode: 100% Remote – India
Shift Timing: 3:30 PM to 12:30 AM IST
Notice Period: Immediate Joiners / Short Notice Preferred
About the Role
We are looking for an experienced Senior Data Integration Engineer with strong hands‑on expertise in Informatica Intelligent Cloud Services (IICS), Snowflake, Openflow, and DBT.
The ideal candidate will be responsible for designing, developing, and optimizing scalable ETL/ELT pipelines and cloud‑based data integration solutions. You will work on modern data platforms, build efficient data transformation frameworks, and ensure high‑quality, reliable, and secure data delivery to support enterprise analytics and reporting requirements.
This role requires strong technical expertise, problem‑solving abilities, and the ability to collaborate with global stakeholders in a remote working environment.
Key Responsibilities
- Design, develop, and maintain end-to-end ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS).
- Build and optimize data ingestion frameworks, data models, and transformations within Snowflake.
- Develop, maintain, and optimize data transformation workflows using DBT (Data Build Tool).
- Implement and manage data workflows, orchestration, and automation using Openflow.
- Integrate data from multiple sources, including databases, APIs, and cloud-based applications.
- Perform SQL development, query optimization, and Snowflake performance tuning.
- Monitor, troubleshoot, and resolve data pipeline issues to ensure reliability and scalability.
- Implement data quality checks, governance, security, and compliance standards.
- Collaborate with business stakeholders, data analysts, and engineering teams to understand data requirements.
- Participate in code reviews, release management, and production support activities.
- Maintain technical documentation and contribute to knowledge‑sharing initiatives.
Mandatory Technical Skills
- Informatica IICS: Strong hands‑on experience with Informatica Intelligent Cloud Services.
- Snowflake: Data warehousing, architecture, data modelling, ingestion, and performance optimization.
- DBT: Data transformation, DBT models, workflows, and warehouse development.
- Openflow: Experience with workflow orchestration, automation, and data integration.
- SQL: Advanced SQL development, query optimization, and troubleshooting.
- ETL/ELT: Strong understanding of data integration frameworks and best practices.
- Data Modelling: Dimensional modelling and data warehousing concepts.
- Cloud Platforms: Exposure to AWS, Azure, or GCP.
- Version Control: Experience with Git and source control management.
Good to Have
- Python or Shell scripting.
- CI/CD pipelines and DevOps practices.
- Snowflake or Informatica certifications.
Candidate Requirements
- 8+ years of experience in Data Engineering, ETL Development, or Data Integration.
- Strong hands‑on expertise in IICS, Snowflake, DBT, and Openflow.
- Proven experience developing and optimizing complex data pipelines.
- Strong analytical, troubleshooting, and problem‑solving skills.
- Excellent communication and collaboration skills.
- Ability to work independently and coordinate with global stakeholders.
- Willingness to work in the 3:30 PM – 12:30 AM IST shift.
- Engagement: Contractual
- Work Location: Remote – India
- Working Hours: 3:30 PM to 12:30 AM IST