Design, develop, and maintain ETL workflows using Informatica (PowerCenter and/or IICS)
Build and optimize cloud-based data pipelines and integrations on AWS
Develop and support ingestion, transformation, and loading processes from multiple source systems (SQL, APIs, flat files, etc.)
Implement and maintain data quality, validation, and reconciliation checks
Manage scheduling, dependencies, and monitoring of ETL jobs; troubleshoot failures and performance issues
Collaborate with data architects to implement target models in data lakes/warehouses
Ensure pipelines follow security, governance, and compliance standards
Contribute to best practices for CI/CD, version control, environment promotion, and deployment automation
Document ETL design, mappings, lineage, and operational processes
Participate in on-call or production support rotations as needed

7+ years of hands-on ETL/data engineering experience
Strong experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS)
Experience building data solutions in AWS, including services such as: S3, IAM, CloudWatch Glue, Lambda, Step Functions Redshift, RDS, or Aurora
Strong SQL skills (query optimization, joins, windowing, performance tuning)
Python scripting for automation or integration support
Experience with data warehouse concepts and dimensional modeling
Familiarity with SDLC practices and version control tools (Git, Bitbucket, etc.)
Ability to troubleshoot pipeline failures and performance bottlenecks independently
Strong communication skills and comfort working cross-functionally

Data Engineer

Key skills