Job Description :
Title: DB dev
Location: Alpharetta, GA
JOB DUTIES:
Works on problems of moderate and varied complexity where analysis of data may require adaptation of standardized practices or precedent. Acts independently to identify and select appropriate methodologies. Work customarily and regularly (50% of time or more) requires the exercise of discretion and independent judgment. Normally receives general instructions on non-routine work assignments. Requires additional instructions and frequent guidance on new assignments. Decisions are made independently. Assigned multiple tasks or projects are generally reviewed after completion. Contact is typically coordinative in nature and involves exchanging detailed technical information. May deal with both internal and external contacts. Demonstrates working knowledge in job-related functional area and of the business.
Minimum 7 to 8 years full SDLC development experience with Informatica Power Center 9.1. 6-7 years Oracle PL/SQL, SQL, Stored Procedures, Packages, SQL Navigator or similar 3-4 years Unix Shell scripting Working knowledge of the Data Transformation 8.6 or higher and how it integrates with Power Center. Full understanding of each Power Center component: Designer, Workflow Manager, Workflow Monitor. Ability to create and maintain Tasks, Worklets, Workflow, Sessions, Mappings, Mapplets, Transformations. Full understanding of each data transformation type and ability to effectively implement into a mapping. Ability to trouble-shoot and solve configuration issues. Design and implement full solutions according to Business Requirements. Identify existing software defects and develop solutions Create design documents of work done for the project team. Can take ownership of assigned tasks and plan own time to ensure project milestones are met. very good understanding of database structures to support data integrity and performance, SQL, PL/SQL, query tuning
The team member in this role will work on database systems critical to a great customer experience in or self service channel (web portals and mobile application