Informatica ETL Developer

Responsibilities Job Description

• Support technical delivery through coding, development, and testing;
• Understanding of automated processes for building, testing (integration, SIT & UAT Support), documenting, and deploying at scale;
• Translate user requirements into the overall architecture framework and implementation of new systems;
• Create test code to validate the application against client requirement;
• Understand, create and debug database related queries;
• Ensure complete technical documentation exists for all projects and processes;
• Maintain successful relationships with application developers;
• Performance Optimization;
• Develop informatica mappings, debugging using queries on source and targets;
• Successful resolution of production issues.

Requirements

• Bachelor’s Degree in Computer Science, Computer Engineering or a closely related field;
• Strong knowledge of SQL, Relational Database Management Systems like Oracle, DB2 and SQL Server;
• Experience scripting macros in MS Excel;
• 2-3 years SQL is required;
• 2-4 years ETL (SAS) experience required;
• Proven success in contributing to a team-oriented environment;
• Scala development skills;
• Experience working with Client IT and Business Team for requirements gathering;
• Good understanding on the parameter file concepts and how they can leveraged for good design and solutions;
• Proven ability to work creatively and analytically in a problem-solving environment;
• Knowledge in Informatica server and application administration;
• Experience with Informatica Advanced Techniques Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput;
• Designing and implementing Informatica 10.1 PowerCenter mappings;
• Strong SQL and related skills. Ability to develop and implement complex procedures and packages using Oracle PL/SQL;
• Desire to work in an information systems environment.
• Working in Agile Teams.
• Knowledge of Jira & Bitbucket

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: $110,000- 125,000 a year

Qualifications: BACHELOR OF COMPUTER SCIENCE