ETL Developers


Posted Date: May 8 2017 12:56PM
MinExp: 5 Years
MaxExp: 7 Years
Location: Hyderabad

Key Skills : SSIS, SSRS, ETL, Teradata,

Job Description:

Job Description

· Build a Metadata-Driven ETL Platform in a by Extending Microsoft SSIS for Teradata platform.
· Design and develop the system components for the extract and transform or conversion of data from source systems to the target applications;
· Create data structures or data models that support data across all stages of the extract, transform and load process.
· Design and maintain supporting Slowly Changing Dimensions (SCD) using SSIS
· Design and build a Change Data Capture (CDC) solution using SSIS
· Maintain accurate records related to data lineage
· Reverse engineer data from various systems
· Develop default strategies for policing data quality
· Design data auditing subsystem
· Develop plan for maintaining dimension hierarchies
· Design detailed ETL plans for each table
· Set up initial job sequencing
· Unit testing ETL code to ensure it can be delivered and run in a system testing environment
· Document the ETL system specification. Develop new documentation, departmental technical procedures and user guides.
· Production Support

Basic Qualifications:

· Clear understanding of Data warehouse & ETL basic concepts of data flow, data enrichment, data consolidation, change data capture & transformation ,meta data management
· Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server, TSQL and Oracle PL/SQL
· Develop ETL scripts using SSIS and Teradata Parallel Transporter (TPT)
· 5+ years’ of practical experience in developing database ETL environments using SSIS for business intelligence applications
· Demonstrate strong knowledge of BI and data warehousing design principles and industry best practices.
· Basic knowledge of UNIX

oxcarbazepin impotenz oxcarbazepin generika oxcarbazepin apydan

Apply

company-post
company-post
company-post
company-post
company-post
company-post
company-post
company-post
company-post
company-post
company-post
company-post