Jason Schultz Email & Phone Number

Rogers, MN, US

Greater Minneapolis-St. Paul Area

• Partnered with business analysts, data architects, and DBAs to build and maintain ETL framework using Informatica technology.
• Collaborated with project managers, developers, testing, and DevOps engineers to deliver robust solutions to satisfy clients’ functionality, scalability, and performance requirements.
• Continuously reviewed ETL process to enact proactive changes for maintenance efficiency. Routinely developed mappings, mapplets, and workflows.
• Worked with our offshore technical center to monitor and support ETL and address quality applications 24/7. Automated error detection and job scheduling tasks ensured reliable performance.
• Planned and executed our lift and shift strategy to move to AWS Private Cloud. Built and deployed more than 30 systems to AWS without impacting business operations.
• Replaced a third-party data quality software with a new integration written in Python and utilizing Docker containers. Reduced the existing rules set by more than 40% by reviewing all rules with the business owners.

Greater Minneapolis-St. Paul Area

• Using Trillium Discovery and SQL, profiled more than 5,000 data attributes across nine source systems as part of an ERP implementation. Worked with business and IT owners to identify more than 800 business rules for.
• Created more than 30 Trillium Quality projects for ERP data cleansing, all fully integrated within Informatica process flows. Trillium touches all transactional data feeds for our ERP system.
• Developed a real-time Trillium Director address cleansing web service, deployed across 3 data centers. This solution services global e-commerce systems and includes address cleansing for US, Canada, EU, & Korea.
• Provide daily production support for all Trillium production functions, both batch and real-time.
• Work with several business units (Accounting, Reporting, and Marketing) to create ad hoc Trillium projects. These projects address specific business needs such as data profiling, address quality, and data matching.

Greater Minneapolis-St. Paul Area

• Team Lead of the Data Management group. Primary focus of the group is the accurate extraction, analysis, and manipulation of data within all production data environments.
• Perform data management, reporting, and testing primarily within several relational databases, primarily Oracle 10g.
• Analyze and refine data extraction – How data is gathered, optimize and verify queries, confirming the correct data is selected with a high degree of accuracy. This requires numerous high priority ad hoc queries and.
• Work directly with several business departments responding to how data records look and why.
• 2006 Reach for Excellence Award winner (employee of the year program)