ETL Data Integration Lead

Location: Harrisburg, Pennsylvania, United States

Apply Refer a Friend

Requisition Number: 8536

Position Title:

External Description:

The health and safety of our employees is our top priority. Due to the pandemic, all our employees are working remotely and we will be conducting candidate interviews by video. This position may be required to be in the office occasionally once the COVID-19 crisis has abated.


What You’ll Do

  • 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 ETL/Data 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 ETL/Data integration standards and processes
  • Remain current on industry specific knowledge and emerging technology
  • Other duties as assigned


About You

  • 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, and/or 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
  • 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
  • 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

Remote: 1

City: Harrisburg

State: Pennsylvania

Ext Portal Job Header:

Community / Marketing Title: ETL Data Integration Lead

Company Profile:

We Are Celerity

Millions of people every day use websites, applications, and business processes designed and built by Celerity. As a consultancy of technologists, creatives, and business experts, we provide the action plans, teams, and solutions our clients need to transform the way they do business and deepen engagement with their customers.

Celerity empowers autonomy and accountability. We understand life happens and want our team to do what is needed to get the work done, enjoy it along the way, and have plenty of time and energy for family and friends, vacations, hobbies, learning of languages, you name it!  At Celerity, our focus is on bringing synergies to business process, technology, and creative chops to deliver inspirational solutions. We love giving kudos and celebrating achievements. We provide an inclusive and flexible environment that fosters collaboration, quick pivots, and quality work. 

Originally founded in 2002, Celerity was acquired in 2015 by AUSY, a France-based IT consultancy and engineering services firm. With 8 regional offices and 400+ employees, Celerity’s clients span a variety of industries including media and entertainment, healthcare, financial services, manufacturing, non-profit, and hospitality.

You can also get to know us better on Instagram, Facebook, Dribbble, LinkedIn, and Twitter.

Build Your Career

At Celerity, our professional growth plan focuses on individualizing everyone’s track through incorporating personal interests with training and mentorship, while further expanding existing strong suits. We recognize in this ever-evolving digital world, there is extreme value in learning new skills and technologies. Celerity provides opportunities to shape skill sets, work with an amazing team of industry-leading consultants and exciting clients, in addition to professional trainings and certifications that best align with your career goals.   

EEO Employer Verbiage: <p><span style="font-size:10pt;color:#000000">We collaborate. We create. We innovate.</span></p> <p><span style="font-size:10pt;color:#000000"> </span></p> <p><span style="font-size:10pt;color:#000000">Intrigued?</span></p> <p><span style="font-size:10pt;color:#000000"> </span></p> <p><span style="font-size:10pt;color:#000000">You’re a business professional with an innate curiosity that thrives in a dynamic and Agile environment. You appreciate teamwork, exemplify integrity, perseverance, flexibility, and a generosity of spirit… if this sounds like you, then please apply – we’d love to meet you!</span></p> <p><span style="font-size:10pt;color:#000000"> </span></p> <p><span style="font-size:10pt;color:#000000">Celerity is expanding and on the hunt for the savvy, creative, and analytically sound individuals that are motivated by solving complex problems. We’re in the business of transforming how people, process, and systems co-exist, while improving operational efficiencies and user-driven interactions. We work with groundbreaking companies, melding expertise in Digital Strategy, Technology, Creative, and Business Transformation. </span></p>

CountryEEOText_Description: We are proud to be an Equal Opportunity Employer. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. Celerity is committed to providing veteran employment opportunities to our service men and women.