Must Have Technical/Functional Skills
Primary Skill: Informatica Developer
Secondary: Informatica, IDMC, Hadoop and Oracle
Experience: Minimum 10 years
Roles & Responsibilities
Development Responsibilities
โข ETL Pipeline Development: Design, build, and deploy robust ETL mappings, sessions, and workflows utilizing informatica PowerCenter and Informatica Cloud.
โข Data Integration & Modeling: Develop and optimize complex SQL queries and PL/SQL scripts. Work with relational databases like Oracle, Teradata, or SQL Server to ingest and integrate data.
โข Performance Tuning: Troubleshoot and resolve data bottlenecks; tune SQL queries and Informatica mappings for optimal performance and high-volume data ingestion.
Manage Prod RESPONSIBILITIES
โข Monitor production environments, respond to alerts, and resolve technical issues, including tracking incidents against SLAs and preventing recurring issues through RCA.
โข Debug Informatica, Spark, Oracle and Shell scripting code, analyze logs, and troubleshoot hardware/software issues.
โข Maintain, document, and update system operating procedures, and provide performance reports.
โข Assist with code deployments and migrations through environment stacks (Dev, SIT, UAT, Prod).
โข Proficiency in Unix/Linux commands, SQL for database querying, performance tuning and scripting languages (e.g., Python, Shell) for automation.
โข Experience with monitoring tools (e.g., Splunk, Datadog), ticketing systems (e.g., Jira, ServiceNow), and cloud platforms.
โข Configuring session objects, optimizing Spark engines, and managing file descriptors for high-volume data ingestion.
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $100,000-$125,000 a year