ETL Developer
AIM Consulting Chicago - Austin, TX

This job posting is no longer available on AIM Consulting Chicago. Find similar jobs:ETL Developer jobs - AIM Consulting Chicago jobs

Job Description AIM Consulting is actively seeking a 2 ETL Developers with strong Informatica skills for long term contracts in Austin, TX. These positions will work a typical 40 hours per week and focus on the following day-to-day responsibilities:

The role is responsible for creating and testing structured ETL processes from design specification and mapping documents. The position requires at least 3 years of experience developing ETL programs that load / integrate data from multiple input sources to database targets and extract / publish data from database sources. Candidates must demonstrate an understanding of ETL development best practices and the software development lifecycle. This role typically reports to an ETL or project team lead.

  • Perform data profiling on incoming data sources to assess quality
  • Utilize design specifications and source to target mapping documents to develop ETL programs
  • Code and test complex ETL programs using Informatica
  • Create unit test conditions, record and document results
  • Execute, schedule and test job streams and build an operational ETL system that is automated, stable and efficient
  • Conduct System Testing - execute job flows, investigate system defects, resolve defects and document test results
  • Deliver easy to maintain, re-usable modules that adhere to architectural governance standards and practices
  • Off hour and weekend support may be required to meet project milestones
  • 3 years experience as ETL programmer on data warehouse or database projects
  • 1 plus years developing programs using ETL tools such as Informatica Power Center, IBM InfoSphere DataStage 8.x, Informatica or equivalent
  • Experience in SQL and programming applications using Relational Database Management Systems
  • Experience performing data analysis and researching data quality issues
  • Experience working on large system implementation projects

Additional Information Check out my website @