ETL Developer

The position is for an application programmer / senior application programmer in Enterprise Production Support team. The role involves supporting key Enterprise applications and data marts involving strong PL/SQL and stored procedure knowledge on Oracle database platform. The candidate should have high expertise and core skills of Informatica and UNIX shell script. In addition, hands-on experience with Control-M technologies would be a plus. The successful candidate will be responsible for development and maintenance of database procedures for consumption of downstream feeds and applications in varied technologies. This would also involve intensive interaction with the business and other systems groups, so good communications skills and the ability to work under pressure are absolute must. The candidate is expected to display professional ethics in his/her approach to work and exhibit a high level ownership within a demanding working environment. Providing first line of technical support for business critical applications (Principal technologies / applications used include Oracle, Informatica, Control-M and Unix) Develop and maintain PL/SQL programs between the inbound systems and files into the warehouse data model applying business rules as specified in the requirements Work with the support team alongside data analysts, business analysts, database administrators and business project teams in enhancing and supporting the production services Maintain the Meta Data Repository both within the vendor product and the ETL tool set Help maintain Informatica mapping and Control-M schedules Conduct analysis and do bug fixes for production incidents. Carry out technical enhancements as desired. Carry out daily health-check activities involving application checks, system checks, and database checks and related on production systems / servers. The scope of responsibility also covers monitoring business critical batch workloads, real-time / interactive processing, data transfer services, application on-boarding and upgrades, and recovery procedures. Report root cause of the incidents and present ideas on how to prevent the incidents from occurring in future. Ensure adherence to incident and change management processes. Regular engagement with Business & Systems Teams looking to adopt and apply the best practice of Service Support. Prepares and maintains documentation of applications Demonstrates continuous effort to improve operations, decrease turnaround times, streamline work processes, and work cooperatively and jointly to provide quality seamless customer service. Responsible for servicing 24x7 support as per support rosters Flexibility to work in shifts ( on-demand & short-term basis), and/or on weekends Technical skills Primary Qualifications At least 1-2 years of Informatica experience with Power Centre At least 2-3 years of Oracle SQL experience with hands on for PL/SQL stored procedures Should have basic understanding of UNIX shell scripting Hands-on experience with scheduling tools - Control-M would be a definite plus Experience of any source control tool - SVN would be a plus Good Operating Systems knowledge and associated commands (UNIX [AIX/Solaris], MS Windows) Familiarity in Data Warehouse, Datamart and ODS concepts Knowledge of essential Software Engineering principles Knowledge of ITIL practices