Ask ITC Inc. which is backed by a $500 million Microtek group company, provides an industry leading blend of technology, business consulting, and outsourcing services.
Ask IT is a minority-owed enterprise; it has been founded on providing the highest quality possible and on the devotion to customer satisfaction.
Job Description
Job Title: Technical Specialist- MDM
Location: Chicago IL
Job Description
- Master Data Management products (Master Data Services MDS, others), Data Quality tools (DQS), Data Modeling concepts and tools, Other ETL (DTS, Informatica etc.)
- Microsoft Business Intelligence (MSBI) – SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
- Experience complex Master Data repositories and heterogeneous environments in a large organization (Preferably Retail)
- Experience implementing MDM solutions, working with data warehouses and/or data marts.
- Experience in Oracle - Strong SQL, PL/SQL, tuning, Unix/Linux Shell scripting
- Experience in SQL Server – Strong SQL (Complex Stored Procedures, Materialize View etc.), Tuning, Unix/Linux shell scripting (knowledge in Oracle is added advantage)
- Specializations in data modeling, data architecture, meta data management, and/or data governance. Experience working with Business Analyst/Users to translate functional requirements to technical design Experience in onsite/offshore coordination Responsibility New Market sources for existing data model entities and attributes representing additional population of people, locations, and suppliers. Sources may be landed in MDM via file, web service, and DB View
- New subscriptions to existing data model attributes via file, web service, DB View, LDAP update, or Oracle table update New business initiatives or new markets for previous initiatives that do not have an application source for master data and require a MDM UI to author their master data New business initiatives that require data model changes to accommodate new entities and attributes, new operational processes, new governance policies, new sources, and new subscriptions
Ask IT Consulting Inc.| 33 Peachtree St., Suite 100 |Holtsville, NY 11742
Website: http://www.askitc.com/
Skills Required
- Experience with Master Data Management products (Master Data Services MDS)
- Experience with Data Quality tools (DQS)
- Data modeling concepts and data architecture experience
- ETL experience (DTS, Informatica, SSIS)
- Microsoft BI experience including SSIS and SSRS
- Experience with complex master data repositories and heterogeneous environments
- Experience implementing MDM solutions and working with data warehouses/data marts
- Oracle: strong SQL, PL/SQL, performance tuning
- SQL Server: strong SQL (complex stored procedures, materialized views), performance tuning
- Unix/Linux shell scripting
- Specialization or experience in metadata management and data governance
- Experience translating functional requirements into technical design with business analysts/users
- Onsite/offshore coordination experience
- Experience integrating sources via file, web service, DB view, or LDAP
- Experience in Retail environments
What We Do
Ask IT Consulting Inc. is a global information technology management firm founded in 2008 and headquartered in Holtsville, NY. The company specializes in providing comprehensive technology and workforce solutions, including IT consulting, talent management, and digital services. Their expertise extends to cybersecurity, cloud computing, and IT staffing, focusing on delivering tailored, innovative, and effective solutions to meet the unique objectives of their diverse clients.
