Senior Solution Engineer

Deloitte Consulting LLP seeks a Senior Solution Engineer in Lake Mary, FL and various unanticipated Deloitte office locations and client sites nationally.

Work You'll Do

Assist in providing technology-enabled solutions to clients. Assist in modifying existing software to correct errors, to adapt it to new hardware or to upgrade interfaces and improve performance. Create data modules and data flow and architecture diagrams. Work with team members to evaluate interface between hardware and software, develop specifications and performance requirements and resolve client problems. Perform object and field level validation, load count validation, data profiling, data cleansing, data quality and data integrity validation, ETL load validation and ETL load performance validation using Informatica IDQ and QlikView. Write codes through ETL tools including Informatica PowerCenter, Informatica Cloud, Mulesoft ESB and Build Error Handling interface using ETL framework. Design database architecture for ETL process based on legacy CRM data model for SFDC data conversion, data integration and designed data mart models. Develop Informatica cloud mapping to replicate and to synchronize data from Salesforce to staging database for upstream applications utilizing ETL tools including Informatica PowerCenter and Informatica Cloud. Create Salesforce workflow and validation rules, formula fields, escalation rules, auto-assignment rules, Salesforce configuration for both data integration and data migration. Develop reports, dashboards and processes to monitor data quality and integrity in Salesforce. Build SQL queries, views, stored procedures and functions in Oracle and Microsoft SQL Server, Build unix scripts and Jil files to schedule jobs for data integration in Autosys. Generate reports using BI tools including SAP Business Objects.

#LI-DNI

Requirements

  • Bachelor's degree or foreign equivalent degree in Computer Science, Engineering (any), Mathematics, CIS, MIS, or a related field.
  • Two years of experience providing IT consulting services on behalf of a global consulting company.
  • Must have two years of experience with:
  • Performing object and field level validation, load count validation, data profiling, data cleansing, data quality and data integrity validation, ETL load validation and ETL load performance validation using Informatica IDQ and QlikView;
  • Writing codes through ETL tools including Informatica PowerCenter, Informatica Cloud, Mulesoft ESB and Build Error Handling interface using ETL framework;
  • Designing database architecture for ETL process based on legacy CRM data model for SFDC data conversion, data integration and designed data mart models;
  • Developing Informatica cloud mapping to replicate and to synchronize data from Salesforce to staging database for upstream applications utilizing ETL tools including Informatica PowerCenter and Informatica Cloud;
  • Creating Salesforce workflow and validation rules, formula fields, escalation rules, auto-assignment rules, Salesforce configuration for both data integration and data migration;
  • Developing reports, dashboards and processes to monitor data quality and integrity in Salesforce;
  • Building SQL queries, views, stored procedures and functions in Oracle and Microsoft SQL Server; Building unix scripts and Jil files to schedule jobs for data integration in Autosys; and Generating reports using BI tools including SAP Business Objects.
  • 15% travel required.

Benefits

At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.

Deloitte's culture

Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte.

Corporate citizenship

Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte's impact on the world.

Recruiter tips

We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you're applying to. We also suggest that you brush up on your behavioral and case interviewing skills and practice discussing your experience and job history with a family member, friend, or mentor. Check out recruiting tips from Deloitte professionals.

Requisition code: XGGS18FC0717LMF4


See Inside the Office of Deloitte

One of the largest professional services organizations in the U.S., Deloitte delivers innovative solutions to the complex business problems facing companies around the world. Deloitte offers rewarding careers in four businesses—audit, tax, consulting, and financial advisory. Widely recognized for its inclusion initiatives, Deloitte is committed to building a workplace environment that allows people from all generations, ethnicities, and cultures to be their authentic selves.


Back to top