HarrisburgRecruiter Since 2001
the smart solution for Harrisburg jobs

ETL Lead Developer

Company: Apex Systems
Location: Harrisburg
Posted on: November 23, 2020

Job Description:

JOB PURPOSE AND SUMMARY The ETLData Integration Lead focuses on movement of data across systems with the primary focus on moving data from source transactional systems to the data warehouse environment. This role sets enterprise data movement standard framework, methods, guidelines and principles across the Agency. The ETLData lead is a hands on role that works with technical source system owners, Enterprise Application Architects, and the Business Intelligence (BI) Architect to ensure high quality and complete data is delivered in a timely manner to the data warehouse environment andor data feeds ensuring monitoring and daily load status reports are provided. Additionally, the ETLData Integration Lead takes part in and maintains the on call ETL support schedule with the Sr. Manager of Data Analytics. PRIMARY DUTIES AND RESPONSIBILITIES ETL Development (80) Define ETL framework, methods, guidelines and principles. Apply subject matter expertise to Informatica and Python ETL processes to make improvements and recommendations for change then implement said changes. Ensure that integrity and manage the change control process of the ETL code repository. Collaborate with source system technical owners, BI Architect, and AWS resources to create data stream solutions to move data from on premise and cloud based system to the data lake and data warehouse environment. Create data flow blueprints that illustrate how information flows through the Agency to create ETL processes. Work with application owners and reporting owners to create data feed process to support B2B integrations. Work with application project teams to assess source system change impact to ETL processes. Collaborate with Data Analysts and BI Architect to create and update source to target mappings (STM). Provide data integration subject matter expertise during Program Increment (PI) planning sessions. Maintain ETLData integration agile management stories with delivery to dates to ensure Safe Agile processes are adhered to. Guidance (15) Provide guidance to ETL project team members, ETL support team, and other users of the Informatica production across the enterprise. Collaborate with others to document and socialize ETLData integration standards and processes. OTHER DUTIES AND RESPONSIBILITIES (5) Remain current on industry specific knowledge and emerging technology. Other duties as assigned. QUALIFICATIONS EDUCATION AND EXPERIENCE Minimum Qualifications Bachelor's Degree in Information Technology, Management Information Systems or Engineering preferred 10 years of Information Technology (IT)-related experience and Expert level knowledge with current hands on experience building data integration processes using eight years minimum using Informatica or the equivalent combination of knowledge, training, andor experience. Advanced experience in using a data lake as an ETL target and ETL source. Demonstrated expert in the implementation of data integration processes for large scale data warehouses. Expert in building initial load and change data capture (CDC) ETL jobs in Informatica for near real time data loads. EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or

Keywords: Apex Systems, Harrisburg , ETL Lead Developer, Other , Harrisburg, Pennsylvania

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Expert Test Systems Integrator
Description: Minimum Clearance Required to Start Top Secret SCI Job Description The Parsons team is looking for a sharp Expert Test Systems Engineer to join our exciting and growing Space and Geospatial Solutions (more...)
Company: Parsons
Location: Chantilly
Posted on: 11/28/2020

Spacecraft Systems Engineer
Description: Job ID: 207064 Location: CHANTILLY , VA , US Date Posted: 2020-04-16 Category: Engineering and Sciences Subcategory: Systems Engineer Schedule: Full-time Shift: Day Job (more...)
Company: SAIC
Location: Chantilly
Posted on: 11/28/2020

Be a Shipt Shopper, AKA paid grocery pro
Description: Shipt is a membership-based marketplace that helps people get the things they need, like fresh produce and household essentials, from stores they trust. Help people save time and have fun while you're (more...)
Company: Shipt
Location: Chantilly
Posted on: 11/28/2020


Part Time Delivery Job - Earn up to $22/hr
Description: Shipt is a membership-based marketplace that helps people get the things they need, like fresh produce and household essentials, from stores they trust. Help people save time and have fun while you're (more...)
Company: Shipt
Location: Leesburg
Posted on: 11/28/2020

Systems Engineer Chief
Description: Job ID: 2017647 Location: CHANTILLY , VA , US Date Posted: 2020-11-09 Category: Engineering and Sciences Subcategory: Systems Engineer Schedule: Full-time Shift: Day Job (more...)
Company: SAIC
Location: Chantilly
Posted on: 11/28/2020

Client Systems/Hardware Support - Enterprise
Description: REQ RQ66964 Travel Required None Public Trust None Requisition Type Regular Thank you for your interest in joining our team This position will be providing the support to the Combined Air Operations (more...)
Company: General Dynamics Information Technology
Location: Chantilly
Posted on: 11/28/2020

Seasonal Power Equipment Operator - CVG1 - Make up to $20.75 per hour
Description: Position Description This role may be required to drive powered equipment, however no experience is required as we provide training on-site. Starting Base Pay: 13.75 Walmart is rolling out amazing (more...)
Company: Walmart
Location: Leesburg
Posted on: 11/28/2020

Supplement Your Warehouse Income - Grocery Shopper
Description: Shipt is a membership-based marketplace that helps people get the things they need, like fresh produce and household essentials, from stores they trust. Help people save time and have fun while you're (more...)
Company: Shipt
Location: Leesburg
Posted on: 11/28/2020

Sr Client Support Specialist - Internal Applicants Only
Description: OVERVIEW: br br The Sr. Client Support Specialist is an important outward facing position that delivers exceptional client support that underpins ongoing relationship between SOC and its client. The (more...)
Company: SOC
Location: Chantilly
Posted on: 11/28/2020

Work in Retail? Earn Extra Cash Delivering Groceries
Description: Shipt is a membership-based marketplace that helps people get the things they need, like fresh produce and household essentials, from stores they trust. Help people save time and have fun while you're (more...)
Company: Shipt
Location: Leesburg
Posted on: 11/28/2020

Log In or Create An Account

Get the latest Pennsylvania jobs by following @recnetPA on Twitter!

Harrisburg RSS job feeds