Job Description

Greetings from Ampcus!

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Title: ETL Developer

Duration: 12 months

Work Location: White Plains, NY

Description:

Work Schedule

Monday through Friday 7.5 hour work day with .5 hour unpaid lunch Paid for time worked only; there are no paid holidays, vacation, or sick days Overtime is not permitted unless authorized in advanced. Contingent Worker is required to badge in and out of the turnstiles located in the lobby for all daily entrances and exits.

Project Overview

The details of the different ETL development that will be enabled over the duration of the project are outlined below.

1. a) Analyze the ETL mapping sheet of customer data and create hierarchy for Organizations, Facilities, Accounts and meters
2. b) Analyze the existing hierarchy and propose changes to improve the overall data quality.
3. c) Create detailed design documents for development team use on new or existing customer integrations
4. d) Update the DevOps tasks and assist business in prioritizing the tasks in sprints
5. e) Develop test cases and test the data in QA environment
6. f) Develop ETL flows to ingest data into NYEM platform by extracting, transforming, loading from Energy Cap, BSNY, SAP and other etc.,

Job Functions & Responsibilities

ETL Development:

• Design, build, and maintain efficient ETL workflows to process and integrate solar, Interval, etc., data from multiple sources.
• Optimize ETL processes for performance and scalability.

Data Integration:

• Collaborate with data providers and stakeholders to ensure accurate data ingestion and transformation.
• Develop mechanisms for real-time and batch solar data processing.

Data Quality & Validation:

• Implement robust data validation and cleansing techniques.
• Ensure data accuracy and consistency.

Collaboration:

• Work closely with the business, and analysts.
• Coordinate with IT teams to deploy ETL pipelines in production environments.

Documentation:

• Document ETL processes, workflows, and best practices.
• Maintain clear and concise technical documentation for stakeholders.

Skills

Technical Skills:

• Proficiency in ETL tools such as Pentaho/Microsoft ADF.
• Strong SQL and database management skills (e.g., SQL Server).
• Experience with cloud platforms (e.g., AWS, Google Cloud Platform, Azure).
• Knowledge of Python, Spark, or other programming languages for data processing.

Preferred Skills:

• Familiarity with energy management systems or renewable energy analytics.
• Experience with REST APIs and integrating IoT data, timeseries and Utility Data.

Soft Skills:

• Strong problem-solving skills and attention to detail.
• Excellent communication and teamwork abilities.

Education & Certifications

• Bachelor s degree in Computer Science, Information Systems, Engineering, or a related field.

Experience:

• 5+ years of experience as a Data Engineer or ETL Developer.
• Proven experience in integrating energy, interval data, is preferred.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans, or individuals with disabilities.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

• Dice Id: 10115448
• Position Id: 8511577

Job Tags

Similar Jobs