PL/SQL Developer with ETL (BB-6235F)
Found in: Talent IN
Description:Troubleshoot and debug existing applications and responds to suggestions for improvements and enhancements. Participate in development of software user manuals and help train users with functionality of application upgrades. Work independently on assigned development tasks. This role will entail collaborating with business owners and translating the business requirements into technical solutions. Will need to support multiple Lines of business, should be good at multitasking different development/enhancement requests. This individual will need research and analytical skills to build custom applications, maintain database and analytics environments, guide the project management team and provide insight into future technologies. Liaise with Technical Teams for service requests and upgrades. Responsibilities and Daily Tasks: Advance Knowledge of PL/SQL Responsible for providing overall database support with concentration in back-end programming. The PL/SQL Developer will be responsible to properly maintain source code sets and necessary technical documentation and assist the DBA's in overall database maintenance. Develop, design, test and implement complex database programs Strong experience with oracle functions, procedures, triggers, packages & performance tuning, Hands on development using Oracle PL/SQL. Performance tune SQL's, application programs and instances. Analyze and Recommend Database Improvements. Building Data Warehouses and write scripts to populate data in warehouses. Prepare complex DB queries, Stored Procedures for Reporting Documentation Collaborate with business analysts, global process owners, others to plan, design, develop, test, and maintain applications Design, develop and unit test applications in accordance with established standards Develop, refine, and tune integrations between applications Configure services for performance, security, and error handling Analyze and resolve technical and application problems Assess opportunities for application and process improvement Assist in the collaboration required for shared development environments Assists in determining and enforcing development standards and best practices Performance Tuning Perform application related Security Skills/Qualifications: Bachelor’s degree in Computer Science, Engineering or related technical field and 4 years of work experience in job offered or 4 years of work experience in a computer-related occupation. Required Experience / Skills: Analyze and Recommend Database Improvements Strong experience with Oracle Functions, Procedures, Triggers, Packages & Performance Tuning, Hands on development using Oracle PL / SQL. Perform Data quality, data modeling and database tasks as required 2 years of experience in custom ETL design, implementation and maintenance Working with customers for Requirement Analyses, Build data migration strategy and Write Scripts as per project requirements Good troubleshooting, analytical and problem-solving skills Strong Knowledge of Complex SQL queries, stored procedures, Functions, Views, Indexes and Query Proactively monitor the performance of data jobs and tune the jobs as needed. Performance Tuning. Experience in Data warehouse design, dimensional modeling and data mining Ability to work with minimal supervision, using own initiative whilst also being a self- motivated, proactive team player. Experience on Oracle Apex application development (*plus) Proficiency in RDBMS concepts & advanced experience in creating & using database objects required. Designing, developing and testing of packages, procedures, functions, views and triggers Has good knowledge of DW architectural principles Excellent verbal and written communication skills Ability to work in a highly collaborative environment with minimal supervision Ability to manage the development of multiple projects in a fast-paced environment based on competing priorities Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming and performs testing and debugging of applications. As a member of the software engineering division, you will perform detailed design based on provided high level design specifications. Assist in system planning, scheduling and implementation. Build enhancements (including new product features) and resolve bugs. Build and execute unit test and unit test plans. Review integration and regression test plans created by QA. Interact with QA and porting engineering about problems in the code. Duties and tasks are standard with some variation; displays understanding of roles, processes and procedures. Performs moderately complex problem solving with assistance and guidance in understanding and applying company policies and processes. BS degree or equivalent experience relevant to functional area. 1 year of software engineering or related experience. This employer is a corporate member of myGwork, the business community for LGBTQ+ professionals, graduates, inclusive employers & anyone who believes in workplace equality.
calendar_today4 days ago