ETL/Informatica Sr Developer

Desired Competencies (Technical/Behavioral Competency )

Must-Have**

(Ideally should not be more than 3-5)

5+ Years Strong hands-on experience with Informatica PowerCenter , including development, debugging, and performance tuning. 

Write Complex SQL queries on multiple tables using complex joins

ETL tools like Informatica, Data stage, any other cloud tools.

SN

Responsibility of / Expectations from the Role

1

Design and implement ETL solutions using Informatica PowerCenter, and other relevant ETL tools. 

2

Develop high-level and low-level design documents for ETL processes. 

3

Collaborate with business analysts and other stakeholders to gather requirements and translate them into technical solutions

4

Develop, modify, configure, and debug Informatica workflows and mappings.

5

Creating end goals for their team.

Details For Candidate Briefing**

(It should NOT contain any confidential information or references)

About Client:

(Please highlight domain, any ranking indicating size of /recognition for the client. It helps sell the role to prospective candidates)

for USA/UK based multinational Media and Information company, having revenue more than 5 billion with 26000 employees around the world. 

USP of the Role and Project:

(Why a candidate would be keen to apply for this role in this project – “what there for me?”. Please highlight the USP of the role in terms of nature of the project, technology involved, growth prospect, onsite opportunity, opportunity for learning and certifications etc. It helps sell the role to prospective candidates)

This position is for the Informatica Lead.

As Informatica Sr Develoer responsible for leading the design, development, and implementation of Informatica-based solutions, often within a broader data integration or ETL (Extract, Transform, Load) context. They guide teams, ensure quality, and optimize performance of Informatica workflows and mappings.

Market Intelligence   Vendor Approval**

Please specify companies that are competition for TCS for this particular project / any other companies where these skills would be available.

In the past, many associates with similar skill may have joined us through external hiring and still continuing in the project. Would like to know details of such associates (name, emp number). This shall help us to focus on target companies better

Please specify if project is open to share the requirements with vendors (Y/N)**