Job Details

ID #21372413
State North Carolina
City Charlotte
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source IT Trailblazers, LLC
Showed 2021-10-19
Date 2021-10-15
Deadline 2021-12-13
Category Et cetera
Create resume

Lead ETL Developer

North Carolina, Charlotte, 10001 Charlotte USA

Vacancy expired!

Title: Lead ETL Developer

Location: Charlotte, NC (Initial Remote)

Duration: 6+ Months

Job Description:We are looking for Senior ETL development Lead or strong individual contributor in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology (Tera Data, Oracle 19c, Informatica Powercenter v10.2, Informatica, Ab Initio), tools (SqlDeveloper, github), Unix Scripting, and existing design methodologiesThe candidate will strong and clear oral communication skills who will engage not only with development team members, but also with business stakeholders

ETL Development Lead responsibilities include:
  • Analyzes highly complex business requirements, designs and writes technical specifications to design or redesign complex computer platforms and applications
  • Lead and guide development team on Informatica based ETL architecture
  • Develop solution in highly demanding environment and provide hands on guidance to other team members
  • Develop & Implement an Informatica based ETL solution fulfilling stringent performance requirements
  • Collaborate with product development teams and senior designers to develop architectural requirements to ensure business requirements are met
  • Assist and verify design of solution and production of all design phase deliverables.
  • Perform detailed data analysis to understand the source system data
  • Review physical Database objects including staging, materialized views, indexes provided by Data Modeler.
  • Work with appropriate leads and review high level ETL design, source to target data mapping document and be the point of contact for any ETL related questions
  • Coordinate ETL and database development work with offshore ETL developers and conduct code reviews
  • A BS/BA degree or higher
  • 7+ years of Ab Initio experience
  • 7+ years of Informatica experience
  • 7+ years of Teradata experience
  • 7+ years of Oracle experience
  • 7+ years of SDLC (System Development Life Cycle) experience
  • 7+ years of application production support experience
  • 7+ years of experience with Waterfall and Agile project methodologies
  • 5+ years of experience with Automated Financial Systems (AFS) is a Plus
  • Preferred working experience of following financial services platforms will be added advantage:
  • 2+ years of experience working with Loan IQ software is a Plus
  • 7+ years of experience with end-to-end design and delivery of ETL (Extract, Transform, Load) applications
  • 5+ years of experience with Oracle Financial Services Analytical Applications (OFSAA) platform in one or a combination of the following:
  • Financial Services Data Foundation (FSDF), General Ledger reconciliation, Data Quality Framework, or Run Rule Framework - is a Plus

Vacancy expired!

Subscribe Report job