ETL Developer Job at ACS Consultancy Services, Albany, NY

MHpZK1M0Rm5zcWM4UlJSa29FSk85V3Y3V0E9PQ==
  • ACS Consultancy Services
  • Albany, NY

Job Description

Job Title: ETL Developer

Location: Remote

We are currently seeking candidates who meet the following qualification

Responsibilities:

  • Design, develop, and implement ETL workflows for data integration from various sources (relational databases, flat files, APIs, etc.) into data warehouses and data lakes.
  • Develop and optimize complex SQL queries and stored procedures to manipulate and transform data.
  • Ensure data integrity, accuracy, and consistency by performing data validation and data quality checks.
  • Maintain and optimize ETL pipelines to improve performance, scalability, and reliability.
  • Collaborate with business analysts and data teams to gather and understand requirements for data processing and reporting.
  • Monitor and troubleshoot ETL jobs to ensure timely and successful data loads.
  • Perform performance tuning and optimization of ETL processes.
  • Document ETL processes, workflows, and data models for future reference and compliance.
  • Stay up to date with new technologies and best practices related to data integration and ETL processes.

Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent work experience).
  • Experience as an ETL Developer or in a similar role.
  • Hands-on experience with ETL tools such as Informatica, Talend, Apache Nifi, Microsoft SSIS, or other industry-standard ETL platforms.
  • Strong proficiency in SQL for querying, data transformation, and working with relational databases.
  • Experience with cloud data platforms like AWS, Azure, or Google Cloud is a plus.
  • Experience in data warehousing concepts and architectures.
  • Experience working with data integration from disparate sources including relational databases, flat files, APIs, and cloud storage.
  • Understanding of data modeling, data quality standards, and best practices for ETL performance.
  • Ability to write and maintain clear, efficient, and reusable ETL code.
  • Knowledge of version control tools such as Git.
  • Excellent problem-solving, debugging, and troubleshooting skills.
  • Federal Experience is a plus.
  • Required Security clearance.


    If you meet these qualifications, please submit your application via link provided in Linkedin.
    Kindly do not call the general line to submit your application.

Job Tags

Work experience placement, Remote job,

Similar Jobs

Carter Machinery

PROJECT MANAGER Job at Carter Machinery

 ...Carter Machinery Location: Mechanicsville, VA 23116, USA Category: Project Management Posted Date: November 7, 2024 Requisition_Number: PROJE004709 Schedule: Full Time EOE Statement Equal Opportunity Employer/Protected Veterans/Individuals with... 

The Gateway School

School Secretary Job at The Gateway School

 ...The Gateway School is seeking a School Secretary to join our team and provide main desk reception and secretarial/administrative support to the school community. Responsibilities Include: Monitor the arrival and attendance of students and staff, and actively... 

See Rock City Inc

Clumpies Ice Cream Team Leader (Part-Time) Job at See Rock City Inc

Description: Summary: Responsible for leading the daily operations of Clumpies Ice Cream. Performs tasks including, but not limited to, inventory, coaching and counseling partners, portion control, and cash handling. Under the direction of the Clumpies Manager the...

RJ Schinner Co

Class A CDL Driver Job at RJ Schinner Co

 ...disposable paper, cleaning, and food service packaging products to distributors in 48 states....  ...southeastern Wisconsin. Class A CDL Driver Summary Class A CDL | Company...  ...~ Previous experience making multiple deliveries ~ Effective problem-solving skills ~... 

CEDENT

Clinical Research Associate Job at CEDENT

 ...Summary: The Clinical Research Associate (CRA) is responsible for managing and maintaining the Study Master File, tracking essential trial information, and supporting Regional Clinical Research Associates. Working under the guidance of a Clinical Manager or Director,...