Send me more jobs like this

Informatica Lead

Keywords / Skills : Informatica Lead

8 - 11 years
Posted: 2019-01-02

IT/ Computers - Software
Team Leader/ Technical Leader
Posted On
2nd Jan 2019
Job Ref code
Job Description

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%:
  • Requirements Interpretation
  • 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

Preferred Skill Set:
  • Desired ETL Technology: Informatica PowerCenter
  • Desired Database Technology: SQL Server, Sybase IQ, Oracle & Netezza
  • Understanding of Data Warehouse like Star Schema, Snow Flake, Dimensions, Facts, OLTP, OLAP
  • Good to have knowledge in Windows Power Shell Scripting or batch scripting

Key Skill(s)

Similar Jobs
View All Similar Jobs
Walkin for you