•Ensure accuracy and integrity of data and applications through analysis, coding, writing clear documentation and problem resolution.
•Perform incident and problem management and troubleshooting to resolve and escalate issues, and lead root cause analysis to ensure platform stability.
•Develop, test and implement program logic.
•Collaborate with the client together with the Data Warehouse Architect to perform solution design or architecture for data integrations and interfaces between applications, databases, and other data sources, both internal and external.
•Handle client concerns with regards to design in the absence of the Data Warehouse Architect.
•Analyze and translate functional specifications and change requests into technical specifications.
•Monitor progress and supervises the Data Integration Specialist and Data Integration Associate.
•3+ years database and/or data integration design, programming or support experience
•Proficiency in the following areas:
oData Warehousing, Data migration/transfer, Data integration modeling and design
oRelational Databases (Oracle, SQL Server)
oExperience in ETL tools - SQL and PL/SQL scripting
oPractice system and development cycle
oExperience in Hadoop solutions an advantage
oOperating systems (Windows, Solaris, AIX, Linux, HP-UX)