ETL Developer

Join New Era Technology, where People First is at the heart of everything we do. With a global team of over 4,500 professionals, we’re committed to creating a workplace where everyone feels valued, empowered, and inspired to grow. Our mission is to securely connect people, places, and information with end-to-end technology solutions at scale.

At New Era, you’ll join a team-oriented culture that prioritizes your personal and professional development. Work alongside industry-certified experts, access continuous training, and enjoy competitive benefits. Driven by values like Community, Integrity, Agility, and Commitment, we nurture our people to deliver exceptional customer service.

If you want to make an impact in a supportive, growth-oriented environment, New Era is the place for you. Apply today and help us shape the future of work—together.

Title:      ETL Developer 

Job Location:      901 S. Bolmar Street, West Chester, PA 19382 and various unanticipated worksites in U.S.

Primary Duties:

Gather and document data requirements from business stakeholders.  Perform data profiling and data analysis on sources of data.  Create detailed data integration mapping documents.  Work with Data Modelers and Database Architects on the design of database structures in support of applications.  Design and build data integration (ETL) code.  Unit and integration test developed ETL code.  Performance tune ETL code.  Produce design and development documentation.  Create deployment packages for migrating code between environments.  Support user acceptance testing and production deployment activities.  Roving employment.  Travel up to 100% to client sites throughout U.S.  Telecommuting from home office permitted pursuant to company policy.

Requirements:

Education:  Bachelor’s degree or higher (or foreign educational equivalent) in Computer Science, Engineering, or a related field.

Experience:  In addition to the degree, must have at least 3 years of experience in all of the following:

• Working in a design and development capacity for ETL or data integration projects;
• Developing data warehousing concepts, terminology, and architecture;
• Gathering and documenting user requirements and writing technical specifications;
• Performing data analysis and data profiling of source data from databases and platforms;
• Performing data modeling to produce logical and physical data models, using tools such as ERWin or ERStudio; and
• Hands-on ETL development experience with traditional ETL platforms such as Informatica PowerCenter (version 10.x), DataStage, SSIS, or Talend.

Within this, must have at least 2 years of experience with all of the following:

• Modern data integration development using Informatica IICS/IDMC, Microsoft Azure (Data Factory, DataBricks), AWS (Glue, Lambda), Snowflake or cloud agnostic technology such as Matillion, FiveTran, Snaplogic, dbt, Stitch or Hevo; and
• Modern data platforms including Snowflake, Synapse, or Redshift.

Must also have any amount of experience in all of the following:

• Interpreting specifications and data mapping documents to develop workflows with the chosen ETL technology;
• Working with dimensional database structures including facts and slowly changing dimensions;
• Working with change data capture, data replication and other techniques to optimize data ingestion;
• Working with various ingestion patterns, including near real-time or streaming, obtained using APIs and message queues such as Kafka;
• Utilizing windows and UNIX command line scripting to assist with development;
• Optimizing ETL data sourcing with SQL;
• Assessing and resolving performance issues with ETL code;
• Utilizing change management procedures to deploy project artifacts;
• Working with various DevOps frameworks;
• Working in an agile delivery model using agile tools effectively to define and manage assigned work; and  Excellent communication and articulation skills, verbal and written in the English language.

 #LI-DNI

New Era Technology, Inc., and its subsidiaries (“New Era” “we”, “us”, or “our”) in its operating regions worldwide are committed to respecting your privacy and recognize the need for appropriate protection and management of any Personal Data that you may provide us. In this, we are also committed to providing you with a positive experience on our websites and while using our products, services and solutions (“Solutions”).

View our Privacy Policy here https://www.neweratech.com/us/privacy-policy/