ETL Developer

Experience: 12+ Years
Location: Georgia

Position Overview

We are seeking an experienced ETL Developer with 12+ years of expertise in designing, developing, and maintaining enterprise data integration and data warehousing solutions. The ideal candidate will have strong experience in ETL/ELT development, data modeling, database technologies, cloud platforms, and big data processing. The candidate will be responsible for building scalable data pipelines and ensuring data quality, integrity, and performance across enterprise systems.

Key Responsibilities

• Design, develop, and maintain ETL/ELT processes for enterprise data integration projects.
• Develop and optimize data pipelines to extract, transform, and load data from multiple sources.
• Design and implement data warehouse solutions, data marts, and data integration frameworks.
• Analyze business requirements and translate them into technical ETL solutions.
• Develop data mapping documents, transformation logic, and technical specifications.
• Perform data cleansing, validation, reconciliation, and quality assurance activities.
• Optimize ETL performance, query execution, and database operations.
• Implement batch and real-time data processing solutions.
• Collaborate with business analysts, data engineers, and data architects to support reporting and analytics initiatives.
• Monitor ETL jobs and troubleshoot production issues.
• Implement error handling, logging, auditing, and recovery mechanisms.
• Support data migration and system integration initiatives.
• Participate in code reviews, release management, and deployment activities.
• Create and maintain technical documentation and operational procedures.
• Mentor junior developers and promote ETL best practices.

Required Skills & Qualifications

• 12+ years of experience in ETL Development and Data Integration projects.
• Strong hands-on experience with ETL tools such as Informatica PowerCenter, SSIS, Talend, DataStage, AWS Glue, or Azure Data Factory (ADF).
• Strong SQL expertise with Oracle, SQL Server, PostgreSQL, MySQL, or Snowflake.
• Experience in data warehousing concepts, dimensional modeling, and star/snowflake schemas.
• Strong understanding of ETL design patterns and data transformation techniques.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (Google Cloud Platform).
• Knowledge of Big Data technologies such as Spark, Hadoop, Hive, Kafka, or Databricks is preferred.
• Experience with scripting languages such as Python, Shell Scripting, or PowerShell.
• Familiarity with CI/CD pipelines, Git, and DevOps practices.
• Strong understanding of data governance, data quality, and data security principles.
• Experience working in Agile/Scrum environments.
• Excellent analytical, troubleshooting, and communication skills.

Preferred Qualifications

• Experience with Snowflake, Databricks, Azure Data Factory (ADF), AWS Glue, and Apache Airflow.
• Knowledge of real-time data integration and streaming technologies.
• Experience with Master Data Management (MDM) and Data Governance initiatives.
• Cloud certifications such as AWS Data Analytics, Azure Data Engineer Associate, or Google Professional Data Engineer are preferred.
• Experience in Banking, Healthcare, Insurance, Retail, or Financial Services domains is highly desirable.

Educational Qualifications

• Bachelor''s degree in Computer Science, Information Technology, Engineering, or a related field.
• Master''s degree preferred.