Asst Mgr- SQL Developer/ Database Developer/ Data Analyst will be responsible for analyzing data from various source systems and assist in converting it into meaningful information by performing necessary data operations for Global Analytics Team.
Develop & Implement and manage data strategies that optimize the data quality to improve standardization.
Maintain and create the data governance standards, rule books and metadata to support current master and transactional data
Able to perform data quality / cleansing, de-duplication and harmonization of data across the various systems
Identify the patterns and frequency of the data in the dataset and prepare the reports
Manage the data quality audits/rules and generate the reports
Convert business rules into technical rules for data quality analysis.
Report data quality/integrity issues to the business users identify root causes and provide solutions
Create define and maintain the documentation representing data elements across multiple systems.
Experience in writing SQL code (stored procedures, triggers, and database scripts) to implement business logic and database maintenance
Develop queries and stored procedures for data extraction, using SQL queries and one or more relational databases such as SQL Server/Oracle/MS Access
Experience with SQL Server 2005/2008, Oracle 10g/11g, MS Access 2010
Some experience in SSIS OR SSRS
Experience with SAP Information Steward, SAP DI/DQ would be an added advantage.
Experience in writing complex SQL queries, designing, developing, debugging and deploying SQL Server stored procedures
Experience in working with data quality, metadata management, master data management (MDM) or data governance initiatives
Experience in providing data analysis, identifying data related business needs and providing practical and workable solutions
Understanding of how data is used within business processes and its impact on desired business process outcomes.