Previous Job
Previous
Data Warehouse Developer
Ref No.: 18-05735
Location: New York, New York
Position Type:Contract
Pay Rate : $ 69.42 - 78.48 /Hour
Our Client is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. The Firm's employees serve clients worldwide including corporations, governments & individuals from more than 1,200 offices in 43 countries. They are currently looking for a Data Warehouse developer for their Risk Management department. The Risk Management department responsible for monitoring, measuring and communicating risks generated by Our client's business lines.
 
Responsibilities:
  • Design and implementation of Data Warehouses, planning applications and reporting solutions
  • Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts
  • Gather requirements and create system and user documentation
  • Develop solutions to leverage ETL tools and identify opportunities for process improvements
  • Conduct root cause analysis and resolve production problems and data issues
  • Provide technical expertise and recommendations in analyzing customer needs, document requirements, and design technical solutions
  • Create test plans, test cases, test scripts and perform data testing and validation
  • Work with existing systems to track and manage requests and issues
 
Skills Required:
  • 3+ years' experience including data analysis, data integration, dimensional modeling, database design and development
  • Advanced SQL skills are a must
  • Strong relational database knowledge.
  • Experience in Unix Scripting
  • Proficiency in ETL/ELT Tools like Informatica (preferred), IBM Infosphere DataStage 8.x or higher and Data Integrator
  • Perl Scripting is a plus.