ETL Developer

Job Description

Job Description

Company Overview:

A & Associates is a reputable staffing agency with a proven track record in screening and recruiting as well as job placement and career development. With more than ten (10) offices throughout the United States, A & Associates is a company that can be trusted to provide a diverse level of services with excellence, diligence and integrity. “Quality In Everything We Do” is far more than our mantra, it is our standard!!

Explore a career with A & Associates, one of the leading providers for temporary, temp-to-hire, permanent placement services and security guard services.

ETL Developer

Job Summary

We are seeking a skilled ETL Developer to design, develop, test, and maintain Extract, Transform, and Load (ETL) processes that support enterprise data integration and reporting. The ideal candidate will have experience working with data warehouses, relational databases, ETL tools, and SQL, with a strong understanding of data quality and performance optimization.

Key Responsibilities

• Design, develop, and maintain ETL workflows to extract data from multiple source systems.
• Develop data transformation logic to ensure data accuracy, consistency, and integrity.
• Load transformed data into data warehouses, data lakes, or operational databases.
• Create and optimize SQL queries, stored procedures, and database objects.
• Monitor ETL jobs, troubleshoot failures, and resolve performance issues.
• Collaborate with business analysts, data engineers, and application teams to gather data requirements.
• Perform data validation, reconciliation, and quality checks.
• Maintain technical documentation for ETL processes and data mappings.
• Implement error handling, logging, and recovery mechanisms.
• Support production deployments and ongoing maintenance activities.
• Optimize ETL processes for scalability and performance.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 3+ years of experience in ETL development.
• Strong proficiency in SQL and relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
• Experience with ETL tools such as Informatica PowerCenter, SSIS, Talend, IBM DataStage, or Pentaho.
• Knowledge of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
• Experience with data integration, data migration, and data validation.
• Familiarity with version control systems such as Git.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and teamwork skills.

Preferred Qualifications

• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Knowledge of Python, Shell scripting, or PowerShell.
• Experience with Big Data technologies such as Spark or Hadoop.
• Familiarity with CI/CD pipelines and DevOps practices.
• Understanding of data governance and security best practices.

Technical Skills

• SQL
• ETL Tools (Informatica, SSIS, Talend, DataStage, Pentaho)
• Data Warehousing
• Oracle, SQL Server, PostgreSQL, MySQL
• Python or Shell Scripting
• Git
• Cloud Platforms (AWS, Azure, GCP)
• Data Modeling
• Performance Tuning

Soft Skills

• Strong analytical thinking
• Problem-solving ability
• Attention to detail
• Communication skills
• Collaboration and teamwork
• Time management

Nice-to-Have Certifications

• Informatica Certified Professional
• Microsoft Certified: Azure Data Engineer Associate
• AWS Certified Data Engineer
• Snowflake SnowPro Certification
• Databricks Certified Data Engineer

Equal Employment Opportunity Statement:

A & Associates is an equal opportunity employer and is committed to maintaining a diverse and inclusive workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected classification in accordance with applicable federal, state, and local laws. The company is dedicated to providing a workplace free of discrimination, harassment, and retaliation, and ensures that all employment decisions are based on qualifications, merit, and business needs.