| Onsite Job opportunity for the role of ETL Architect in Chicago, IL (Onsite) at Chicago, Illinois, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3182116&uid=ce6f3685d13847a0926d25fca0357518 Greetings, This is Rahul from Quantum world Technologies; I am working as Senior Technical Recruiter in this company. I have a onsite/hybrid Job Opportunity with one of our clients. Please share your resume if you are interested in the job details given below: Job Title: ETL Architect Location : Chicago, IL (Onsite) Pharma or Medical or Healthcare or life-science domain is mandatory We are seeking an experienced Onsite Lead to manage and drive end-to-end ETL Data Migration activities. The role involves coordinating with business stakeholders, understanding data requirements, performing detailed data field mapping, and overseeing data extraction, transformation, and migration workflows using PL/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 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 onsiteoffshore 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 with PL/SQL, Oracle databases, and ETL pipelines. Proven experience in data field mapping, requirement gathering, and business workflow understanding. Prior experience working with pharmaceutical 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 onsiteoffshore 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 Thanks & Regards Rahul Pandey [email protected] Senior Technical Recruiter Quantum World Technologies Inc. -- Keywords: quality analyst access management information technology procedural language Illinois Onsite Job opportunity for the role of ETL Architect in Chicago, IL (Onsite) [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3182116&uid=ce6f3685d13847a0926d25fca0357518 |
| [email protected] View All |
| 12:33 AM 04-Mar-26 |