Informatica ETL Developer

Informatica ETL Developer Tata Consultancy Services - 3.9 Jersey City, NJ Job Details $110,000 - $125,000 a year 1 day ago Benefits Commuter assistance Health insurance Dental insurance Vision insurance Pet insurance Qualifications Jira Performance tuning Data Integration (Data management) Requirements specification Requirements design SAS Spreadsheets Bitbucket Stored procedures Technical solutions implementation Data caching Bachelor's degree Scala Scripting Relationship management Digital project management boards Agile software development Application support Analysis (software development lifecycle) Defect tracking tools Data performance optimization Informatica PL/SQL Design (software development lifecycle)

Full Job Description Responsibilities:

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 Location Jersey City, NJ Job Function

TECHNOLOGY

Role Technical Lead Job Id 417430 Desired Skills Informatica | Oracle | SQL Salary Range $110,000-$125,000 a year

Desired Candidate Profile Qualifications :

BACHELOR OF COMPUTER

SCIENCE