ETL Architect/Technical Lead in Smyrna, GA at HUNTER Technical Resources

Date Posted: 11/25/2019

Job Snapshot

  • Employee Type:
  • Location:
    Smyrna, GA
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
  • Job ID:

Job Description

ETL Architect & Technical Lead

  • Lead a team of ETL Developers/architects both onsite/offshore.
  • Leads in writing and reviewing software functional specifications.
  • Participate in Architecture Review boards as an approver and participant.
  • Mentors team and provide technical and strategic leadership
  • Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks.
  • Remains current on Enterprise Data Warehousing technologies, testing industry trends and best practices
  • Design and Develop any/all ETL processes.
  • Responsible for resource allocation.

Required skills and abilities:
  • Serve as the liaison between business users, database management team and software development/integration teams.
  • Project management experiences a plus.  
  • Bachelor’ s degree preferred.
  • Complete understanding of all phases of the software development life cycle.
  • Expert Knowledge of application design principles, systems development and analysis.
  • Complete understanding of relational database design and architecture
  • Advanced Informatica design and development skills using Informatica power center and power exchange.
  • 10+ years of experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager
  • 5+ years of experience in PL/SQL
  • Must be well versed with database concepts like indexing, partitioning, performance tuning, explain plans, materialized views
  • 3+ years of experience writing shell scripts.
  • Expertise in running jobs using various schedulers.
  • 10+ years’ experience with data warehouse solution designs supporting data stores such as ODS, EDW and DataMarts
  • 10+ years of experience with design oflarge scale ETL solutions integrating internal and external data sources
  • 10+ years of experience creating design documents like High Level and Low Level design documents.
  • Experiencetroubleshooting and resolving issues related to ETL applications and ETL system performance.
  • MDM and Data Governance experience will be a plus.