*Dear Partners,*
*IMMEDIATE Interview !!!!* *Send me the updated resumes to vis...@veritis.com <vis...@veritis.com> or you can reach me on 817-873-0015.* Locals are first preferred . please send 9+ years candidates who has Insurance experience only. *Sr. ETL Informatica Developer* *Duration: 6-7 months contract* *location : west bend ,WI* *Role Description* - The ETL Developer creates detailed specifications for ETL design / development / support, and then transforms those designs into system capabilities utilizing standard coding tools and processes. - The ETL Developer will function as part of a broader team that is responsible for developing the EDW solution, including Data Modelers and Data Analysts. - The ETL Developer ensures that development solutions meet defined technical, functional, and service level requirements and standards. - The ETL Developer oversees consistent quality in handoffs between development to deployment and operations while incorporating continuous process improvement and feedback. - The ETL Developer recognizes and identifies potential areas where existing development policies and procedures require change, or where new ones need to be developed. *Responsibilities * - Generates SQL DDLs and physical tables for the purpose of loading target data stores. - Develops ETL packages to extract, transform and load source to target stores - Performance-tunes ETL packages and target data stores based on expected use - Execute unit tests to ensure that the software compiles and runs - Reuses existing software components to meet requirements - Builds software components (including prototype code, new code, interfaces, etc.) in accordance with the relevant requirements, system and software architectures, design, and coding standards - Write and performs unit testing of software components and integration programs, including the design, implementation, evaluation, and execution of unit tests - Identifies and fixes coding defects - Understand and evaluate the relevant requirements, architecture, and design documentation - Analyze design specifications, development, and technical and user documentation and requirements surrounding the EDW technology components - Identify any potential issues and risk associated with specific development activities - Establish and maintain Software and Document CM policies, procedures and best practices *Required Skills & Qualifications * - Bachelor's degree in Computer Science/Technology related field - At least 5+ years experience total - Five years experience as an ETL Developer using Informatica PowerCenter 8.x and PowerExchange 8.x - Experience leading and developing medium to large scale Operational and Decision Support based Data Integration projects including Real-Time and Webservice based initiatives - Expert knowledge of SQL with relational databases (SQL Server, DB2) - Knowledge of Mainframe concepts including TSO, VSAM, COBOL and JCL - Experience with relational and dimensional data modeling - Knowledge of various Data Warehouse Architectures - Experience building and operating a data warehouse - Master Data Management experience - Metadata Management experience - Knowledge of Data Profiling and Data Quality concepts and techniques - Experience with Business Objects - P&C Insurance business domain experience - Strong attention to detail - Strong understanding of data analysis, development skills, and database structure - Experience with writing technical documentation - Experience in gathering and analyzing requirements - Strong analytical skills - Excellent written, verbal, and interpersonal skills -- You received this message because you are subscribed to the Google Groups "Oracle / Data Warehousing Developers / ETL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-data-warehousing-developers-etl+unsubscr...@googlegroups.com. To post to this group, send an email to oracle-data-warehousing-developers-etl@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-data-warehousing-developers-etl. For more options, visit https://groups.google.com/d/optout.
