Consultant Ii

**Consultant II
**Who we are**:
Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world.

UST is a mission-driven group of over 29,000+ practical problem solvers and creative thinkers in over 30+ countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live.

With us, you’ll create a boundless impact that transforms your career—and the lives of people across the world.

**You Are**:
UST is searching for an ETL developer who will work with stakeholders at every level of the organization, soliciting strategic imperatives from senior leaders and executives; supporting business unit managers as they leverage business architecture and product development artifacts to create and implement client business plans.

**The Opportunity**:

- Works with stakeholders at every level of the organization soliciting strategic imperatives from senior leaders and executives; supporting business unit managers as they leverage business architecture and product development artifacts to create and implement client business plans.
- Provide direct input into the governance cycle that supports the achievement of key goals, planning, and execution of various scenarios, and delivery of bottom-line value to the business
- Help client business and leadership team with problem definition
- Lead business and technology consulting projects to deliver client objectives
- Perform assessments of client business processes, organizational change, IT processes, and technology landscape, identifying transformational recommendations
- Develop a business and technical architecture strategy based on situational awareness of various business scenarios and motivations.
- Guide a team to capture the tactical and strategic enterprise goals that provide traceability through the organization; and are mapped to metrics that provide ongoing governance.
- Guide a team to describe the primary business functions of the enterprise and distinguish between customer-facing, supplier-related, business execution, and business management functions.
- Guide a team to define the set of strategic, core, and support processes that transcend functional and organizational boundaries; identify and describe external entities such as customers, suppliers, and external systems that interact with the business. Identify which people, resources, and controls are involved in the processes.
- Guide a team to define the data shared across the enterprise and the relationships between the data.
- Guide a team to capture the relationships among roles, capabilities, and business units, the decomposition of those business units into subunits, and the internal or external management of those units.

**What you need**:

- 5-8 Years of Informatica
- PowerCenter Experience
- Experience with the Informatica MDM tool
- Should be able to take source to target mappings and be able to code independently
- Should be able to understand the scope of the work and ask for clarifications and escalate to the right leads in case of issues/delays
- Advanced SQL skills. Including complex PL/SQL coding skills.
- Should be able to navigate Unix scripts and create code as required for the project
- Should have prior experience working with Dimensional models; and understand data warehousing concepts.
- Should know how to work with SCD logic.
- Should be able to communicate effectively in English.

**What we believe**:
We’re proud to embrace the same values that have shaped UST since the beginning. Since day one, we’ve been building enduring relationships and a culture of integrity. And today, it's those same values that are inspiring us to encourage innovation from everyone to champion diversity and inclusion and to place people at the center of everything we do.

**Humility**:
We will listen, learn, be empathetic, and help selflessly in our interactions with everyone.

**Humanity**:
Through business, we will better the lives of those less fortunate than ourselves.

**Integrity**:
We honor our commitments and act with responsibility in all our relationships.

**Equal Employment Opportunity Statement
**UST is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.