Informatica Developer

Job description

**Job title:** **Informatica Power Center** **Developer** **Experience Range: 4-10 Years** **Location: Pan India - Preferably: Hyderabad, Bangalore, Gurgaon or All Locations** **Virtual Interview : 9th April (Thursday)** **Timing : 10 am - 4pm** Job Description: Required Skill Set: **Informatica Power Exchange, Power Center** **Must-Have\\*\\*** **(Ideally** **should not be more than 3-5)** **3 to 6 years of experience in Production Support activities on ETL Informatica** **Informatica** **Power Exchange, Power Center, Oracle, SQL, PL/SQL.** **SKILLS AND COMPETENCIES** **• Strong hands-on experience with Informatica PowerCenter (mappings, workflows, sessions, scheduling, troubleshooting).** **• Experience with Informatica** **PowerExchange** **(CDC concepts, extraction configurations, integration into ETL workflows).** **• Strong experience with Oracle database and advanced SQL.** **• Strong PL/SQL development and performance tuning experience.** **• Solid understanding of ETL concepts: joins, lookups, aggregations, incremental loads, SCD, data-quality controls.** **• Experience working** **in** **Agile/Scrum projects using tools such as Jira/Confluence.** **• Strong analytical and problem-solving skills;** **good communication** **and collaboration** **Good-to-Have** **Snowflake or cloud data platform exposure** **• Python/Shell scripting for automation and comparisons** **• Experience with data governance/MDM/reference data concepts** **• Exposure to CI/CD for ETL deployments and monitoring/log tools (Splunk/ELK)** **• Experience with monitoring/logging tools (Splunk/ELK, cloud monitoring).** **SN** **Responsibility of / Expectations from the Role** **1** **Design and develop ETL mappings, workflows, and sessions using Informatica PowerCenter, following development standards and best practices.** 2 - **Implement ingestion patterns using Informatica** **PowerExchange** **(CDC/real-time or near real-time extraction where applicable) and integrate with downstream ETL flows.** **3** - **Build and optimize complex Oracle SQL and PL/SQL (procedures, functions, packages) to support transformations, validations, and data reconciliation.** **4** - **Implement ETL controls: parameterization, restart/recovery, error handling, logging, audit columns, and incremental load strategies.** **HR - Talent Acquisition Group** **Let's connect on Linkedln: linkedin.com/in/mahalaxmi-g-46a391245** **For Opportunities visit: https://ibegin.tcs.com/iBegin** **Website: www.tcs.com**