Position

Senior Developer Informatica,
Bangalore

Location


Bangalore

Office Address


Project Description


Customer is one of the leading insurance company. The Company through, its subsidiaries, provides life insurance, retirement, and employee benefits. As part of this project team need to work on redesigning couple analytics applications.

Responsibilities


    Job Description: Data Modeller
    Position 1: 8-11+ years’ experience in Primary technical skill

    Primary Technical Skills:- Exp in Data Modelling is a must. Experience in any one Data Modelling tool like Erwin or ER Studio. Strong SQL experience using SQL server (Window functions, Analytical functions, Performance tuning, Recursive query building etc).
    Responsibility
     Analyzing the business requirements, design, develop and implement highly efficient, highly scalable Data models
     Required to perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment
     Thorough understanding of DWH concepts and Data Models
     Design and Develop detailed ETL specifications based on business requirements
     Analyze functional specifications and assist in designing potential technical solutions
     Works with source system team and data analyst to define data extraction methodologies
     Advanced Oracle & SQL Server database skills including PL/SQL, packages, procedures, indexing and query tuning (5+ years)
     Enhance/Re-architect existing components to satisfy new performance and scalability requirements
     Regular meeting with team and stakeholders to avoid impediments
     Innovative ideas on automation and Proof Of concepts to get it implemented
     Proficient in ETL Informatica
     Well versed in Unix shell scripting
     Interact with multiple teams and translate reported problems/issues into JIRA items to implement to meet enterprise standards.
     Good knowledge in writing complex queries. Experience in MS SQL is value added
     Maintain highest levels of software quality and stability through continuous improvement of the SDLC
     Build and maintain design standards and best practices and ensure the team adhere these standards
     Evaluates and recommends unique hardware /software configurations; defines special hardware/software requirements, capacities, capabilities, etc. to meet user needs while adhering to technical standards
     Unit Integration testing activities and assist in User Acceptance Testing
     Effective time management skills in order to manage multiple priorities with flexibility on time zones and timelines
     Must have strong interpersonal skills and outstanding communication skill

Skills


Must have

    Exp in Data Modelling is a must. Experience in any one Data Modelling tool like Erwin or ER Studio. Strong SQL experience using SQL server (Window functions, Analytical functions, Performance tuning, Recursive query building etc).
    Responsibility

Nice to have

    Experience in Insurance domain and knowledge in Reporting tool like Business Object, Tableau etc..

Languages


English: C1 Advanced

Seniority


Senior

Relocation package


If needed, we can help you with relocation process. Click here for more information.

Work Type


BigData (Hadoop etc.)

Ref Number


VR-60580

More job opportunities in
BigData (Hadoop etc.)

Specialization Position / Title Location Seniority Send to a friend
BigData (Hadoop etc.) Senior Data Modeller Bangalore, IN Senior
BigData (Hadoop etc.) Azure Databricks Application Developer Bangalore, IN Regular
BigData (Hadoop etc.) Application Developer - Microsoft Azure BI Stack Bangalore, IN Senior
BigData (Hadoop etc.) Application Developer - Microsoft Azure BI Stack Bangalore, IN Regular