Sr. ETL Developer

Required Skills:SQL, ETL, Informatica, PowerExchange, XML, Security Experience - Sensitive DataRole 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 storesPerformance-tunes ETL packages and target data stores based on expected useExecute unit tests to ensure that the software compiles and runsReuses existing software components to meet requirementsBuilds software components (including prototype code, new code, interfaces, etc.) in accordance with the relevant requirements, system and software architectures, design, and coding standardsWrite and performs unit testing of software components and integration programs, including the design, implementation, evaluation, and execution of unit testsIdentifies and fixes coding defectsUnderstand and evaluate the relevant requirements, architecture, and design documentationAnalyze design specifications, development, and technical and user documentation and requirements surrounding the EDW technology componentsIdentify any potential issues and risk associated with specific development activitiesEstablish and maintain Software and Document CM policies, procedures and best practicesRequired Skills Qualifications:Bachelor's degree in Computer Science/Technology related fieldAt least 5+ years experience totalFive years experience as an ETL Developer using Informatica PowerCenter 8.x and PowerExchange 8.xExperience leading and developing medium to large scale Operational and Decision Support based Data Integration projects including Real-Time and Webservice based initiativesExpert knowledge of SQL with relational databases (SQL Server, DB2)Knowledge of Mainframe concepts including TSO, VSAM, COBOL and JCLExperience with relational and dimensional data modelingKnowledge of various Data Warehouse ArchitecturesExperience building and operating a data warehouseKnowledge of Data Profiling and Data Quality concepts and techniquesExperience with Business ObjectsP C Insurance business domain experienceStrong attention to detailStrong understanding of data analysis, development skills, and database structureExperience with developing commercial applications, with high standards of usability and performanceExperience with writing technical documentationExperience in gathering and analyzing requirementsStrong analytical skillsExcellent written, verbal, and interpersonal skills

#J-18808-Ljbffr