14 days ago
Hangzhou, ChinaSenior
Responsibilities
- Operate and monitor Data Lake services, ETL/ELT pipelines, scheduled jobs, data synchronization, ingestion, and downstream delivery.
- Provide L2/L3 production support and troubleshoot job failures, missing or rejected data, synchronization delays, discrepancies, performance issues, and integration problems.
- Perform root cause analysis across source systems, data pipelines, the Data Lake, databases, and downstream applications.
- Support data quality monitoring, reconciliation, access management, security and audit activities, platform maintenance, disaster recovery, and production readiness.
- Support platform changes, releases, configuration updates, bug fixes, and integration changes.
- Develop or enhance ETL/ELT pipelines, SQL logic, mappings, and data processing components.
- Automate repetitive BAU activities, improve monitoring and platform reliability, and maintain SOPs and runbooks.
- Collaborate with Data Engineering, Product, Infrastructure, upstream and downstream teams, and technology partners.
Requirements
- At least 6 years of experience in Data Engineering, Data Integration, Data Platform Engineering, or ETL/ELT development.
- Strong hands-on experience with SQL, ETL/ELT, data pipelines, Data Lake, data warehouses, and data integration.
- Experience with enterprise ETL or data integration platforms; Informatica IICS or equivalent is highly desirable.
- Experience with cloud data platforms, preferably AWS and S3, and relational databases.
- Ability to troubleshoot complex production issues across data pipelines, databases, integrations, and upstream or downstream systems.
- Experience supporting business-critical production data environments, including monitoring, incident resolution, change and release processes, and production validation.
- Working knowledge of Python, Shell/Bash, or similar scripting and automation technologies.
- Strong analytical, problem-solving, communication, collaboration, detail-oriented, patient, and ownership-driven working style.
- Preferred experience with Informatica IICS, AWS S3, Redshift, PostgreSQL, Snowflake, data quality, reconciliation, metadata, data lineage, monitoring, automation, and DevOps practices.
- Familiarity with enterprise Incident, Problem, Change, Release, Security, Audit, and Disaster Recovery processes.
- Experience in pharmaceutical, healthcare, life sciences, or other regulated industries is highly preferred.
Benefits
- Work location assignment is on premise.
Tech Stack
Categories
Data Engineering
About Pfizer
Pfizer is a publicly traded biopharmaceutical company that discovers, develops, manufactures, and markets prescription medicines and vaccines for patients, healthcare systems, and governments worldwide. Its portfolio spans oncology, vaccines, immunology, and rare disease, with products such as the COVID-19 vaccine (with BioNTech) and the antiviral Paxlovid. Founded in 1849 and headquartered in New York City, Pfizer operates globally under the ticker PFE on the NYSE.