Note: The job is a remote job and is open to candidates in USA. Clevanoo LLC is seeking a hands-on Data Engineer to build, maintain, and optimize enterprise data pipelines using Informatica IDMC/IICS and Snowflake. The role also supports data quality, production operations, deployment processes, governance, and data security.

Responsibilities

• Develop and maintain ETL/ELT pipelines using Informatica IDMC/IICS and Snowflake
• Optimize SQL queries and troubleshoot data transformation issues
• Perform data validation, reconciliation, and quality monitoring
• Support production data pipelines and resolve failures
• Manage deployments using Git, Azure DevOps, and CI/CD processes
• Maintain data documentation, lineage, metadata, and governance standards
• Ensure data security, PII protection, and compliance requirements
• Collaborate with Data Warehouse, BI, Platform Engineering, Governance, and Security teams

Skills

• 5+ years of hands-on experience with Informatica IDMC/IICS (CDI)
• Expert-level experience with Snowflake SQL, including development and performance tuning
• Strong experience with: ETL/ELT data pipeline development Complex SQL queries and data transformations Data quality checks, validation, and reconciliation Production support and troubleshooting Git and Azure DevOps CI/CD pipelines and deployment automation Data lineage, metadata management, and governance
• Must have excellent verbal and written communication skills
• Must be able to clearly explain technical experience during interviews
• Must be eligible to work on W2
• Financial Services / Banking experience is highly preferred

Benefits

• Remote (must reside in WV, OH, PA, IN, TN, KY, MI, VA, or MD)

Company Overview