HarrisburgRecruiter Since 2001
the smart solution for Harrisburg jobs

ETL/Data Integration Lead

Company: Global Data Consultants
Location: Harrisburg
Posted on: November 20, 2020

Job Description:

Overview GDC IT Solutions is currently seeking an ETLData Integration Lead in the Harrisburg, PA area. Position Overview 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. 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. Responsibilities Define ETL framework, methods, guidelines and principles. Apply subject matter expertise to company's 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 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. 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.Remain current on industry specific knowledge and emerging technology. Other duties as assigned. 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. Advanced in STM requirement creation and Planning. Demonstrated advanced experience in building data steams on an agile project. Proficient in the creation of data flow diagrams and documentation for data integration processes. Demonstrated deep understanding of SQL syntax using various relational database engines (i.e. IBM Relational Database DB2, SQL Server, Oracle). Experience in collaborating and leveraging resources. Experience providing mentoring, leadership, and direction in a result-oriented environment. Advanced knowledge of data warehousing data structures and usage. Proficient knowledge of data sourcing from NoSQL (i.e. Cassandra, Hadoop Database HBase, Mongo). Excellent written and verbal skills. Proficient in Microsoft Office Suite. Demonstrated ability to meet and exceed expectations in a work remote environment. What We Do GDC is a full-service IT Staffing and Solutions company specializing in the areas of IT talent placement, application development, multilingual service desk, networking and infrastructure, business intelligence, and project management. Why Work for GDC? Cutting Edge Technology and Innovation Career Growth Opportunities Employee-Centric Environment Comprehensive Benefits Package Holiday and Vacation Equal Opportunity Workplace GDC is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. All qualified applicants will receive consideration for employment.

Keywords: Global Data Consultants, Harrisburg , ETL/Data Integration Lead, 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


Class A CDL Team Truck Drivers: Earn up to 80 CPM!
Description: Team Drivers: HUGE 30,000 Sign On Bonus/split with TONS of miles 1,000 Holiday
Company: US Xpress
Location: Leesburg
Posted on: 12/4/2020

Lot Associate
Description: Job Description Lot Associates assist customers with the loading of their vehicles and also monitor
Company: The Home Depot
Location: Leesburg
Posted on: 12/4/2020

Commercial Team Truck Driver Jobs
Description: Team Drivers: HUGE 30,000 Sign On Bonus/split with TONS of miles 1,000 Holiday
Company: US Xpress
Location: Leesburg
Posted on: 12/4/2020


Shopper - Flexible schedule, up to $22 an hour
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: 12/4/2020

Licensed Practical Nurse (LPN)
Description: Licensed Practical Nurse LPN Now Offering Paid Time Off PTO Benefits Aveanna Healthcare, the largest pediatric home health care company in the U.S., is hiring compassionate Licensed Practical (more...)
Company: Aveanna Healthcare
Location: Leesburg
Posted on: 12/4/2020

Lot Associate
Description: Job DescriptionLot Associates assist customers with the loading of their vehicles and also monitor
Company: The Home Depot
Location: Leesburg
Posted on: 12/4/2020

TransAm Trucking Company Truck Driver Jobs
Description: New Drivers Are Now Eligible For 2,500 In Sign-On Incentives TransAm Trucking is now hiring company CDL-A truck drivers for long-haul career opportunities Apply today and enjoy life on the road (more...)
Company: Trans Am
Location: Leesburg
Posted on: 12/4/2020

Class A Team Driver Jobs
Description: Team Drivers: HUGE 30,000 Sign On Bonus/split with TONS of miles 1,000 Holiday
Company: US Xpress
Location: Leesburg
Posted on: 12/4/2020

CDL-A TEAM TRUCK DRIVERS: NEW $30,000 SIGN ON BONUS/SPLIT & Earn Up to 80 CPM
Description: Team Drivers: HUGE 30,000 Sign On Bonus/split with TONS of miles 1,000 Holiday Bonus After First
Company: US Xpress
Location: Leesburg
Posted on: 12/4/2020

Experienced Systems Engineer III
Description: The National Programs team--is seeking an--Agile Product Owner Experienced Systems Engineer in Chantilly, VA, Fairfax, VA, Mountain View, CA, or Aurora, CO. The Systems Engineer will work as a member (more...)
Company: BOEING
Location: Leesburg
Posted on: 12/4/2020

Log In or Create An Account

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

Harrisburg RSS job feeds