Title: Senior ETL Developer
Skills: See Job Description Details
Date: 1-24-2008
Location: Denver, CO
Area code: 303
Tax term: FULLTIME
Pay rate: Depends on Exper.
Length: Employee
Position ID: 103380
Dice ID: RTL297290
Job description: DTC Asset Management Company is looking to fill a lead developer position within their IT Business Intelligence Reporting Team.
The work involves defining and implementing standards for ETL in a new data warehouse environment. Additionally, this individual is responsible for ensuring that these standards are followed by other ETL developers and will participate in hands-on creation, tuning and testing of ETL, integration and data quality code. The role is critical to the success of the new data warehouse and therefore requires broad technical experience.
Duties/Responsibilities:
** Design, development, testing, implementation, and Tier 3 support of ETL and integration solutions
** Assist in establishing the foundation data warehouse stage and integration layers in production, test and development environments
** Conversion/Migration of legacy data into new systems
** Lead development of new data quality and data profiling routines to process external data
** Develop key integrations with external vendor systems
** Collaborate with team members to prototype, test, and debug code which will provide data for use in business reports
** Work directly with ETL vendor representatives to resolve ETL application errors
** Be the primary contact for other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
** Manage overall ETL environment, including configuration management, releases, metadata, user administration and standards
** Write and maintain technical documentation describing standard processes which other developers must follow
** Other tasks as assigned
Education:
** Bachelor level in Computer Science or equivalent experience
Required Skills and Experience:
** Five or more years of hands-on experience with ETL Tools (such as Informatica or Oracle Warehouse Builder) in a fast-paced, technically-challenging data warehouse environment
** Excellent working knowledge of Oracle and SQL Server environments
** Solid Unix experience; file system navigation, file manipulation, and file transfer protocols
** Thorough understanding of data warehouse data models and concepts
** Excellent SQL and data analysis skills
** Mentoring or leadership experience
** Must have the ability to work independently and within a team
** Data architecture and relational database design
** Understanding of standard development life cycle processes
Beneficial Experience:
** Technical documentation
** Knowledge of banking and financial services
** Data partitioning and data archival processes
** Informatica installs and upgrades
** Data conversion
** Business intelligence reporting Travel required: none Telecommute: no
