Apply Now    

Software Engineering

Req #: 180017733
Location: Bangalore East, KA, IN
Job Category: Technology
Job Description:
DB-ETL Developer/Support Analyst:
Applications Support for the Asset Management Risk & Forecasting solutions team you will be responsible for delivering technology solutions using Oracle, Informatica, ETL Processes in support of the Asset Management Risk & Finance applications. The candidate will be required to work with business analysts, technical leads and the development team to understand business requirement, functional specification documents and to translate these specifications into technology data design, transformation and implementation.  
Job responsibilities:
  • Perform analysis and design work, including impact of requirements across all system components
  • Perform the L1/L2/L3 support activities for the Production Support project
  • Consider overall architecture when performing design work and data modeling work
  • Capture analysis/design output within high level/low level design documents 
  • Work closely with database, application/java, ETL and reporting developers during design process
  • Provide support in tuning SQL statements, procedures, triggers
  • Help establish data design and modeling standards 
  • Required to perform database analysis, understand data content and associated data relationships
  • Create unit test cases, perform unit testing, document test results and perform code reviews 
  • Work with technical lead, business analysts and QA team to analyze and correct defects within the SIT and UAT phases
  • Work with operate team to support production deployments and analyze post-production defects
  • Participate in code reviews and ensure that all solutions are aligned to coding standards
  • Strong communication & logical skills
  • Strong experience within Agile process
  • Minimum 6+ Years’ experience Oracle 11g
  • Minimum 3+ Years’ experience in Informatica ETL tool
  • Strong SQL performance tuning / optimization
  • Unix Shell scripting
  • Versioning tools such as SVN etc 
Nice to have: 
  • Previous Credit/Market Risk experience
  • Experience with Greenplum database.
  • Experience with Big Data technologies such as Hadoop etc.
  • Exposure to reporting tools preferably Tableau
Apply Now    
Link for schema

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.