Send me more jobs like this

PL/SQL Developer with ETL

Keywords / Skills : PL/SQL Developer, ETL, SSIS, SSRS, SSAS, Informatica

5 - 7 years
Posted: 2019-08-23

Industry
IT/Computers - Software
Function
IT
Role
Software Engineer/Programmer
Posted On
23rd Aug 2019
Job Description
Job scope and requirement

Scope

1. Develop complex database processes with PL/SQL containing ETL functionality

2. Design logical and physical ERD diagrams, process flow diagrams, functional/technical specifications or related data processing documentation

3. Participate in performance tuning activities

4. Provide production deployment and production support as needed

5. Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions

Skills

1. Strong SSIS, SSRS & SSAS Experience & capabilities

2. Designing, creating and developing Oracle database systems (Current database version is 12C)

3. Strong programming/development skills using PL/SQL (package, procedures, functions, triggers)

4. Solid experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance

5. Excellent analytic, troubleshooting and performance tuning skills

6. Experience in ETL tools, like informatica, Talend, etc. will be added advantage

7. Strong English Communication (verbal/written) to support on documentation

Additional Contribution

1. Experience on DataWarehousing Architecture

2. Experience on Production Reporting

3. Manufacturing environment experience is an added advantage



About Company

Aptude’s information technology consulting services can take your organization to the next level. Whether your technology-supported business needs are simple or complex, we’ll work with you to implement solutions to achieve them. Our expertise spans a wide range of technology platforms and applications—and we have the experience to help you make the most of your technology.
Similar Jobs
View All Similar Jobs


Walkin for you