Job Description

• The ETL developer will be responsible for analyzing the business requirements, design, develop and implement highly efficient, highly scalable ETL processes. Candidate is required to perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment.
• 4+years of experience as ETL Lead / Analyst in Banking Domain
• Thorough understanding of DWH and BI Dashboard Reporting concepts
• Understanding of Data Models: Conceptual, Logical, and Physical & Dimensional/Relational Data Model Design.
• Develop detailed ETL specifications based on business requirements
• Analyze functional specifications and assist in designing potential technical solutions
• Identifies data sources and works with source system team and data analyst to define data extraction methodologies
• Proficient in ETL Informatica
• Defines, develops, documents and maintains Informatica ETL mappings and need to be well versed in Unix shell scripting
• Good knowledge in writing complex queries in Oracle PL/SQL
• Unit/Integration testing activities and assist in User Acceptance Testing
• Maintain batch processing jobs and respond to critical production issues
• communicate well with stakeholders on his/her proposal/recommendations Knowledge, status/risks regarding delivering solution on time
• Data Analysis, Data Profiling, Root Cause Analysis,
• Source to Target Mapping
• Should able to understand Data Warehouse architecture and code
• Should able to understand Banking system/processes and data flow.

Required Skills

• Bachelor’s degree from an accredited college/university in programming related field with significant course work and/or experience in design, development, and analysis of technology solutions and three years of experience, or equivalent combination of education, training, and experience.
• Proficiency in applying new technologies to existing applications and the development of new solutions with programming languages and technologies such as SAP Bods ETL, Guidewire, SQL, C#, Java and in MS Office products including Word and Excel.
• Ability to think logically and to continually use personal judgment, experience, and known facts and figures, to make decisions and deal with problems.
• Demonstrates knowledge of hardware and software technology. Maintains up-to-date knowledge through the reading of technical publications, attendance at seminars/conferences and/or user groups. Shares information with others in a manner that is easily understood and applied.
• Ability to manage multiple and/or conflicting priorities including ability to be flexible and adjust priorities as business needs change. Project deadlines may conflict, making it necessary to negotiate and communicate with stakeholders.
• Ability to work with a project team to determine technology needs and recommend solutions resulting from team decision. As part of recommendation, includes estimated timelines and projected deadlines.
• Working knowledge of systems development lifecycles and understanding of IT infrastructure, the impact of changes on system beyond scope, and the importance of coordinating updates or fixes. Ability to follow project management methodology specific to Grinnell Mutual.
• Ability to work with mathematical concepts such as probability and statistical inference and applying concepts such a, fractions, percentages, ratios, and proportions to practical situations as required for programming to simplify work of end user.
• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract/concrete variables.
• Ability to recognize processing/application inefficiencies and recommend improvements.
• Demonstrates enthusiasm and commitment toward assignments and problem solving.
• Demonstrates oral, written, and presentation skills to both technical and non-technical audiences. Exhibits self-assurance and a creative aptitude.
• Ability to work in a harmonious manner with coworkers, agents, vendors, and supervisor.
• Ability to understand basic insurance terminology applicable to personal lines and commercial lines of insurance.
• Experience with Guidewire is a plus.
• Ability to work with minimum supervision.