Data Engineer
Data Ideology, LLC
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
About the role
- Develop, maintain, and enhance production ETL pipelines using Informatica (PowerCenter and/or IICS)
- Write, optimize, and troubleshoot complex SQL used for transformations, validations, and analytics
- Support and enhance data pipelines loading into Snowflake
- Debug failed ETL jobs, data discrepancies, and performance issues across ETL and warehouse layers
- Collaborate with business and technical stakeholders to understand data requirements and translate them into working solutions
- Support data warehouse environments across cloud and hybrid architectures
- Maintain technical documentation, mappings, and workflow logic
- Participate in SDLC processes including deployments, testing, and version control
Requirements
- 5+ years of hands-on experience building and supporting ETL pipelines in production
- Strong SQL skills, including complex joins, subqueries, aggregations, and performance tuning
- Hands-on experience with Informatica PowerCenter and/or Informatica IICS
- Experience working with cloud data warehouses, including Snowflake
- Ability to independently troubleshoot ETL failures, data issues, and query performance problems
- Experience working within SDLC frameworks and version control systems
- Strong communication skills and ability to explain technical work clearly.
Benefits
- PTO Policy
- Eligibility for Health Benefits
- Retirement Plan
- Work from Home
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ETL pipelinesSQLInformatica PowerCenterInformatica IICSSnowflakeperformance tuningdata transformationsdata validationsdebuggingSDLC
Soft Skills
communicationcollaborationtroubleshootingproblem-solving