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 toolsEstimated Salary: $20 to $28 per hour based on qualifications.
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 toolsEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
