Consultant – Global Employer Services Technology Center (GESTC) – SQL,SSIS,ETL
Deloitte Tax Services India Private Limited (“Deloitte Tax in India”) commenced operations in June 2004. Since then, nearly all of the Deloitte Tax LLP (“Deloitte Tax”) U.S. service lines and regions have obtained support services through Deloitte Tax in India.
We provide support through the tax transformation taking place in the marketplace. We offer a broad range of fully integrated tax services by combining technology and tax technical resources to uncover insights and smarter solutions for navigating an increasingly complex global environment.
We provide opportunities to transform tax operations using contemporary technologies in the market. Individuals work to transform their current state of tax to the next generation of tax functions. Are you ready to take the next step in your career to find new methods and processes to assist clients in improving their tax operations using new technologies? If the answer is “Yes,” come join Global Employer Services Technology Center (GESTC)
Job purpose :
You will be part of a team dedicated to delivering essential technology solutions for business travelers, supporting the company's ongoing growth. The ideal candidate will have a minimum of two years’ experience in application implementation and/or support, with a solid understanding of the software development lifecycle (SDLC). Proficiency in SQL, requirements gathering, solution development, and documentation is required. Good to have ETL knowledge with tools like SSIS. This position demands excellent written and verbal communication skills.
Key job responsibilities :
- · Participates in requirements gathering sessions with business stakeholders and engagement teams, documents end-user requirements for data capture, data quality, reports and analysis, and training.
- · Implementing business logic using SQL
- · Good experience working with SQL databases, complex joins, stored procedures, functions, views, triggers
- · Creating automation reports, ETL task using tools like SSIS
· Manage issues to resolution using a ticket management tool
· Providing solution to real time challenges
· Assist with System Integration Testing (SIT), User Acceptance Testing (UAT)
· Identifies and documents system deficiencies and recommends solutions.
- · Act as a functional expert on internal systems, possessing a deep understanding of the system's functionality. This role involves translating business requirements into system features and assessing the impact of these changes on previously implemented releases. Additionally, it requires staying informed about updates and ensuring seamless integration of new features.
- · Collaborate with cross-functional teams including development, QA and infrastructure
- · Monitor systems and alerts to ensure availability and timely incident/production issue resolution
Education/Background:
UG: B.E/BTech
PG: NA.
Key skills desired
- 3-4 years of experience with the Software Development Life Cycle (SDLC)
- Skills: Must have – SQL (Advanced proficiency)
- 2-3 years of experience supporting complex Applications/Systems
- 1-3 years of experience in developing ETL solutions using tools like SSIS
- 1 to 2 years of Dotnet Experience
- Experience with Web Services and Rest APIs and troubleshooting service call errors
- Experience with Postman, ADO
- Strong Analytics, reasoning, and critical thinking skills
- Good to have any reporting tool experience (SSRS, QlikView, Tableau)