Senior Programmer Analyst Job Job in Framingham, Massachusetts US
Senior Programmer Analyst Job
Senior Programmer Analyst: # Primary Responsibilities: - Identify data sources and compile mapping logic between source systems and the data warehouse components (staging server, atomic level database, star schema databases, data mining files, etc.) - Analyze data in source systems to identify data cleanliness issues, e.g., missing values, duplicate meanings, and invalid data - Develop cleansing programs - Work with source systems to anticipate modifications that will impact the data warehouse updates - Develop feed back processes to get "dirty data" fixed in the source systems - Develop data extraction, cleansing and load programs (daily and initial load) to staging server and data warehouse Develop, implement and maintain schedule/dependency logic for ETL scripts - Develop data quality/validation programs to balance to defined source systems - Research and resolve causes for incompatibility between the DW and source systems - Develop monitoring, error notification processes to ensure data is updated as expected - Automate extraction, cleansing and load scripts - Develop standards for coding, documentation, error handling, error notification, logging, etc - Develop, document and execute test plans for data loading and data validation scripts - Support DSS Business Analyst for balancing, triage, etc. Develop mappings to move data from are varied sources to the target Data Warehouse - Identify and analyze Source systems for appropriate data feeds - Promote Code from Development through QAT into Production as required Qualifications Basic Qualifications: - BS in Computer Science or equivalent work experience - 4-5 years experience in production development environment - Experience programming using embedded SQL, along with good database design background - Experience with Informatica Preferred: - Experience with large data sets - Extraction/Transformation/Load tools - Experience in developing applications using error and event logging - Recent, strong experiences in client/server technologies (C, C++, Visual Basic, NT, Unix, etc.) - Experience identifying client business requirements - Experience with MQ/Series or other Messaging tool a plus Job: Information Technology Location(s): US-MA-Framingham Schedule: Full-time Job Level: Non-Manager Shift: Day Job Job Type: Experienced Employment Statement Staples is an Equal Opportunity Employer who values the diversity of our people, products, and services.