Home > Uncategorized > ETL Developer

ETL Developer

Adding to the job description.

Functional 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.

Requirements:

  • 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.

Essential Qualifications:

  • 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.

Additional items:

  • Familiarity with the Kimball Methods of Data Warehousing techniques and standards.
  • Successfully created
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: