Senior Integration Architect
- Technical design and implementation of B2B, B2C and internal application integration
- Work with Dell Boomi and Microsoft technologies such as WCF, WF, SharePoint and newest cloud based solutions
- Orchestrate business flows and build a manageable rules engine (any prior experience with rules engines will be a plus)
- Get involved in the project initiation phase and work with business partners to build concepts and models
- Responsible for a high-level project analysis and estimation
- Work with Business Analysts and the Business Integration team to design the enterprise integration architecture
- Responsible for ensuring that all security, availability, confidentiality and privacy policies and controls are adhered to
RESPONSIBILITIES:
- · Technical design and implementation of B2B, B2C and internal application integration
- · Work with Informatica and Microsoft technologies such as PowerBI
- · Create ETLs to move corporate data from on-premise to cloud platform (SnowFlake)
- · Orchestrate business flows and build a manageable rules engine (any prior experience with rules engines will be a plus)
- · Get involved in the project initiation phase and work with business partners to build concepts and models
- · Responsible for a high-level project analysis and estimation
- · Work with Business Analysts and the Business Integration team to design the enterprise integration architecture
- · Responsible for ensuring that all security, availability, compliance, and governance are adhered
- · Mentor staff on use of Informatica and integration techniques
EXPERIENCE AND KNOWLEDGE:
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related area with a minimum of 8 years related experience
- · Must be seasoned in application Integration practices across the enterprise
- · Experience designing and developing Data Warehouse applications using ETL tools like Informatica PowerCenter, Informatica Cloud, Power Exchange
- · Hands-on-Data Modeling experience with Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables
- · Hands-on experience with Database tools TOAD, SQLPlus, SQL Developer, SQL*Loader, Nexus V9.1
- · Knowledge of Reporting tools-- OBIEE, Business Objects, Cognos, PowerBI, TIBCO Spotfire
- · B2B/B2C Vendor API Integration
- · SSO Capabilities with Vendors
- · Certification on Informatica product suite
- · Experience in delivering a complex enterprise service bus application across multiple B2B platform
- · Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.
- · Agile and Waterfall SDLC delivery experience
- · Knowledge of Data Catalog systems
- · Application performance tuning and optimization
- · Strong problem solving and debugging skills, code and design reviews along with architectural documentation
- · Ability to work in a mission critical fast-paced environment with ability to work flexible hours
- · Excellent oral and written communication and collaboration skills
- · Experience in Financing industries would be a plus
- · Experience in Integration of various data sources like Salesforce, Netsuite, Workday and other enterprise software.
- · Have in depth knowledge and experience in implementing the best practices for design and development of data warehouses using Star schema & Snowflake schema design concepts.
- · Involved in Data modeling techniques like normalization, demoralizations, physical database design, relational models, star schemas, snowflake schemas, etc.
- · Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
- · Excellent interpersonal and communication skills, and is experienced in working with senior level
At Q2, our goal is to be a diverse and inclusive workforce that fosters mutual respect for our employees and the communities we serve. Q2 is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.