Job Description :
Position: Lead Informatica Developer
Location: Houston, TX
Contract: Full-Time
Interview Process: Webex(In-person will preferred)
Visa: USC or GC
Job description
As a Lead Informatica Software Engineer you will design, create and support objects in Informtica PowerCenter using an Oracle 11g database. Interface with the user community to collect and document requirements for various projects.
Key Responsibilities:
Adheres to architecture standards, risk management and security policies, leading presentations in architecture review, strategic technology directions, best practice development (e.g., estimating models), mentoring less experienced team members, code reviews
Responsible for design, build and maintenance of software applications for Chase Card Services Data Warehouse
Designs, analyzes, develops, codes, tests, debugs and documents programming to satisfy business requirements
Will deliver the assigned work within specified timelines with high quality
Should possess good communication skills and solid knowledge on software delivery lifecycle in large Warehouse environment
Will participate in every phase of software delivery life cycle including Requirement, Analysis & Design, Build Code, Unit Test, Support system and Integration testing, Implementation phase and post implementation support
Will write and enhance Technical specifications based on functional specifications
Will produce Unit test case results, Implementation plans, Application Support Guide using Word, Excel, PowerPoint, Visio
Develop code using Informatica, Oracle, Unix (Korn Shell scripts), PL/SQL, and Scheduling tools
Thoroughly perform unit testing ensuring minimal code defects out of build phase into system test phase
Should have solid knowledge of Informatica Power Center, Repository and client
Development of ETL concepts, Oracle Table partitioning
Provides the project manager/supervisor with timely and accurate information regarding the performance of the assigned projects(s)
Understand scope of work and work closely with PM''s, BSA''s, UAT team, Tech Ops and individuals from other groups
Identify and communicate potential impacts of a change/issue to other areas
Demonstrates sound analytic and diagnostic skills dealing with issues
Bachelor''s degree in Computer Science or related field with 8+ years experience as a software developer
Minimum 5+ years’ experience with Informatica PowerCenter
Minimum 5+ years Oracle, PL/SQL including triggers, stored procedures, queries, etc. (Oracle 11g)
Minimum 5+ years’ experience with large Data Warehouse and handling high data volumes
Minimum of 3 years in a Lead Developer role.