Greetings from TCS!!!

TCS is currently hiring for the position of Informatica Developer.

Desired Experience - 6-10 Yrs

Location of Requirement - Bangalore / Chennai / Hyderabad / Mumbai / Indore / Ahmedabad

Essential Duties and Responsibilities

Leads the tuning of ETL processes
Leads the tuning of databases
Responsible for timely project deliveries
Leads in writing and reviewing software functional specifications and design reviews
Provides guidance to more junior staff
Provides input to continuously improve ETL process discipline and resulting output quality
Participates in writing and reviewing software functional specifications and design reviews
Collaborates with development teams, business units to identify, define, develop and implement new data source feeds
Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks
Assists with tuning of ETL processes and database performance
Design and develop any/all necessary ETL processes
Responsible for loading and validating data into the data warehouse
Provides support for technical issues and ensuring system availability
Remains current on Data Warehousing technologies, testing industry trends and best practices
Ownership of projects and responsible for deliverables

Required skills and abilities

Ability to translate business requirements into technical solutions
Self-starter with "can-do" attitude, a must in a fast-paced business and technical environment
Professional oral and written communication skills with the ability to communicate regularly and effectively with other team members.
Strong interpersonal and relationship building skills, conducive to team development, work under own initiative.
Ability to prioritize tasks and work concurrently on multiple tasks.
Project management experiences a plus.
Ability to work well independently and in a team environment

Education and/or Experience:

6 years of experience in software development utilizing Informatica in combination with Oracle databases in a distribution system environment is preferred.
Complete understanding of all phases of the software development life cycle.
Expert Knowledge of application design principles, systems development and analysis.
Expert UNIX/LINUX and Oracle 12c experience
Complete understanding of relational database design and architecture

Informatica

Advanced Informatica design and development skills using Informatica power center. (10.1+ preferred)
Experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager
Experience using parameter files, parameters/variables and troubleshooting using advanced informatica techniques like session partitioning, push down optimization etc.

Unix (Sun Solaris or Linux)

3+ years of experience writing shell scripts.
Expertise in running jobs using various schedulers.
Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files.

Must Have

Informatica Developer