FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates extensive expertise in Data Engineering and ETL Development, with a strong focus on modernizing legacy ETL pipelines into scalable cloud-native solutions on AWS. Proficient in building and optimizing data pipelines, with a solid understanding of data quality and governance processes.
Highest-signal resume keywords
Data EngineeringETL DevelopmentAWS GluePySparkSQL
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data WarehousingAWS EMR ServerlessAWS Step FunctionsAmazon S3Apache AirflowInformatica PowerCenterAdvanced SQLComplex JoinsPerformance TuningData Reconciliation
Soft Skills
Analytical SkillsProblem-SolvingCommunication SkillsOwnershipCollaboration
Tools & Technologies
AWS GlueAWS EMR ServerlessAWS Step FunctionsAWS S3Apache AirflowSnowflakeAmazon Athena
Industry Keywords
ETL ModernizationCloud MigrationData QualityData GovernanceMedallion Architecture
Tech Stack
Tools & technologiesAirflowApacheAWSCloudETLInformaticaPySparkPythonSQL
About the role
Key responsibilities & impact- Analyze and understand existing Informatica ETL workflows, mappings, and business processes
- Modernize legacy ETL pipelines into scalable cloud-native solutions on AWS
- Design and develop reusable, metadata-driven frameworks to simplify future integrations and reduce maintenance effort
- Identify common ETL patterns and establish scalable design standards
- Build, test, deploy, and support data pipelines and orchestration workflows
- Collaborate with business stakeholders to translate requirements into technical solutions
- Drive performance optimization, reliability, and operational excellence across data platforms
Requirements
What you’ll need- 10+ years of experience in Data Engineering, ETL Development, and Data Warehousing
- Strong development experience in PySpark, Python, and SQL
- Hands-on experience with AWS EMR Serverless, AWS Glue, AWS Step Functions, AWS EventBridge, Amazon S3, and Apache Airflow
- Strong database experience, preferably DB2, Snowflake, and Amazon Athena
- Advanced SQL skills including complex joins, window functions, CTEs, performance tuning, and data reconciliation
- Experience with Informatica PowerCenter and ability to understand and analyze existing ETL implementations
- Strong analytical, problem-solving, and communication skills
- Ability to work independently and take ownership from design through production deployment
- Preferred: experience building metadata-driven and reusable ETL frameworks
- Preferred: experience with large-scale ETL modernization and cloud migration initiatives
- Preferred: knowledge of data quality, data governance, and reconciliation processes
- Nice to have: experience integrating external systems through REST APIs using Python/PySpark
- Nice to have: exposure to CI/CD pipelines and DevOps practices
- Nice to have: experience with Medallion Architecture (Bronze, Silver, Gold)
- Nice to have: insurance domain experience
- AWS Glue - Advanced
- SQL - Advanced
- PySpark - Advanced
- Python - Intermediate
- AWS EMR Serverless - Intermediate
- AWS Step Functions - Intermediate
- AWS S3 - Intermediate
- AWS Airflow - Intermediate
- Snowflake - Advanced
- AWS Athena - Intermediate
Benefits
Comp & perks- Competitive salary and performance-based bonuses
- Comprehensive benefits package
- Career development and training opportunities
- Flexible work arrangements (remote and/or office-based)
- Dynamic and inclusive work culture within a globally renowned group
- Private Health Insurance
- Pension Plan
- Paid Time Off
- Training & Development