Job Description :
Job Description :

The ETL Developer creates detailed specifications for ETL design/development/support, and then transforms those designs into system capabilities utilizing standard coding tools.

Function as part of a broader team that is responsible and processes for developing the EDW solution, including Data Modelers and Data Ensures that development solutions meet defined technical Analysts Oversees, functional, and service level requirements and standards.

Consistent quality in handoffs between development to deployment and operations while incorporating continuous process improvement and Recognizes and identifies potential areas where existing feedback.

Development policies and procedures require change, or where new ones Generates SQL DDLs and physical tables for the need to be developed.

Develops ETL packages to purpose of loading target data stores.

Performance-tunes extract, transform and load source to target stores

Execute unit ETL packages and target data stores based on expected use

Analyze design tests to ensure that the software compiles and runs specifications, development, and technical and user documentation and Identify any requirements surrounding the EDW technology components potential issues and risk associated with specific development

Establish and maintain Software and Document CM policies, activities

Reuses existing software components to procedures and best practices

Builds software components (including prototype meet requirements code, new code, interfaces, etc in accordance with the relevant requirements, system and software architectures, design, and coding

Write and performs unit testing of software components and standards integration programs, including the design, implementation, evaluation, Identifies and fixes coding defects and execution of unit tests

Understand and evaluate the relevant requirements, architecture

Bachelor''s degree or equivalent design documentation

Qualifications:

Five or more years of combination of education and experience as an ETL Developer using Informatica PowerCenter 8.x

Strong understanding of data analysis, development Power Exchange 8.x

Experience with developing commercial, skills, and database structure applications with high standards of usability and performance

Experience with writing technical documentation

Strong analytical skills gathering and analyzing requirements

Excellent written, verbal, and interpersonal skills and developing medium to large scale Operational and Decision Support based Data Integration projects including Real-Time and Webservice based

Expert knowledge of SQL with relational databases

Knowledge of Mainframe concepts including TSO, VSAM, Server, DB2

Experience with relational and dimensional data modeling

Experience with COBOL and JCL

Knowledge of various Data Warehouse Architectures

Master Data Management building and operating a data warehouse

Knowledge of Data, Metadata Management experience

Experience with Profiling and Data Quality concepts and techniques Business Objects
             

Similar Jobs you may be interested in ..