ETL Developer

Apptad Inc; Georgia; On-site; USD 90,000 - 120,000; Full time

Job summary

Apptad Inc in the United States is seeking an ETL Developer with Snowflake and Informatica to support enterprise data integration, data warehouse, and regulatory reporting initiatives onsite in Atlanta, Charlotte, or Raleigh.

Design, develop, and maintain ETL pipelines with Informatica PowerCenter and DBT+ Snowflake; perform data profiling, validation, and impact analysis; and collaborate with analysts, architects, and QA to ensure accuracy, performance, and audit readiness.

Qualifications

• Experience designing, developing, and maintaining ETL solutions for data warehouses.
• Strong expertise with Informatica PowerCenter and dbt with Snowflake.
• Proficient with Oracle SQL/PLSQL; Unix/Linux experience is a plus.
• Familiarity with regulatory reporting requirements gaining.
• Ability to collaborate with analysts, architects, and auditors to ensure compliance.

Responsibilities

• Design, develop, and maintain ETL solutions using Informatica PowerCenter and DBT+ Snowflake to support enterprise data warehouse and regulatory reporting requirements.
• Analyze business and technical requirements and translate them into scalable data integration solutions.
• Perform data profiling, source system analysis, and business rule validation to support data integration initiatives.
• Optimize ETL workflows for performance, reliability, and scalability through tuning and best practices.
• Investigate and resolve production issues, ETL failures, data discrepancies, and performance bottlenecks through root cause analysis.
• Conduct data validation, reconciliation, and quality checks to ensure accuracy, completeness, and consistency of data.
• Perform impact analysis for source system changes, business rule modifications, and database enhancements.
• Assess upstream and downstream dependencies across ETL processes, databases, reports, and consuming applications.
• Support the full development lifecycle, including testing, UAT, deployment validation, monthly releases, and environment migrations.
• Collaborate with business analysts, data analysts, architects, and other stakeholders while maintaining technical documentation and supporting audit/compliance requirements.

Skills

ETL Development

Data Warehousing

Data Integration

Data Profiling & Validation

Performance Tuning

Data Governance & Data Lineage

Release & Change Management

Regulatory Reporting

Tools

Informatica PowerCenter

DBT + Snowflake

Oracle SQL & PL/SQL

Unix/Linux

Job description

Title : ETL Developer with Snowflake, Informatica

Location : Atlanta / Charlotte / Raliegh(Onsite)

USC/GC

ETL Developer is responsible for supporting enterprise data integration, data warehouse, and regulatory reporting initiatives. The role involves designing, developing, enhancing, and maintaining ETL solutions, performing data analysis and validation, supporting application enhancements, and implementing new data integrations. The ideal candidate will have strong expertise in DBT+Snowflake, Oracle SQL/PLSQL, Informatica PowerCenter, data warehousing, and ETL development within complex enterprise environments.

Key Responsibilities:

• Design, develop, and maintain ETL solutions using Informatica PowerCenter and DBT+ Snowflake to support enterprise data warehouse and regulatory reporting requirements.
• Analyze business and technical requirements and translate them into scalable data integration solutions.
• Perform data profiling, source system analysis, and business rule validation to support data integration initiatives.
• Optimize ETL workflows for performance, reliability, and scalability through tuning and best practices.
• Investigate and resolve production issues, ETL failures, data discrepancies, and performance bottlenecks through root cause analysis.
• Conduct data validation, reconciliation, and quality checks to ensure accuracy, completeness, and consistency of data.
• Perform impact analysis for source system changes, business rule modifications, and database enhancements.
• Assess upstream and downstream dependencies across ETL processes, databases, reports, and consuming applications.
• Support the full development lifecycle, including testing, UAT, deployment validation, monthly releases, and environment migrations.
• Collaborate with business analysts, data analysts, architects, and other stakeholders while maintaining technical documentation and supporting audit/compliance requirements.

Key Skills

• Informatica PowerCenter
• DBT with Snowflake
• Oracle SQL & PL/SQL
• Unix/Linux
• ETL Design & Development
• Data Warehousing
• Data Integration
• Data Profiling & Validation
• Performance Tuning
• Data Reconciliation
• Impact Analysis
• Release & Change Management
• Data Governance & Data Lineage