HarrisburgRecruiter Since 2001
the smart solution for Harrisburg jobs

ETL Data Integration Lead

Company: Infolob Solutions Inc
Location: Harrisburg
Posted on: May 21, 2020

Job Description:

ETL Data Integration Lead 6 months Right to hire position Harrisburg, PA - Given the pandemic situation this position will start as a telework position but once telework requirements are lifted, this resource is expected to report to work in Harrisburg PA. 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 Clients 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. 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. ESSENTIAL DUTIES AND RESPONSIBILITIES PHYSICAL REQUIREMENTS AND WORK ENVIRONMENT Perform work required for this position in an office or remote environment. Remain sedentary for significant periods of time. Ability to speak to groups of employees and effectively manage conflict. Must be able to work in a stressful environment regularly. Perform work required for this position in an office environment. Remain sedentary for significant periods of time. Must be able to communicate in both written and verbal formats (i.e. email, letters, etc.). Must be able to have a regular and predictable on-site attendance for a highly interactive role. Must be able to use a personal computer. ADDITIONAL KNOWLEDGE, SKILLS, AND ABILITIES Avoid the silo effect where a lack of communication can cause a change in one area of a system to adversely affect another area of the system. Ability to manage and prioritize multiple assignments, and competing priorities in a rapidly growing, fast-paced environment. Ability to develop and promote effective working relationships within all levels of the Agency. Ability to assess and identify dependencies and actions needed to successfully perform work as assigned. Ability to be highly impactful while working as a team. Ability to understand the long-term ("big picture") and short-term perspectives of situations. Ability to apply multiple technical solutions to business problems. Ability to quickly comprehend the functions and capabilities of new technologies. Ability to communicate with diverse business communities.

Keywords: Infolob Solutions Inc, 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


Translator- Hurricane Relief
Description: Translators Needed for Written Spanish to Written EnglishF.E.M.A. Federal Emergency Management Agency needs people to translate written Spanish disaster relief forms into written English for the upcoming (more...)
Company: NRI Staffing
Location: Chantilly
Posted on: 06/1/2020

Permanent Primary Care Physician in Harrisburg, Pennsylvania
Description: Primary Care physician employment in Pennsylvania : More time for your patients and more time for you. It's time to learn more about careers at Concentra. At Concentra, our physicians spend 90 of their (more...)
Company: Concentra
Location: Harrisburg
Posted on: 06/1/2020

Translators - All Languages - Spainish is in high demand
Description: Translators needed for a large government contract in Northern Virginia. All languages needed Spanish, French, Arabic, German, Portuguese, etc Must be able to speak, read, and write. Spanish language (more...)
Company: NRI Staffing
Location: Chantilly
Posted on: 06/1/2020


Permanent Surgery Physician in Harrisburg, Pennsylvania
Description: Surgery physician employment in Pennsylvania : General Surgeons Needed for Full-Time Position Get Your Time Back Vohra Wound Physicians - No Call, No Weekends Apply Today Vohra Wound Physicians is seeking (more...)
Company: Vohra Wound Physicians
Location: Harrisburg
Posted on: 06/1/2020

TruGreen: Residential lawn specialists needed no experience necessary
Description: Job Description Do you like being outdoors Do you like a job where every day is different The Specialist role with TruGreen is an excellent opportunity for an energetic, self-motivated, and goal oriented (more...)
Company: TRUGREEN
Location: Leesburg
Posted on: 06/1/2020

Translator
Description: Translators needed for upcoming Hurricane and Forest Fire Season to assist with translating disaster relief forms into English. Position is located in Chantilly in a secure Government facility that will (more...)
Company: NRI Staffing
Location: Chantilly
Posted on: 06/1/2020

Permanent Family Practice Physician in Harrisburg, Pennsylvania
Description: Family Practice physician employment in Pennsylvania : Family Medicine
Company: International Medical Placement, Ltd
Location: Harrisburg
Posted on: 06/1/2020

Permanent ObGyn Hospitalist Physician in Leesburg, Virginia
Description: ObGyn Hospitalist physician employment in Virginia : Deliver compassionate patient care as an OB/GYN hospitalist working in historic Leesburg, Virginia TeamHealth has an exciting opportunity for a board (more...)
Company: Team Health
Location: Leesburg
Posted on: 06/1/2020

Permanent Psychiatry Physician in Harrisburg, Pennsylvania
Description: Psychiatry physician employment in Pennsylvania : Seeking a General Psychiatrst
Company: irecruitmd.com
Location: Harrisburg
Posted on: 06/1/2020

Permanent Plastic Surgery Physician in Harrisburg, Pennsylvania
Description: Plastic Surgery physician employment in Pennsylvania : Plastic Surgeons Needed for Full-Time Position Get Your Time Back Vohra Wound Physicians - No Call, No Weekends Apply Today Vohra Wound Physicians (more...)
Company: Vohra Wound Physicians
Location: Harrisburg
Posted on: 06/1/2020

Log In or Create An Account

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

Harrisburg RSS job feeds