Informatica Lead With Netezza Exp

http://fossilace.com/company/tech-mahindra-ltd

To Apply for this job click below

Apply Now
Electronics City , Bangalore, India
Job Detail
  • Industry:
    IT - Software
  • Total Positions:
    1
  • Job Type:
    Full Time
  • Salary:
    100000-120000
  • Job Location:
    BANGALORE, India
  • Minimum Education:
    BE/BTech
  • Minimum Experience:
    8 Years
  • Apply By:
    Sep 09, 2018
  • Job Posting Date:
    May 09, 2018
Job Description

Design, Develop and Provide support in all aspects of data movement for a data warehouse environment residing on Netezza, with emphasis on the Extract-Transform-Load (ETL) process using Informatica.

Proficient in Netezza 7.0.4
Proficient on all Informatica 9.x Platform tools (Power Exchange, Power Center, Informatica Cloud)
Knowledge of Web Service integration through Informatica is desirable
Knowledge of Informatica Cloud Real Time(ICRT) is desirable
Ability to administer ETL system and upgrade to new releases
Develop data warehouse process models, including sourcing, extracting, transforming and loading as per business requirements.
Design Extract-Transform-Load (ETL) Workflows for data migration from various sources to data warehouse using batch or incremental loading strategies.
Document database design including data modeling, metadata and business process flow for the new business integration requirements.
Create data model and reverse engineer data warehouse using CASE tools like ER Studio.
Create test plans and scripts for data warehouse testing, ranging from unit to integration testing.
Ensure delivered Data warehouse code is running and conforms to specifications and design guidelines.
Create Informatica mappings, transformations, stored procedures and functions to implement the data process flow defined by the business rules.
Document technical ETL specifications for data warehouse. Perform periodic code reviews and test plans to ensure data quality and integrity.
Navigate on the host server for file management, file cleanup and configuration tasks. Maintain Informatica on UNIX and Windows environments. Write Shell scripts, PL/SQL scripts and SQL scripts
Prior Experience in Upgrading Informatica Power Center versions.
Excellent communication skills with knowledge of ETL field, tools and technologies, implementations and solutions, as well as specific experience with the Informatica ETL tool
Excellent motivational skills required to ensure good team synergy and collaboration of cross functional teams. A strong facilitation and positive attitude will be mandatory.
Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning, and High Volume Data Loads
Excellent ability to multi-task. ? Demonstrated proficiency with a database SQL language for user-defined database extracts or updates statements.
Proficient use of CASE tools (Embarcadero ER Studio preferred)

Skills Required

To Apply for this job click below

Apply Now
 

Note: Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi a velit sed risus pulvinar faucibus. Nulla facilisi. Nullam vehicula nec ligula eu vulputate. Nunc id ultrices mi, ac tristique lectus. Suspendisse porta ultrices ultricies."

Report this Employer

 
 
Fossilace

Fossilace is a platform for job opportunities across verticals , across geographies and across experience levels .We offer HR and Recruitment Solutions besides training , employability solutions and also assist with our partners in providing accounting , payroll and start-up solutions. We work with a broad range of clients, from early-stage start-ups to large global organizations as well as highly respected Indian corporations in the Technology, Knowledge Services, Banking and Financial Services sectors in India. We are dynamically organized to provide qualitative and customized solutions according to the clients needs and requirement across this spectrum of clientele.