Search Jobs

ETL Lead - Informatica / Hadoop

This requirement is valid till 24-07-2019

Required Skills:

Location:  Kochi
Domain:  Insurance
Qualification:  Any Degree
Experience:  3-5 yrs.
Job Description with Roles & Responsibilities: 
  • Informatica Expert
  • SQL - Oracle Hands on.
  • Unix basics with Shell Script Experience
  • ETL Migration from other tools to Informatica is good to have
  • Good to have basic Talend
  • Candidate must have 5+ years of experience as ETL developer
  • Should have good experience in Data Warehousing and ETL Development using Informatica Power center
  • Should be responsible for the creation of automated BI solutions, including requirements, design , development, testing and deployment
  • Must have strong skills in Data Analysis, Data Requirement analysis and Data Mapping for ETL processes.
  • Should have good knowledge in developing complex SQL queries
  • Must have experience in database programming in PL/SQL
  • Should contribute to the entire implementation process including driving the definition of improvements based on business need and architectural improvements
  • Should meet with business partners to understand business needs
  • Must be responsible for overall design of the solution Must design, build and test applications
  • Must conduct root analysis and advanced performance tuning for complex business processes and functionality
  • Should possess excellent communication skills

     This position is responsible for developing and implementing ETL using Informatica IICS/ICS application, code migration to higher environments, Error handling and recovery techniques.

    - Standardizing the ETL framework with the best practices suggested by IICS/ICS.

    Essential Functional & Responsibilities :

    - Responsible for building and maintaining applications with technologies such as Informatica cloud and redshift.

    - Collaborate with developers, project managers, business system analysts and business users in conceptualizing, estimating and developing ETL framework.

    - Develop technical documentation to define the system components, development environment, and implementation

    - Prepare and dispense work assignments, provide guidance, and/or review the work of other team members.

    - Collaborate with the QA team to define test cases, metrics, and resolve questions about test results.

    - Develops and implements solutions in accordance with policies and procedures.

    - Analyze user requests and assist with the design from a support perspective.

    - Update/create Knowledge Base Articles and case studies as necessary.

    - Assist in the creation and improvement of Knowledge Management.

    Required Skills :

    - Should have 2-4 yrs of experience in ETL/DWH developing, integrating using Informatica.

    - Should be proficient in using Informatica power center 8 x & 9 x versions.

    - Should be expert in understanding about backend process of Informatica PowerCenter.

    - Should be proficient in using PL/SQL and SQL.

    - Ability to work on UNIX/Linux platform.

    - Should be experienced in all phases of SDLC.

    - Good to have knowledge on Informatica cloud (ICRT & ICS)

    - Being an individual contributor towards the project and expecting to lead a small team of 5-10 people.

    - Experience in Agile methodology.

    - Participate in daily sprint discussions and provide updates. Work on collaboration tools such as Jira to reflect development progress.


Login to Apply