Role : Informatica Consultant

 6 - 8 Year
 Bangalore NCR Mumbai Pune Chennai Hyderabad

Job Description

Responsibilities
• Design, implement, and continuously expand data pipelines by performing extraction,
transformation, and loading activities
• Outline the ETL process, setting the borders of data processing & provide system architecture for
each element and the whole data pipeline
• Gather requirements and business process knowledge to transform the data in a way that’s geared
towards the needs of end users
• Maintain and improve already existing processes
• Ensure that the data architecture is scalable and maintainable
• Work with the business in designing and delivering correct, high quality data
• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose
adequate solutions
• Conduct testing of the tools and data pipelines
• Document the requirements of the system and manage its development

Skills
• Bachelor’s degree in computer science, information technology, or a related field
• Should have at least 6 years of experience in designing data models for Data Warehouse, building
data integrations using Informatica and scheduling the jobs using Control-M
• Primary skill is Informatica PowerCenter, Oracle APEX, Oracle DB, SQL, Control-M
• Basic knowledge on Informatica cloud, Snowflake and exposure to Python is an advantage
• Strong SQL knowledge and should be able to understand, write & optimize complex SQL Queries
• Should have knowledge on Shell Scripting & TibCo Composite.
• Should take ownership & handle multiple project tasks.
• Should be able to understand the functionality of the projects and communicate with multiple
Business partners/ teams to fix an issue
• Should provide technical solution based on the business needs.
• Knowledge on Python will be preferred
• High attention to detail
• Passionate about complex data structures and problem solving
• Ability to pick up new data tools and concepts quickly


Required Technology Skills:
• Informatica PowerCenter
• Oracle DB
• Control-M
• SQL
• Unix/Linux
• Python

Salary :   Not Disclosed by Recruiter

Industry :   IT Software - Other

Functional Area :   IT Software- Application Programming / Maintenance

Role Category :   Computer/IT

Employment Type :   Full-Time

Education / Qualification :   BE/M.Tech/B.Com/MBA/MCA/BCA

Key Skills

Informatica Developer  SQL