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.
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.
Organization Process Adherence - Candidate should follow organization process while performing the work.
Production support activities including on call.
ETL Development using SSIS.
Oracle and SQL Server Development (complex development/handling transactions/integration with SSIS).
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.
B.E, B.Tech., MCA, M.Tech., M.S
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
/ Software Services
Functional Area: IT Software - Application Programming
Role Category: Programming & Design
Role: Software Developer
Employment Type: Permanent Job, Full Time