ETL Developer

Job Description

Responsibilities:

• Along with other key personnel, ensure the overall data integrity and conformity of the information gathered. Manage data quality tasks through the ETL processes.
• Work with Development Teams, and Business Analyst to identify and understand source data systems, as well as provide input for enhancements for standardization and consistency across the Enterprise (Transactional systems, Data Warehouse, etc.)
• Map Import/Export Files to source system data. Map source data to data warehouse models and document the Data lineage for all the built mappings
• Design, develop and test extraction, transformation, and load (ETL) processes.
• Develop and maintain ETL scripts and workflows, SQL queries, VB/C++ script components, schedules, etc. using VSS for version control.
• Define and capture metadata and rules associated with ETL processes.
• Develop processes to identify and analyze data quality issues and recommendations to resolve.
• Document, including diagrams, the architecture and components of the Reporting data warehouse.
• Use SQL Server query techniques and available tools, against the transaction system and the reporting data warehouse, to identify and analyze data quality issues.
• Review ETL Jobs to ensure they are operating at optimal performance levels
• Review, understand, and provide feedback on functional requirements from a database perspective
• Performs performance tuning of queries and stored procedures.

Requirements:

• Experienced in logical and physical database design for Data warehouse
• Has 4 years+ experience in Microsoft SSIS, SSRS & Database/Data warehouse Development
• Is an expert in the creation of SQL ,Stored procedures & Triggers, SQL server agent jobs and performance tuning of the existing SQL code in stored procedures
• Full understanding of Extract Transform Load (ETL) concepts and technologies