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