Staff 2, National Office, Products and Solutions, iLab

Deloitte Consulting LLP seeks a Staff 2, National Office, Products & Solutions, iLab in Atlanta, GA and various unanticipated Deloitte office locations and client sites nationally.

Work You'll Do

Work within product development teams in a scrum (agile) environment to design, develop, test, integrate, and deploy features for new products to address key business issues for clients. Work with cross-functional teams and leadership to identify client requirements and develop innovative end-to-end solutions. Determine the appropriate design methodologies and tool sets needed for each project deliverable. Ensure that each deliverable is in compliance with the established software quality assurance methods and standards. Ensure that each development task and testing procedure is completed within the timeline provided. Seamlessly integrate deliverables with the overall technical infrastructure and conduct intensive code reviews prior to deployment. Maintain a high level code quality through the use of project and code quality management tools. Participate in all aspects of ETL including requirement gathering, creating standard interfaces for operational sources, data cleaning, data load strategies, designing and developing mappings, unit testing, integration testing, regression testing, and UAT in developing and lead building scalable, robust, and efficient ETL systems using Informatica PC and other database servers including SQL Server and SAP HANA. Assist with data integration, data quality management, data validation, and cleanup using relational database management systems including Microsoft SQL Server and Oracle. Design and develop data cleanup routines by utilizing standardized data integrity functions including linking, matching, standardization, transformation, and rationalization. Develop sustainable back-end ETL solutions for data warehousing activities using ETL tools Informatica and Data Services. Build reliable error tracking and handling mechanisms with Informatica. Leverage code profiling tools to assess database infrastructure and optimize performance using SQL. Create processes for defining and documenting data standards and Meta models. Creating blueprints and design documents for BI reports to continue development processes. Design scripts to automate daily backups of source code changes, software release variants, and code sequences using GIT. Prepare and review deployment documentation to support product migration strategies.

#LI-DNI

Requirements

  • Bachelor's Degree or foreign equivalent in Engineering (any), Computer Science, Computer Information Systems, or a related field.
  • Must have one year of experience in providing data management services using ETL tools to clients on behalf of a global consulting company.
  • Must have one year of experience with:
  • Participating in all aspects of ETL including requirement gathering, creating standard interfaces for operational sources, data cleaning, data load strategies, designing and developing mappings, unit testing, integration testing, regression testing, and UAT in developing and building scalable, robust and efficient ETL systems using Informatica PC and other database servers including SQL Server and SAP HANA;
  • Assisting with data integration, data quality management, data validation, and cleanup using relational database management systems including Microsoft SQL Server, and Oracle;
  • Designing and developing data cleanup routines by utilizing standardized data integrity functions including linking, matching, standardization, transformation, and rationalization;
  • Developing sustainable back-end ETL solutions for data warehousing activities using ETL tools Informatica and Data Services;
  • Building reliable error tracking and handling mechanisms with Informatica;
  • Leveraging code profiling tools to assess database infrastructure and optimize performance using SQL;
  • Creating processes for defining and documenting data standards and Meta models;
  • Creating blueprints and design documents for BI reports to continue development processes;
  • Designing scripts to automate daily backups of source code changes, software release variants, and code sequences using GIT; and
  • Preparing and reviewing deployment documentation to support product migration strategies.

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: XGGS18FC0717ATL1


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