Parkcom

ETL Developer Informatica Oracle DB

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Pune
  • Experience: 9-14yrs
  • No. of Positions: 684
  • Salary Range: 10-16.8 lac
  • Primary Skills: Oracle DB Applications Implementation API Integration Cognos Informatica SQL Server
  • Secondary Skills: Talend ETL Performance Tuning Troubleshooting
  • Job Location: Pune
  • Posted Date: 385 days ago
Job Description

Roles & Responsibilities :

 

We are looking for a Senior Database Developer to provide a senior-level contribution to design, develop and implement critical business enterprise applications for marketing systems

1. Play a lead role in developing, deploying and managing our databases (Oracle, My SQL and Mongo) on Public Clouds.

2. Design and develop PLSQL processes to perform complex ETL processes.

3. Develop UNIX and Perl scripts for data auditing and automation.

4. Responsible for database builds and change requests.

5. Holistically define the overall reference architecture and manage its overall implementation in the production systems.

6. Identify architecture gaps that can improve availability, performance and security for both productions systems and database systems and works towards resolving those issues.

7. Work closely with Engineering, Architecture, Business and Operations teams to provide necessary and continuous feedback.

8. Automate all the manual steps for the database platform.

9. Deliver solutions for access management, availability, security, replication and patching.

10. Troubleshoot application database performance issues.

11. Participate in daily huddles (30 min.) to collaborate with onshore and offshore teams.

Qualifications :

1. 5+ years of experience in database development.

2. Bachelor's degree in Computer Science, Computer Engineering, Math, or similar.

3. Experience using ETL tools (Talend or Ab Initio a plus).

4. Experience with relational database programming, processing and tuning (Oracle, PLSQL, My SQL, MS SQL Server, SQL, TSQL).

5. Familiarity with BI tools (Cognos, Tableau, etc.).

6. Experience with Cloud technology (AWS, etc.).

7. Agile or Waterfall methodology experience preferred.

8. Experience with API integration.

9. Advanced software development and scripting skills for use in automation and interfacing with databases.

10. Knowledge of software development lifecycles and methodologies.

11. Knowledge of developing procedures, packages and functions in a DW environment.

12. Knowledge of UNIX, Linux and Service Oriented Architecture (SOA).

13. Ability to multi-task, to work under pressure, and think analytically.

14. Ability to work with minimal supervision and meet deadlines.

15. Ability to write technical specifications and documents.

16. Ability to communicate effectively with individuals at all levels in the company and with various business contacts outside of the company in an articulate, professional manner.

17. Knowledge of CDP, CRM, MDM and Business Intelligence is a plus.

18. Flexible work hours.

Relevant Job Openings
Front End Developer
Python Developer
Python Developer
Network Administrator or System Administrator
IOS Developer
Exclusive Hiring For MS Dynamics Sr CRM Developer