$100,000–$125,000 Per Year
Acceptance Testing, Analysis Skills, Apache Hadoop, Atlassian JIRA, Automation, Cloud Computing, Data Modeling, Database Extract Transform and Load (ETL), Debugging Skills, File Management, Identify Issues, Informatica, Legal, Linux Operating System, Loan Funding, Microsoft SQL Server, NCR Teradata, Operations Processes, Oracle, Oracle PL-SQL, Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Product Management, Production Control, Production Systems, Python Programming/Scripting Language, Query Optimization, Relational Databases (RDBMS), Reporting Skills, SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Service Level Agreement (SLA), ServiceNow, Software Administration, Splunk, Student Loans, System Operations, Systems Maintenance, Unix Operating Systems, Unix Shell Programming
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