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