IT - ETL Developer
Company: Cincinnati Financial Corporation
Posted on: December 28, 2018
The Cincinnati Insurance Companies' IT department is currently seeking a developer to analyze, design, code, test and deploy software programs and applications. This includes researching, designing, documenting and modifying software specifications throughout the production lifecycle. Starting Range of Salary: Responsibilities* develop detailed system designs and review approved system designs with project team* develop program logic and review programs that require modification* provide production support, including on-call rotation and technical assistance to end-user and IT staff* review schedules, objectives and priorities with service manager* initiate suggestions for improvement to systems and procedures* assist with routine work of the department as required* create, extract, transform and load processes and programs in appropriate environments* create source to target maps and transformation rules for Data Mart creation* collect appropriate metadata and document procedures* create reconciliation procedures and data checks to ensure data quality* handle the design, development and application of best practices and documentation of ETL processes* perform audit balancing and controls Desired Skills:* effectively troubleshoot, debug and problem solve complex issues* effective verbal and written communication skills* experience in an ETL tool across multiple platforms* understanding of data warehouse concepts, including star schemas* proficient in SQL* able to mentor less experienced associates* strong analytical and organizational skills* able to multitask and effectively perform multiple assignments* preparation of technical specification documentation* conducting requirements analysis, schema design, database object creation, testing, and maintenance* ability to demonstrate leadership qualities. Ideal candidates have:* two or more years of ETL development experience; Data Stage is preferred, but Informatica experience will also be considered* experience with multi-platform environments and languages, including OS/390, Windows Server, AIX, UNIX, Linux and Korn Shell scripting* experience with DB2 UDB and Utilities* experience in multidimensional data modeling, such as star schemas, snowflakes, normalized and de-normalized models, handling slow-changing dimensions/attributes* experience designing and developing exception handling, data standardization procedures and quality assurance controls* experience implementing and refining required business transformation rules and logic* experience analyzing source systems for data profiling and creation of source to target mapping specs* IBM Information Server (DataStage)* progressive experience in conceptual, logical, physical data modeling; design, development and delivery of data centric IT solutions, including relational databases, data warehouses, ETL/ELT processes and reporting applications within the financial industry* insurance experience preferred* OLAP and reporting tool technologies such as SSRS Education Ideal candidates would have a bachelor's degree or equivalent experience in computer science or related discipline. The Cincinnati Insurance Company, a subsidiary of Cincinnati Financial Corporation, stands among the nation's top 25 property casualty insurer groups, based on net written premiums, and has earned an A rating from A.M. Best. Our commitment to the independent agency system began in 1950 and is our company's core strength and competitive advantage. We excel by offering agents and policyholders a local presence, unparalleled claims service, loss control consultation services, work-saving technology initiatives, and competitive products, rates and compensation. Selected associates receive a comprehensive salary and benefits package, including a matching 401(k). Equal Opportunity Employer. Best's ratings are under continuous review and subject to change and/or affirmation. To confirm the current rating, please visit www.ambest.com.
Keywords: Cincinnati Financial Corporation, Fairfield , IT - ETL Developer, IT / Software / Systems , Fairfield, Ohio
Didn't find what you're looking for? Search again!