Hi*,* I hope you are doing great.
Please find the below our *direct client requirement* and please send me your consultants resume to *p...@aptude.com <p...@aptude.com>* *Job Title: Senior ETL Developer (**PowerCenter and PowerExchange**)* *Location: West Bend, WI * *Duration: 6-12 Months* *Must have 10 Years experienceDon't send H1B Transfer resumes, submit your own W2 consultants only* 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 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,* *Prasad Rao* Phone: 630-883-4515 Ext:402 -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to arunsinh+unsubscr...@googlegroups.com. To post to this group, send email to arunsinh@googlegroups.com. Visit this group at http://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.