Deloitte Solution Specialist, Strategy & Analytics, Analytics & Cognitive in Mechanicsburg, Pennsylvania

Deloitte Consulting LLP seeks a Solution Specialist, Strategy & Analytics, Analytics & Cognitive in Mechanicsburg, PA and various unanticipated Deloitte office locations and client sites nationally.

Work You ll Do

Function as integrator between business needs and technology solutions and help create technology solutions to meet clients business needs. ETL Design, development, optimization and implement systems and processes to capture, integrate and distribute information in an enterprise. Coordinate and participate/lead data model design along with Enterprise Data Architect. Analyze source system data to assess data quality through data profiling and utilize data validation to ensure data accuracy throughout ETL process. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Coordinate with Project Manager and participates in project planning. Work with business partners to review prototypes and develop iterative revisions. Oversee and performs troubleshooting and provide resolutions to reporting issues. Monitor production processes, review reports and monitoring tools daily for data quality, performance and on time completion of processes. Ensure best technical practices are followed for enterprise software development. Monitor and document post-implementation problems revision requests, raise issues to the hosting partners and work with them through the resolution. Map software functionality to business processes and assist in making decisions on the utilization of software programing resources. Design and deliver Enterprise Data Warehouse (EDW) solutions using Informatica power center, Oracle, PL/SQL. Design, develop, test and deploy the extraction, transformation, and loading ETL code using Informatica designer, Informatica workflow manager and Informatica Monitor. Schedule and unschedule the Extract, Transform, Load (ETL) jobs in production environment by setting the correct parameters using Informatica Job Scheduler. Publish scenarios using Informatica power center, Standard Query Language (SQL), and PL/ SQL during the life cycle of the project to help end users access the data warehousing data. Prepare and propose high-level ETL technical designs and design documents and transferring technical design specifications for ETL development using Microsoft Visio & Microsoft Power point. Bug fix, modify and test existing ETL flows and phase containment of defects using Informatica power center, Oracle and PL/SQL. Migrate, implement and support applications in a production environment utilizing Informatica Repository Manager. Optimize and run SQLs for optimizing performance using explain plan method of Oracle SQL developer. Identify, analyze and interpret data, technology trends, and patterns in data sets and developing creative visualizations and dashboards using Cognos and Tableau. Implement the enterprise data warehousing (EDW) project end to end using waterfall, agile and hybrid-agile methodologies.

#LI-DNI

Requirements

  • Bachelor s degree or foreign equivalent degree in Engineering (any), Computer Science, MIS, CIS or a related field.

  • One year of experience as a Solution Specialist, Technical Architect, or a related occupation.

  • Must have one year of experience with:

  • Designing and finalizing the data model of Enterprise Data Warehousing (EDW) tables, and establishing the relations among EDW tables necessary to build the warehousing using ER Studio;

  • Designing and delivering Enterprise Data Warehouse (EDW) solutions using Informatica power center, Oracle, PL/SQL;

  • Designing, developing, testing and deploying the extraction, transformation, and loading ETL code using Informatica designer, Informatica workflow manager and Informatica Monitor;

  • Scheduling and unscheduling the Extract, Transform, Load (ETL) jobs in production environment by setting the correct parameters using Informatica Job Scheduler;

  • Publishing scenarios using Informatica power center, Standard Query Language (SQL), and PL/ SQL during the life cycle of the project to help end users access the data warehousing data;

  • Preparing and proposing high-level ETL technical designs and design documents and transferring technical design specifications for ETL development using Microsoft Visio & Microsoft Power point;

  • Bug fixing, modifying and testing existing ETL flows and phase containment of defects using Informatica power center, Oracle and PL/SQL;

  • Migrating, implementing and supporting applications in a production environment utilizing Informatica Repository Manager;

  • Optimizing and running SQLs for optimizing performance using explain plan method of Oracle SQL developer;

  • Identifying, analyzing and interpreting data, technology trends, and patterns in data sets and developing creative visualizations and dashboards using Cognos and Tableau;

  • Implementing the enterprise data warehousing (EDW) project end to end using waterfall, agile and hybrid-agile methodologies.

  • 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. at http://www2.deloitte.com/us/en/pages/careers/articles/life-at-deloitte-benefits-and-rewards.html

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. at http://www2.deloitte.com/us/en/pages/careers/topics/recruiting-tips.html

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. at http://www2.deloitte.com/us/en/pages/careers/topics/recruiting-tips.html

Category: Management Consulting

About Deloitte

As used in this document, Deloitte means Deloitte LLP and its subsidiaries. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.