Informatica Powercenter Developer

Tata Consultancy Services; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Tata Consultancy Services in Hyderabad, India, seeks an ETL/Data warehousing specialist. You will work with Informatica Power Center (Designer, Repository & Workflow Manager) to design and implement ETL processes, build complex SQL queries, and shell script data flows.

A strong grounding in DW concepts and experience with Oracle/SQL Server databases is essential. Desirable familiarity with Autosys, JIRA, and PowerExchange to manage schedules, issues, and data integration tasks within agile

Qualifications

• Experience in Informatica Power Center (Designer, Repository & Workflow Manager).
• Experience in building complex SQL queries & Shell Scripting.
• Excellent understanding of Oracle databases (Oracle/SQL Server).
• Strong DW fundamentals & concepts.
• Experience in ETL from sources like Flat Files, Database (Oracle, SQL Server), Mainframe files.

Skills

Informatica Power Center

Oracle

PL/SQL Scripting

Unix/Linux Scripting

Tools

Autosys

JIRA

PowerExchange

Job description

Required Technical Skill Set Informatica Power Center, Oracle, PL/SQL Scripting, Unix/Linux Scripting

Desired Competencies (Technical/Behavioral Competency)

Must-Have

• Experience in Informatica Power Center (Designer, Repository &Workflow Manager)
• Experience in building complex SQL queries & Shell Scripting
• Excellent understanding of various data base models Oracle/SQL server
• Strong on DW fundamentals & concepts
• Experience in extracting, transforming and loading data from different sources like Flat Files, Database (oracle, SQL server), Mainframe files.

Good-to-Have Knowledge on Autosys, JIRA, Power exchange and Agile methodology