[Close] 

ETL/SQL Developer

Company Name:
Open Systems Technologies
Required Skills
o 5+ years of working in various data management initiatives with 2+ years in the Financial Industry
o Minimum of 2+ years of experience in designing and implementing Talend (or any other ETL tool) solutions according to best practices and coding guidelines
o Minimum of 2+ years of ETL Experience in design, configuration, data mapping, extraction, transformation, and loading
o Ability to work in an agile environment
o Experience working with all aspects of SDLC workflow
o Should be able to participate in the testing phase and in writing unit and integration test scripts
Data Procurement/Integration:
o Strong SQL skills, and an ability to write complex queries, and experience working with Oracle, Netezza or other databases
o Experience with database application development (Stored Procedures, PL/SQL)
o An excellent understanding of Data Warehouses and Marts
o Experience with Unix/Linux environment, scripting, code migration and deployment
o Experience with Job design and scheduling using Autosys or similar technologies
o Experience in modeling financial schemas
o Experience using data modelling tools like Erwin or ER Studio.
o Good design documentation skills
Data Analysis/Reporting
o Data Analysis skills is highly desired
o Exposure to SSIS and SSAS technologies
o Experience using reporting/analytical tools like Qlikview, Tableau, Spotfire, BO, Xcelsius among others is a plus
o Experience working with the Microsoft Suite of tools

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.