ETL Architect

Scadea Solutions Inc

$100K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 7-10 years of experience in ETL design
  • Proficient in Data Stage with hands-on experience in 2+ projects
  • Strong knowledge of Data Warehouse and Data Marts
  • Ability to develop and enforce ETL standards and best practices
  • Proficient in creating ETL frameworks and specifications for developers
  • Experience with Oracle, SQL Server, or other database systems
  • Good analytical skills and understanding of process design

Responsibilities

  • Gather and convert business requirements into technical specifications
  • Develop and maintain ETL design frameworks for development use
  • Ensure adherence to coding standards and quality controls
  • Conduct unit tests and document technical components
  • Participate in product testing and user acceptance tests
  • Establish and manage project testing plans and controls
  • Coordinate project interrelationships and deliverables

Benefits

  • Exposure to advanced tools like IBM's Infosphere products
  • Opportunity to work in a collaborative environment
  • Potential to shape best practices in ETL development
  • Involvement in critical phases of software configuration and testing
  • Long-term contract length providing job stability
Full Job Description
Job title: ETL Architect

LOCATION: Cincinnati, OH

DURATION 18 months

YEARS OF EXPERIENCE 7-10

INTERVIEW TYPE Phone Screen to Hire

REQUIRED SKILLS
• Experience with Data Stage and ETL design

Technical
• Requirement gathering , converting business requirements to technical specs to profile
• Worked hands on in minimum 2 projects with data stage
• Understand the process of developing an etl design that support multiple datastage developers
• Be able to create an etl design framework and related specifications for use by etl developers
• Define standards and best practices of Data Stage etl to be followed by all data stage developers
• Understanding of Data Warehouse, Data marts concepts and implementation experience
• Be able to look at code produced to insure conformance with developed ETL framework and design for reuse
• Preferable experienced user level comptency in IBM's metadata product, datastage and Infosphere product line
• Be able to design etl for oracle or sql server or any db
• Good analytical skills and process design
• Insuring compliance to quality standards, and delivery timelines.

Qualifications

Bachelors

Additional Information

Required Skills:

Job Description:

Performs highly complex application programming/systems development and support Performs highly complex configuration of business rules and technical parameters of software products Review business requirements and develop application design documentation Build technical components (Maximo objects, TRM Rules, Java extensions, etc) based on detailed design.

Performs unit testing of components along with completing necessary documentation. Supports product test, user acceptance test, etc as a member of the fix-it team. Employs consistent measurement techniques Include testing in project plans and establish controls to require adherence to test plans Manages the interrelationships among various projects or work objectives

Similar Jobs

More Jobs at Scadea Solutions Inc

More Information Technology Jobs

Find similar ETL Architect jobs: