200+ applicantsPosted by Agency

Company

ACS Consultancy Services, Inc · 1 day ago

ETL Developer

United States

Full-time

Remote

Entry, Mid Level

Maximize your interview chances

ConsultingInformation Services

No H1B

U.S. Citizen Only

Security Clearance Required

Insider Connection @ACS Consultancy Services, Inc

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

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.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

ETL DevelopmentSQLData IntegrationInformaticaTalendApache NifiMicrosoft SSISData WarehousingAWSAzureGoogle CloudData ModelingData Quality StandardsVersion Control (Git)Debugging

Required

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 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.

Required Security clearance.

Preferred

Experience with cloud data platforms like AWS, Azure, or Google Cloud is a plus.

Federal Experience is a plus.

Company

ACS Consultancy Services, Inc

ACS Consultancy Services Inc is a Small Business that is New York State and New York City Certified Minority and Women-Owned Business Enterprise (MWBE).

Founded in 2011