Abinitio/Etl Developer - Pl-sql

Soft tech Career Info system Pvt. Ltd
  • Bangalore
  • Confidential
  • 3-8 years
  • Views
  • 08 Nov 2016

  • Software Design & Development

  • IT/ Technology - Software/ Services
Job Description

- Developer will be responsible for ETL tools development to build a critical DB2/Oracle database platform, which supports various data management needs.

- The developer will implement tasks related to data management, data extraction, business/IT rule transformation, data load to target system, and data conversion efforts, as well as support other production ETL processes and systems in the data management team. The developer will work closely with the Project Manager, Lead Systems Architect, MicroStrategy developers, QA engineers, and Business Analyst throughout the project lifecycle under minimum supervision of project manager/development lead.

Required Skills:

- Ab Initio, ETL, PL/SQL, data warehouse

- PL/SQL

- Design and implement new ETL workflow and/or customize/maintain existing workflows and processes (optimizing performance is assumed).

- Propose Ab Initio features for best design, customization, and user experience.

- Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.

- Produce ETL design documents, test plans, and system requirements (good writing skills).

Required:Top 4-

- Design and implement new ETL workflow and/or customize/maintain existing workflows and processes (optimizing performance is assumed).

- Propose Ab Initio features for best design, customization, and user experience.

- Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.

- Produce ETL design documents, test plans, and system requirements (good writing skills).

- Strong understanding and practical experience in the Systems Development Lifecycle (SDLC).

- Software design, development, testing data warehouse and business intelligence applications using ETL tool Ab Initio with DB2 databases.

- Work with Database Developer, JAVA developer, Business Analyst, DBA, System Administrator, and QA engineer to design and implement ETL workflow and programs required for various data systems.

- Design new ETL workflow and/or customize/maintain existing workflows and processes.

- Implement ETL processes primary in Ab Initio.

- Propose Ab Initio features for best design, customization, and user experience.

- Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.

- Optimize performance by analyzing, ETL workflow and query patterns.

- Manage ETL artifacts in source code management system and deploy to DEV, QA, and Production environments.- Development of test cases and coordination of activities to aid QA/Validation team as needed.

- Analyze issues fix defects during SDLC, troubleshoot production issues, and respond to business users data inquiries.

- Produce ETL design documents, test plans, and system requirements.- Strong communication skills.

Desired skills:

- Experience working with multiple database structures.


Job Posted By

O.P. Chawla
Director