Company Description
Company Description
Our culture is defined by our values and our deep commitment to help our clients succeed. We are a division of the 38th largest company in the world and bring to bear the strength of a very large network of interconnected Hitachi companies. At the same time we remain absolutely committed to the nimble agility that helped us grow Hitachi Solutions from three founding partners to nearly 2,000 consultants, developers and support personnel all around the globe.
Hitachi Solutions is a leader in providing industry solutions based on Microsoft Dynamics AX and Microsoft Dynamics CRM. Hitachi Solutions provides its customers with industry focus, software industry domain expertise, and proven tier-1 people. Hitachi Solutions works with its customers to understand their unique formula for success and develops solutions that improve their business and attain measurable results.2011, 2009, 2006 & 2005 Microsoft Dynamics Partner of the Year (Finalist 2008, 2007). Microsoft Global Dynamics Award (Global Dynamics Partner of the year) 2014.
Hitachi Solutions is a core IT company of the Hitachi Group, which employs some 400,000 people worldwide. Through systems integration, we provide ideal solutions and products for customers. Headquartered in Tokyo, Japan, Hitachi Solutions' reach extends to group companies in Japan and abroad, working with a worldwide network of alliance partners. We bring solutions and products to diverse countries and regions including Asia, the United States and Europe. The flagship company in the Hitachi Group's information and communication system solutions business, Hitachi Solutions also offers solutions for social innovation such as smart cities.
For more information on Hitachi Solutions, please visit: https://web.hitachi-solutions.com
Job Description
Senior ETL Developer: 8+ years of experience in ETL, with exposure to EDW/ Data Integration tools :
- Expert knowledge of data warehouse architecture
- Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
- Analyze, Design, Develop and enhance ETL solutions/ data integration projects/ enhancements as assigned
- Troubleshoot, debug and diagnose ETL/ BI data issues
- Have the ability to work with users, BI and ERP teams to get ETL solutions debugged, developed and implemented
- Performance tuning and enhancement of data loads, SQL and ETL processes and prepare related technical documentation
- Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data
- Provide support / triage prod issues within stipulated time frame/ SLAs
- Provide production support related to ETL schedules, tasks and work with other BI/ IT team members and service desk to resolve data refresh issues
- Strong Experience writing / tuning SQL statements
- Strong experience with Oracle PL/ SQL Stored procedures
- Strong experience with ADF and Devops / CI/ CD processes, preferably using Github
- Well versed with database administration tasks and working with DBAs to monitor and resolve SQL / ETL issues and performance tuning
- Strong experience developing software applications as part of a team, employing practical and effective software design concepts.
- Experience in trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
- Preferred with experience working in the Oracle EBS ERP
- Preferred experience in Cognos/ Power BI
- Independent problems solving skills.
- Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management.
- Open to learn and acquire new skills.
Additional Information
Beware of scams
Our recruiting team may communicate with candidates via our @hitachisolutions.com domain email address and/or via our SmartRecruiters (Applicant Tracking System) [email protected] domain email address regarding your application and interview requests.
All offers will originate from our @hitachisolutions.com domain email address. If you receive an offer or information from someone purporting to be an employee of Hitachi Solutions from any other domain, it may not be legitimate.
Top Skills
What We Do
Hitachi Solutions is a global IT consulting and services firm. We are a 100% Microsoft platform focused organization, where people and customers are always our top priority.
Hitachi Solutions' mission has always been “to contribute to society through the development of superior, original technology and products”. That statement of purpose works in tandem with that of Microsoft's mission which is “to empower every person and every organization on the planet to achieve more.”’ Fostering customer evolution is our collective goal.
Industry focused - our team of 3,500+ subject matter experts and professionals from across the globe, build forward thinking and sustainable business modernization solutions. Starting at concept 1 and iterating to an open-ended finish, we ensure that our resting foothold leaves our customers with a springboard platform to adapt, grow and thrive. Empowering those companies to flourish in the ever-changing competitive landscape, through Microsoft technology and business applications.
Hitachi Solutions is part of Hitachi, Ltd. — one of the largest organizations in the entire world. We are fortunate to be a part of our parent company's rich history and extraordinary network of innovators. This internal circuitry allows us osmotic learning from over 850 companies that make up the Hitachi conglomerate, worldwide.
.jpg)
