*Direct Client Requirement :*
*Role : *Oracle Developer *Location : *Las Colinas *Duration : *6+ months *Must be local to Dallas/Texas … Onsite interview in Las Colinas.* *ESSENTIAL DUTIES AND RESPONSIBILITIES *include the following. Other duties may be assigned. - Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices - Work with Business analysts to gather business requirements from end users and translate them into technical specifications. - Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow and process. - Perform data analysis on input and output data using the tools available, and solve any data related queries or issues. - Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed. - Source-to-target mappings and data analysis - Being a core developer for the EDW, data marts (star schema) - Assists developers with difficult Oracle PL/SQL code needed for queries, triggers, and stored procedures - Design, develop, implement and maintain custom oracle applications written in PL/SQL. - Controls all changes through a formalized change request process - Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements - Conducts reviews of developed code - To be responsible for providing technical guidance / solutions - To develop and guide the team members in enhancing their technical capabilities and increasing productivity - To prepare and submit status reports for minimizing exposure and risks on the project or closure of escalations. - Take ownership of projects and manage statuses and timelines effectively - Designs data marts to support Business Intelligence reporting using Business Objects. - Perform data analysis and data profiling against source systems and data warehouse *QUALIFICATIONS :* To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. - Must already be sufficiently competent in dimensional data modeling to design data warehouses and data marts using SQL and Oracle PL/SQL. - Knowledge of slowly changing dimensions, partitioning, and basic data warehousing concepts (both in theory and as applies to PL/SQL). - Ability to help create and map business needs/application requirements to technical solutions - Development experience must be full Life Cycle experience including business requirements gathering, data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture. Must have specific Development Life Cycle Methodology experience and have used it in multiple project deliveries. - Experience of ETL development, testing and implementation using Informatica - Experience of working with high data volume and strict performance requirements - Experience writing advanced SQL queries, PL/SQL Stored procedures, Functions & Packages - Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables - Proficiency using Toad or equivalent developer tools - Basic UNIX shell script experience required. - Experience troubleshooting issues across different technologies including SQL, and Oracle. - Exceptional debugging skills - Excellent verbal/written communication and effective interpersonal skills to work with user community. - Possess strong analytical, problem-solving, and organizational skills - Ability to work independently and in a team environment, in order to achieve personal and team goals and complete assignments within established time frames. Thanks & Regards! Manisha, Talentminds Inc, Irving, TX, Direct Number: 214-884-5321, Email : mani...@talentminds.com, www.talentminds.com. -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.