What are the responsibilities and job description for the ETL Developer position at New Era Technology?
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:
View our Privacy Policy here https://www.neweratech.com/us/privacy-policy/
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.
- 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.
- 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.
View our Privacy Policy here https://www.neweratech.com/us/privacy-policy/
