Position: ETL Developer Location: West Bend, WI
Duration: 6+ months Interview Process: Phone & Skype Description : *ETL Developer* * **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 *InformaticaPowerCenter 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 developing commercial applications, with high standards of usability and performance · Experience with writing technical documentation · Experience in gathering and analyzing requirements · Strong analytical skills · Excellent written, verbal, and interpersonal skills -- *Thanks & Regards* *Rathna Kumar | Senior-IT Recruiter |* *Email: **rath...@usmsystems.com** , Phone:** **703-349-2660** * -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at http://groups.google.com/group/usitcv?hl=en. For more options, visit https://groups.google.com/groups/opt_out.