Job Description :
RS Transformation – Informatica Developer III with Salesforce Experience Job Description ( Please DO NOT Submit resumes without Salesforce Experience)
Location:- Indianapolis IN
Duration:- 6 months
Description:
The Informatica Developer III is responsible for leading the development and customization of applications. The Informatica Developer III may be called upon to function as a team lead and may have ongoing supervisory responsibilities. The Informatica Developer III typically reports to a systems development manager within the information systems department.
Key Responsibilities:
Manage the creation of complex SQL code and mappings to extract, transform, and load data ensuring compatibility with all tables and users specifications
Work with various levels of project managers, data modelers, software developers, and system administrators to design load processes and identify potential problem areas in source systems
Solve data integrity issues and ensure timely data availability.
Lead the creation, execution, and organization of sessions, monitoring load times and rearranging processes to increase the efficiency and effectiveness of the loading process
Perform data load monitoring and problem resolution; take action to resolve recurring issues.
Analytical and logical thinking to create and modify process flows - adaptable in communication style to reflect the audience (executive vs developer)
Skills:
Required
Thorough understanding of systems programming
Ability to design, code, test, and debug
Ability to give direction
Must have designed and implemented minimum 2 end-to-end project implementations using Informatica PowerCenter
Must have strong development skills using Informatica PowerCenter
A four-year College Degree in Business or Information Systems is required
1+ years of experience analyzing data, developing data mapping requirements, or equivalent knowledge
Core competency in: ETL tools (Informatica), Relational DBMS (Oracle, SQL Server)
Competent level of understanding of SQL, PL/SQL, SSIS, Stored Procedures, and API''s of assigned modules
Solid understanding of programming, database, system design, and conditional logic
Strong oral and written communication skills are required
Excellent critical thinking skills
Ability to drive assignment through to completion, including interactions with 3rd party vendors
Ability to give direction, with experience guiding other team members and coordinating offshore teams
Preferred
Detailed Financial Services industry experience
Experience working on an agile project team and agile methodologies
Experience with XML
Exposure to Mainframes/Cobol data formats desirable
Experience with MQ Series
Experience with Web Services
Experience:
7+ years experience in the IT field, with at least five years in a programming capacity;