PL
ETL Architect
PeopleNTech LLC
🇺🇸 United States
On-site
Staff / Principal
6 months ago
- ETL
- PL/SQL
- Regulatory Compliance
- Jira
- Oracle
- ERP
- Informatica
- Talend
- SSIS
- AWS
- Azure
- GCP
- Veeva
- SAP
6 months ago
Location: Chicago, IL (Onsite)
Rate: $70/hr on C2C
Indent: PSL300590-22-1
We are seeking an experiencedOnsite Lead to manage and drive end-to-endETL Data Migration activities. The role involves coordinating with business stakeholders, understanding data requirements, performing detaileddata field mapping, and overseeing data extraction, transformation, and migration workflows usingPL/SQL and other ETL tools. The candidate will serve as a key point of contact between onsite client teams and the offshore delivery team.
Key Responsibilities
Client & Stakeholder Management
- Act as the primary onsite contact for the pharma client, ensuring clear communication and expectation alignment.
- Gather business requirements related to data migration, validation, and transformation.
- Communicate status, risks, and issues to client leadership and internal project managers.
- Facilitate onsite–offshore coordination, sprint planning, and daily updates.
Data Migration & ETL Leadership
- Lead the full lifecycle of ETL Data Migration projects, including scoping, planning, execution, and validation.
- Perform detailed data field mapping between legacy systems and target systems, ensuring functional and regulatory compliance.
- Oversee extraction, transformation, and loading (ETL) activities using PL/SQL scripts and/or ETL tools.
- Conduct impact analysis for data changes and transformations.
Data Quality & Validation
- Define and execute data validation, reconciliation, and verification processes.
- Work with QA teams to ensure data accuracy, completeness, and alignment with pharma domain standards.
- Troubleshoot migration issues, manage defect resolution, and provide technical guidance.
Technical Contribution
- Write, review, and optimize PL/SQL queries, procedures, packages, and scripts for data migration.
- Support ETL design, performance tuning, and automation of repetitive tasks.
- Collaborate with data architects to ensure migration solutions adhere to architectural frameworks.
Documentation & Compliance
- Create and maintain detailed documentation including data mapping sheets, migration design, validation reports, and SOPs.
- Maintain tasks in Jira reflecting latest status and reporting.
Required Skills & Experience
- 15+ years of experience in ETL, data migration, or database engineering roles.
- Strong hands-on experience withPL/SQL, Oracle databases, and ETL pipelines.
- Proven experience indata field mapping, requirement gathering, and business workflow understanding.
- Prior experience working withpharmaceutical or life sciences data domains (e.g., Master Data, Clinical Data, Regulatory, ERP).
- Strong understanding of data governance, data quality, and regulatory compliance.
- Excellent communication, leadership, and stakeholder management skills.
- Ability to work independently in an onsite client-facing role.
- Experience leading onsite–offshore delivery models.
Nice-to-Have
- Experience with ETL tools such as Informatica, Talend, SSIS, or DataStage.
- Working knowledge of cloud data platforms (AWS, Azure, GCP).
- Understanding of pharma domain systems like Veeva, SAP, LIMS, or Clinical systems
ETL Architect · PeopleNTech LLC