ETL Data Integration Lead

Location: Harrisburg, Pennsylvania, United States


This position is no longer open.

Requisition Number: 8658

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.

Here’s what you’ll do in this role:

  • 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

 Your 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, 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
  • Impeccable integrity. We are team-first at Celerity
  • A positive attitude. We can have fun while we work hard to solve business challenges
  • A heart for people. Excellent relationship-building skills across teams, peers, clients, vendors
  • A head for business. Nothing falls through the cracks on your watch
  • A passion for results. You strive to work complex issues with a strong sense of ownership and urgency.

Remote: 1

City: Harrisburg

State: Pennsylvania

Ext Portal Job Header:

Community / Marketing Title: ETL Data Integration Lead

Company Profile:

Find your home at Celerity

At Celerity, authenticity isn’t just a buzz word. It’s a promise to each other and to our clients that we will bring our true, best selves to every interaction, to every solution. We hire for the person -- not for the role. And we believe in surrounding ourselves with not only the best and brightest innovative thinkers, but with those of highest integrity who are purpose-driven in all that they do. That's how we've come to be known by our clients as the consultancy that delivers impact, not ego.

Our culture attracts people who crave something greater than a job: meaningful opportunities in an environment of mutual respect. Every kind of talent is celebrated here. We look for people who share our values to be bold, innovative, and a transformative force for our clients. Through opportunities to shape skill sets and work with industry-leading consultants and exciting clients, including access to professional trainings and certifications that best align with your career goals, Celerity provides the freedom to grow both personally and professionally.

We offer a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace. Find out more at

EEO Employer Verbiage: <p><strong>We Are Celerity<br /></strong></p> <p> </p> <p>Founded in 2002, Celerity <span style="color:black;background:white">is a business and technology consulting firm dedicated to helping businesses respond to change—efficiently, quickly, and with focus on the customer. We specialize in digital experience, change management, operational efficiency, and the integration between them all.</span> Celerity is the premium solutions partner of Randstad Technology Group (RTG US).</p> <p> </p> <p>This is an extraordinary time to be in business. As digital transformation continues to accelerate and businesses are challenged to quickly respond, Celerity is leading the way — supporting transformative change for our clients and offering our professionals exciting career opportunities.</p> <p> </p> <p>We help businesses thrive in a changing environment. Join us.</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.