Key skills
SQL.NETETLData WarehousingAnalyticsSQL ServerREST APICommunicationCritical ThinkingProblem SolvingPresentation Skills
About this role
- Bachelor’s/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply
- 5-7 years in SQL Server and SSIS Development.
- Strong hands-on experience with SQL,SSIS (creating and managing ETL packages, Data Transformations and Error Handling).
- Experience working with ETL on Rest API’s, JSON, XML Formats
- Knowledge of Data Warehousing Concepts and ETL best practices.
- Familiarity with SQL Server Agent Jobs and Automation.
- Good critical thinking and problem solving skills.
- Strong record of achievement, solid analytical ability, and an entrepreneurial hands-on approach to work
- Outstanding written and verbal communication skills, and presentation skills
- Able to work in fast pace continuously evolving environment and ready to take up uphill challenges
- Is able to understand cross cultural differences and can work with clients across the globe
- Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms
- Design, Develop and maintain SSIS packages for data extraction, transformation and Loading (ETL).
- Assist in the roll-out of new SQL, SSIS based applications, problem fixes, and enhancements of software
- Follow database best practices to improve the operational reporting environment while focusing on resolving problems raised by team members, stakeholders and end users
- Develops original and/or complex code in T-SQL/ SQL
- Design and develop new SQL code as part of an ETL process
- Improve SQL procedures, Window services / .NET programs which transform and load data
- Responsible for data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
- Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people
- Bachelor’s/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply