New User: Apply to selected job without registration
Cancel
  New User: Apply to selected job and register
Please fill in the below details to apply to the selected job.
If you are registred User, Login to Apply
Cancel

ETL Senior Developer- SQL & Oracle Development

4 - 7 YearsHyderabad

Not Disclosed by RecruiterPosted: 22 days agoJob Applicants: 419+Job Views: 2424+
Send me Jobs like this

Job Description

Key Responsibilities




Software Development

Perform ETL Transactions and develop Jobs to fetch data.
Knowledge of both Oracle and SQL is must (At least not Expert) but should be able understand and develop.
Should be able to develop complex Stored Procedures, Functions, Trigger, User-defined Functions, Views and Indexes.
Scanning of DB files and develop scripts to load.
Experience on Designing and Implementing ETL methodologies/solutions on basis of requirements.
Strong exposure to working on complex reports using SSRS, preferably having experience on Power BI.
Production support activities including on call support.



Client Interaction and communication

Attending client calls - The candidate shall be able to attend client calls during India and US overlap time in morning or evening.
Status Reporting - The candidate shall be able to provide status update of the assigned work in the form of status reports, emails or over the call.



Change Management

Candidate shall be able to understand requirement changes and re-plan the work accordingly.
Onsite Travel Candidate shall be able to travel to US based client office on need basis.



Process Compliance

Organization Process Adherence - Candidate should follow organization process while performing the work.
Production support activities including on call.



Primary Expertise




ETL Development using SSIS.
Oracle and SQL Server Development (complex development/handling transactions/integration with SSIS).



Secondary Expertise




PowerShell scripting (not deep, but should have good knowledge on how scripting works and should be able to take over or manage existing scripts).
Python/Pearl scripting (not deep, but should have idea on how scripting works).



Qualifications and Experience









Years of Experience


5 to 6 Years.

Educational Qualification


B.E, B.Tech., MCA, M.Tech., M.S

Prior Experience


DB - SQL Server+ Oracle : 4+ yrs. Module level DB design, knowledge of indexes, relationships, queries, joins, performance tuning, normalization

SQL Server + oracle Development: 4+ ETL Methodologies

TSQL / SQL Database experience 4+ yrs.

Reporting Tools: good to have reporting experience and Business Intelligence.

Scripting : Python , Perl , Power Shell

ETL:- Loading and reading data from various data sources including Oracle and SQL Server.

Understanding of various file formats ( XML , JASON, Flat , MS Office)

Good to have analytics experience



Salary: Not Disclosed by Recruiter
Industry: IT-Software / Software Services
Functional Area: IT Software - Application Programming, Maintenance
Role Category: Programming & Design
Role: Software Developer
Employment Type: Permanent Job, Full Time
Keyskills:

Desired Candidate Profile

 


Company Profile

Prolifics Corporation Limited
Prolifics is a CMMI Level 5 developer certified company. We create competitive advantage for organizations around the world by implementing customized, end-to-end IT solutions that achieve business success, leveraging leading technologies in a global delivery model. For more than 35 years, our industry-specific insights and certified technology accelerators have transformed organizations around the world by solving complex IT challenges. We have a Global presence across North America, Europe & Asia. In India we have 5 off shore development centers, 4 in Hyderabad & 1 in Pune. We collaboratively work with Technologies from IBM, Microsoft, Open Source & Packaged Application.
View Contact Details+
Contact Details

Recruiter Name:Abdul Gafoor

Contact Company:Prolifics Corporation Limited

Reference Id:2017-2960

Website:https://www.prolifics.com/