Lead ETL Developer Job at Tekfortune Inc, Atlanta, GA

  • Tekfortune Inc
  • Atlanta, GA

Job Description

Job DescriptionJob DescriptionTitle : 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 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

Job Tags

Similar Jobs

BELFOR Property Restoration

Intermediate Restoration Technician Job at BELFOR Property Restoration

 ...removal; Baseboard Removal Properly identify Class 4 material, moisture measurements, and deploy most effective technique to dry/restore the material Evaluate integrity of affected structural materials and contents for direct and indirect water damage; accurately... 

Double L

Plasterer / Yesero Job at Double L

 ...scaffoldsApply weatherproof, decorative coverings to exterior surfaces of buildings, such as by troweling or spraying on coats of stucco.Clean and prepare surfaces for applications of plaster, cement, stucco, or similar materials, such as by drywall taping.Mix substances... 

Guardian Llc

Remote Credentialing Specialist III Job at Guardian Llc

 ...Guardian seeks a Credentialing Support Associate III to maintain provider records and support the credentialing process. You will coordinate outreach, validate information, and ensure compliance with regulatory and organizational requirements in collaboration with providers... 

Zimmerman Advertising

Art Director Job at Zimmerman Advertising

 ...To successfully create high-quality and effective advertising for agency clients. The Art Director transforms compelling and imaginative concepts into visual reality. The Art Director designs according to our brand identity and business objectives. As an Art Director... 

Boeing

Propulsion & Fuel System Engineer (Mid-Level or Senior) Job at Boeing

Propulsion & Fuel System Engineer (Mid-Level or Senior)Company:The Boeing CompanyBoeing Commercial Airplanes (BCA) is seeking a Propulsion & Fuel System Engineer (Mid-Level or Senior) to join the 787 Propulsion Charleston Team in North Charleston, SC.This role combines...