Adding to the job description.
The extraction, transformation, and load (ETL) developer creates jobs moving data from system to system. Source and target data often will be stored in enterprise-class databases, such as SQL Server, but also include file-based items. Jobs created by the ETL developer will undergo a QA and DBA evaluation prior to moving to production. The ETL developer will be responsible for scheduling, monitoring, and responding to issues resulting from the ETL job execution. Corporate reporting and security standards must be followed. The ETL developer also will be responsible for generating data quality metrics and overall summaries of target data statistics, including their publication to metadata consumers.
ETL developer will assist in SSIS package creation, SQL script creation, stored procedure development, and report development, in support of decision support analysts. Other non-central, but import tasks include Dimension Modeling within Star schema, working with the DBA team, and general data maintenance, reporting, and database-oriented tasks.
- ETL job scheduling using SQL Server 2005 Agent.
- Creation of data flows into different targets based on quality and consistency metrics.
- SQL coding with SQL Server Management Studio.
- Creation of T-SQL stored procedures.
- Creation of reports using SQL Server 2005 Reporting Services.
- Creation of consistent documentation for all development efforts.
- Facilitate database object code promotion using source control and communication with the DBA team.
- Work with business users to develop requirements for information delivery requirements.
- Work with outside vendors to manage import and export of proprietary information in a secure manner.
- Evaluate products to support IT and Decision Support missions.
- Accomplish all tasks while meeting information security requirements.
- Minimum of five years of general ETL experience using industry-standard tools (e.g., Informatica, DataStage, SQL Server Integration Services).
- Minimum of two years of ETL development experience using SQL Server 2005 Integration Services.
- Minimum of one year of experience using .NET programming (can be based on CLR-based development in SQL Server).
- Demonstrable experience in enterprise application integration planning and execution.
- Demonstrable experience of defining and meeting data quality parameters.
- Intimate familiarity with database concepts, including normalization, indexing, physical and logical modeling.
- Intimate familiarity data warehousing concepts, designs, and industry-standard practices.
- Familiarity with project management controls and techniques.
- Familiarity with the Kimball Methods of Data Warehousing techniques and standards.
- Successfully created