ETL Developer (Informatica)

The Data Warehouse ETL Developer is responsible for application development tasks and assignments related to data integration as well as preparation of detailed specifications, diagrams and other programming structures related to ETL processes. This individual will design, code, test, debug and document moderately complex programs and applications in addition to performing application maintenance tasks.

Responsible for the design, development, documentation of ETL processes

Work in a complex environment which includes Database, Job Scheduling/Automation/Performance Tools

Participate in ETL Design sessions with the team

Production support of new or changing mappings and workflows and produce technical specifications

Responsible for the analysis, data profiling, development, and integration of disparate systems throughout all phases of the project life cycle

Work as part of a team delivering high quality and efficient integration solutions

Assist in ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities

Implement best practices and tune for optimization

Complete assignments in a timely manner

Complete any other work as assigned

Requirements

Must have a Bachelors in Computer Science or related field

At least 2-3 years of experience in technical development

At least 2-3 years of experience with Informatica PowerCenter ? Additional Experience with SSIS or Talend is a plus

At least 2-3 years of experience with Oracle Database

Possess great diligence while also being flexible to adapt to a dynamic environment and changing priorities.

Excellent SQL, PL/SQL, and Database Skills - Python / R are a plus

Some prior use of Toad for Oracle or any similar tools a plus

Explicit Understanding of SQL and some experience in a database environment

Familiarity with data modeling ? Star/Snow-flake schemas

Experience with erwin Data Modeler software a plus

Experience working in a corporate IT or similar environment

Persuasive communication skills

Dependability and adaptability

Ability to work in a team/collaborative setting

Technical proficiency