Production Support + Sql

Visa status: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply.
Tax Terms: W2, 1099
Corp-Corp or 3rd Parties: Yes
Production support, knowledge of PL/SQL, ETL, Greenplum, Control M    
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
•         Work on tools for deployment; monitoring and operations. 
•         Strong communication skills to work effectively across multiple businesses and technical teams
• Consider overall architecture when performing design; L3 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
Qualifications
• Strong communication & logical skills
• Strong experience within Agile process
• Minimum 5+ Years' experience Oracle 11g
• Minimum 3+ Years' experience in Informatica ETL tool
• Strong SQL performance tuning / optimization
• Unix Shell scripting 
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