PL / SQL Developer with ETL Experience

Job Title

PL / SQL Developer with ETL Experience

Relevant Experience

(in Yrs)

8 – 12 Years

Technical / Functional Skills

Experience in Telecom billing

Expert knowledge of and experience in PL / SQL programming

Experience in Oracle database 10g and above

Experience in performance tuning of SQL statements

Experience in ETL Tools, especially with PLSQL.

Experience with code versioning tools such as Gitlab, and have knowledge on JIRA

Solid knowledge of relational database management systems

Must be able to construct complex SQLs and SQL optimization

High-level problem solving / analytical skills

Excellent ability to multi-task and effectively prioritize and successfully execute tasks in a fast paced environment.

Excellent written and verbal communication skills

Ability to quickly understand existing product with min support.

Interest to learn new ETL technology tools (K2view ADI)

Experience Required

8- 12 Years

Roles & Responsibilities

Modify procedures to resolve complicated problems in view of computer equipment capacity along with constraints, operating time and desired results form.

Head responsibility to integrate system and perform technical lead for those projects.

Analyze designs, develop and execute custom application features and functions.

Develop all data warehouse models and prepare reports for all meta data integration into systems and draft all ETL scripts and prepare required reports for all end users.

Design and implement all publication activities such as dashboards and maintain required system documentation according to IT applications and SDLX procedures and provide support to all activities and provide resolution.

Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.

Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.

Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.

Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.

Design, code, test, debug, and record those programs proficient to work at top technical level.

• Evaluate, design, code and test improvement as required to complex modules.
• Develop system parameters and interact for complicated components.
• Design and develop code applications to technical and functional programming standards.
• Coordinate and involve in structured peer reviews and walkthroughs.
• Plan and implement every needed process step as defined in methodologies.
• Develop operational documents for Application.
• Present application and technical support as necessary at right time.

Generic Managerial Skills