305-651-6500

Jobs    Everything

Select a Metro Area

Description:

 

Responsibilities include collecting and validating data for partner, internal/outbound sales, and funding reports.  Support Business Object migration project, which includes recreation and testing of existing reports to ensure functionality/accuracy on new systems.  Troubleshoot data issues in existing systems (loan origination, contact management, etc…) Ensure data integrity within current databases.  Create ad hoc queries using Business Objects and/or SQL within an ORACLE environment.  Work with Project Managers and QA teams to develop validation requirements and data integrity mechanisms.  Assist Business Analyst with various projects/tasks.

 

Responsibilities:

  • Creating, troubleshooting and documenting ETL processes in Informatica and SSIS.

  • Basic SQL, DB knowledge- Requirements planning and management

  • Requirements elicitation, analysis and documentation

  • Writing Microsoft T-SQL and Oracle PL/SQL scripts, views, and stored procedures as needed

  • Database development skills

  • Extract/Transform/Load (ETL) Skills

  • Exposure to a multitude of interrelated relational databases, including Microsoft Transact SQL, Oracle PL/SQL, Informatica, and Microsoft SSIS

  • An understanding of enterprise data process flows

Required Skills

  • A good Data Analyst with Excel, SQL (querying, not database)

  • Relational Database Knowledge, Microsoft Transact SQL

 

 

SherlockTalent Loves to Share $500 Referral Bonus!