Informatica Lead/ Architect Job Description: Experienced in the use of Informatica PowerCenter and architects/ develops Extract Transform and Load (ETL) Mappings. The requirement is to design and develop the Informatica mappings required to move identified source system data into target Systems. Primary Job Duties: Informatica Lead/ Architect 80%:
Write technical specifications to be given to Informatica ETL developers
Support the ETL project developers to produce ETL code and projects as required.
Use of Informatica Standards
Ensure quality of solutions by establishing strict code quality processes (design standards, code review)
Implement data integration best practices and conventions.
Performance Tuning and Partitioning
Troubleshoot and can dig in and identify the translation issues as data is transferred from source to target
Responsible for deployment
Help with data architecture, data warehousing and data mart modelling
Help deploy application to UAT and production environments, and handle bug-fixes and implement possible system redesigns during these periods.
Consult with users, management, and technical personnel to clarify and validate business requirements.
Identify potential issues and proactively suggest changes and solutions.
Act as a reference for data integration and reporting solution.
Perform detailed data analysis to understand the source system data.
Work closely with database administration team and ensure the database is architect and designed to handle concurrent ETL and reporting query jobs.
Team Mentor 20%
Provide assistance to team members with issues needing technical expertise or complex systems and/ or programming knowledge
Required Skill Set:
8+ years of experience delivering ETL solutions
8+ years of Informatica Power Center tool experience
8+ years of experience with OLTP and OLAP database models
Good analytical and problem-solving skills
Fluent in relational database concepts and flat file processing concepts
Must be knowledgeable in software development life cycle /methodologies i.e. agile
Has strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentation
Strong problem solving, time management and organizational skills
Job Description :
To ensure customer service and support all operations. To create customer delight at every interaction.
Interacting with external customers and internal customers and addressing their queries, requests and complaints.
Committed TATs are met consistently
Complaints Management- addressing customer complaints at the branch, system updation, coordination with Sales/HUB/ other functions for resolution.
Refunds processing and dispatch
Undelivered policy documents tracking and management.
Maintenance of all files and registers.
New Business Processing:-
Handling end to end New business processing starting from creation of Client id,Case start up, New business login, Follow up for policy issuance, Quality Check
Follow up with HUB for policy issuance of pending cases