ETL Developer Job at A R Systems Inc.,, Atlanta, GA

WS81VlZXU0ZsaTdRRGM3Z1cxRGFURitxWEE9PQ==
  • A R Systems Inc.,
  • Atlanta, GA

Job Description

Job Title: ETL Developer

Job Location: Atlanta, GA

Job Visa: USC/GC/H4EAD/OPT/CPT - W2 Only

Job Description:

Design, develop, and maintain ETL solutions using Informatica PowerCenter 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
  • 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

Smith Hanley Associates

Senior Manager, Research & Insights Job at Smith Hanley Associates

 ...Everyone is client-facing; no internal-only roles Fast decision-making, minimal layers Hybrid model with a modern, open think tank office Real work-life balance with predictable busy periods Compensation & Benefits ~$130K$150K base + discretionary bonus... 

Okaya Inc

Quick Hire Freshworks Admin at 100% Remote Job at Okaya Inc

 ...configuration and governance standards, builds and maintains third-party integrations, and directs the day-to-day technical work of two offshore contractor team members supporting the platform. Essential Duties and Primary Responsibilities: Leads planning and... 

FAA Filters LLC

Industrial Sewing Machine Operator Job at FAA Filters LLC

 ...Position Summary Responsible for operating a sewing machine in the construction of components and subassemblies made of industrial textiles. Manufacture subassemblies and finished goods in accordance with quality requirements and manufacturing instructions. Duties... 

Delta-T Group Inc.

Mental Health Worker Job at Delta-T Group Inc.

 ...opportunities within the special education, social service, behavioral health, and disability sectors. With over 35 years in business, we have...  ...contract opportunities. One of our clients is seeking a Mental Health Workers to provide service in Odenton, MD. HOURS *... 

Medpace, Inc.

Drug Safety Associate (Life Sciences Degrees) Job at Medpace, Inc.

 ...clinical research sites to ensure compliance with safety processes. Qualifications Bachelor's degree in life/health science including, but not limited to, Microbiology, Biology, Pharmaceutical Science, Chemistry, or related field; Proficient knowledge of Microsoft...