Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Lead ETL Developer

Phoenix Business, Inc

Job Description

Job Description

Lead 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

Vacancy posted 26 days ago
Similar jobs that could be interesting for youBased on the Lead ETL Developer in Atlanta, GA vacancy
  •  ...Job Description Job Description Title : Lead ETL Developer with Snowflake, Informatica Location : Atlanta / Charlotte / Raliegh(Onsite) Rate :65/hour USC/GC Lead ETL Developer is responsible for supporting enterprise data integration, data warehouse, and... 
    Suggested

    Tekfortune Inc.

    Atlanta, GA
    26 days ago
  •  ...Salesforce Technical Lead Location: Atlanta, GA Duration: Full Time Job Description: ~ Minimum 6-8 years of experience in...  ...Understand data migration considerations, design trade-offs, and common ETL tools Experience with common integration patterns used on the... 
    Suggested
    Full time

    JConnect Infotech

    Atlanta, GA
    4 days ago
  • $152k - $200k

    At Prologis, we don’t just lead the industry—we define it with a 1.3 billion square foot...  ...data through APIs, middleware, ETL/ELT, data pipelines, and data platforms such...  .../CD, automated testing, API development, developer tooling, and cloud-based application architectures... 
    Suggested
    Full time
    Contract work

    Prologis

    Atlanta, GA
    3 days ago
  •  ...specialization for a minimum of 2 years.At least 4 years of experience in Architecture, Design, Data modeling and Development of DW and ETL solutions using AbInitioExtensive experience in end-to-end implementation of Business Intelligence (BI) projects, especially in data... 
    Suggested
    H1b

    Sonsoft

    Atlanta, GA
    12 hours ago
  • Company DescriptionXinnovit is a global leader in technology consulting, outsourcing, and workforce management solutions.Our mission is to enable our clients to become more agile and competitive with the help of innovative technologies. We empower our clients to respond...
    Suggested
    Work experience placement

    Xinnovit

    Atlanta, GA
    12 hours ago
  • $140k - $160k

     ...Job Description Job Description Position: Snowflake Technical Lead Location: Atlanta, GA (Onsite) Duration: Full-time Salary...  ...Azure Datawarehouse. 3-5 years working experience with ADF (ETL) and Azure Databricks. Should have Experience on Data Modeling... 
    Full time
    Work experience placement
    Work at office

    Diverse Lynx

    Atlanta, GA
    24 days ago
  •  ...systems with a good understanding of their Data Models and ETL proceduresExpert use of complex expressions, set analysis...  ...life cycle projectsShould be able to play a technical lead and mentor junior ETL developer and ramp up the teamQualificationsBachelor’s degree or foreign... 

    Sonsoft

    Atlanta, GA
    2 days ago
  •  ...DescriptionShould have experience in playing the role of a MDM Architect and leading large MDM Implementation for a full SDLC lifecycle.Good...  ...of at least one Data Quality toolGood Knowledge of at least one ETL Tool Awareness of MDM trends, MDM Concepts and other tools in... 

    Sonsoft

    Atlanta, GA
    2 days ago
  •  ...lasting value for clients. Powered by our purpose the relentless pursuit of a world that works better for people we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and... 
    Remote work

    Genpact

    Atlanta, GA
    3 days ago
  •  ...now and discover a career where your contributions are valued, your growth is supported, and your work makes a lasting impactThe Lead Developer serves as a senior technical leader for the Dynamics 365 Customer Engagement and Power Platform team. This role is responsible... 
    Full time
    Work at office
    Remote work
    Weekend work
    3 days per week

    Pulte Group

    Atlanta, GA
    2 days ago
  •  ...exchanges and clearing houses that connect companies around the world to global capital and derivative markets. With a leading-edge approach to developing technology platforms, we have built market infrastructure in all major trading centers, offering customers the... 

    Intercontinental Exchange

    Atlanta, GA
    2 days ago
  • OverviewJob PurposeIntercontinental Exchange (ICE) is seeking a Lead Engineer responsible for architecting and delivering...  ...knowledge pipelines, and similar solutions that directly improve developer productivity, quality, and throughput.The ideal candidate brings... 

    Black Knight Financial Services

    Atlanta, GA
    12 hours ago
  • Job PurposeICE Data Services (an Intercontinental Exchange company) is seeking an experienced Lead Market Data Developer - Java to build fixed income pricing systems. The role will support our Fixed Income and Liquidity data products. This is an opportunity to join a growing... 

    Intercontinental Exchange

    Atlanta, GA
    1 day ago
  •  ...orientation, gender identity, national origin, disability, or veteran status.MedscapeLIVE! is seeking a highly autonomous Lead Software Developer to serve as a technical anchor and driver of innovation for our registration portals and promotional live events. In this role... 
    Full time
    Part time
    Flexible hours

    WebMD

    Atlanta, GA
    2 days ago
  •  ...Job Description We are seeking an experienced AS400 / IBM i Developer with WebSphere EDI expertise to take full operational ownership...  ...primary Subject Matter Expert (SME). Once onboarded, you will lead future AS400 development, modernize EDI data pipelines, optimize... 

    Expert In Recruitment Solutions

    Atlanta, GA
    6 days ago
  • $102.3k - $209.5k

     ...Description As a recognized authority and leading contributor within their practice, this...  ...Mulesoft, Celigo, Workato or Snaplogic) ETL tools and techniques Experience in the following...  ...and/or Agile scrum master experience Developing and optimizing NetSuite SuiteScript,... 
    Temporary work
    Flexible hours

    Oracle Defunct

    Atlanta, GA
    3 days ago
  •  ...J2EE development and architecture. Expertise in designing and developing Restful APIs Hands-on experience in developing applications using...  ...communication between systems. Extensive experience with leading the design and development of APIs that enable integration between... 

    Yochana

    Atlanta, GA
    3 days ago
  • Job Description: - 1.Job title DRUPAL SR. DEVELOPER 2.Job summary DRUPAL SR. DEVELOPER with Drupal - Content Authoring, Drupal - Workbench Moderation, Drupal - Workflow Management, Drupal Basics & Core Arch, Drupal - Default Search 3.Experience 10to14yrs 4.Required Skills... 
    Second job
    Shift work

    3B Staffing LLC

    Atlanta, GA
    3 days ago
  •  ...Looking for a hands-on Technical Lead who enjoys building scalable applications, solving real-world technical challenges, and delivering impactful solutions on Microsoft Azure. · Strong .NET Full Stack expertise with hands-on experience in .NET, C#, REST APIs, and backend... 
    Contract work

    Long Finch Technologies

    Atlanta, GA
    29 days ago
  •  ...Job Description Job Description Lead Developer Full Stack (.NET/Angular & Azure) Location: Atlanta, GA (Hybrid: 4 days onsite, 1 day remote) OR Tempe, AZ (Hybrid: 3 days onsite, 2 days remote) Job Type: Contract-to-Hire Schedule: East Coast Hours About... 
    Contract work
    Remote work

    TRC Talent Solutions

    Atlanta, GA
    10 days ago
  • $207k - $300k

    Design and develop software systems to plan Google's long-term infrastructure network through graph modeling and optimization engines...  ...software to hardware our teams are shaping the future of world-leading hyperscale computing, with key teams working on the development... 
    Worldwide

    Google

    Atlanta, GA
    4 days ago
  • OverviewJob PurposeIntercontinental Exchange (ICE) is seeking a Lead Developer - Front-End Web Development, responsible for building and supporting large-scale enterprise applications that integrate with back-end systems using RESTful web services and JavaScript APIs.... 
    Worldwide

    Black Knight Financial Services

    Atlanta, GA
    4 days ago
  •  ...their ability to drive real progress.Position Overview:We are seeking an experienced and technically sophisticated Salesforce Lead Developer to help drive our multi-phased Salesforce transformation. Partnering closely with technical leadership and business stakeholders... 
    Full time
    Worldwide

    Starr Companies

    Atlanta, GA
    2 days ago
  •  ...development experience in Actimize IFM Solutions Experience in developing customized AIS and RCM Components. Good Knowledge and understanding...  ...SQL server queries and Stored Procedures. Should be able to lead the team and co-ordinate with multiple teams. Good... 
    Work experience placement

    TechDigital Corporation

    Atlanta, GA
    26 days ago
  •  ...and a high standard of professionalism.This role is part of a team of software developers who build and maintain global corporate tools that support teams across the organization. The lead developer is a senior member of the team who sets direction for tools and development... 

    Intercontinental Exchange

    Atlanta, GA
    2 days ago
  •  ....BE Tech Stack Java/J2EE, JSPs, Spring Boot, Spring Cloud, Experience developing Microservices, Understanding of Cloud, REST / SOAP, Integration, Hibernate, OracleDBQualificationsRequired(Sr. or Lead Profiles)Additional InformationSyed Mohammad Asif(***) ***-****SummaryType... 

    SA Technologies

    Atlanta, GA
    2 days ago
  • Role: Lead Web Developer Work Location: Atlanta, GA Duration: Long term Job Description: Qualification - External Delivery Architects assess a project's technical feasibility, as well as implementation risks. They are responsible for designing and implementing a project... 
    Daily paid
    Relocation

    Avani Technology Solutions

    Atlanta, GA
    1 day ago
  • $145k

    Travel Management System TMS Lead Developer Immediate need for a talented Travel Management System TMS Lead Developer. This is a Fulltime opportunity with long-term potential and is located in Atlanta, GA (Hybrid). Please review the job description below and contact me... 
    Permanent employment
    Full time
    Local area
    Immediate start

    Pyramid Consulting

    Atlanta, GA
    3 days ago
  • Title: iOS Lead Location: Atlanta, GA (Hybrid) Duration: 6+ months Implementation Partner: Infosys End Client: To be disclosed JD:...  ...and debugging. Experience with Git and version control. Previous experience leading technical teams or mentoring developers. Wise Skulls

    Wise Skulls

    Atlanta, GA
    3 days ago
  •  ...Aimpoint Digital is a market-leading data, AI, analytics, and operations research advisory...  ...modern AI engineering best practices  Develop backend services, APIs, and application architectures...  ...building data pipelines, including ETL, ELT, batch, and streaming pipelines for... 
    Full time
    Remote work

    Aimpoint Digital

    Atlanta, GA
    5 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Lead ETL Developer. Be the first to apply!