Data Engineer: Data Warehouse
Pune, INDIA
Job description
Introduction
In this role, you'll work in our IBM Client Innovation Center (CIC), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. These centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology
A career in IBM Consulting is rooted by long-term relationships and close collaboration with clients across the globe.
You'll work with visionaries across multiple industries to improve the hybrid cloud and Al journey for the most innovative and valuable companies in the world. Your ability to accelerate impact and make meaningful change for your clients is enabled by our strategic partner ecosystem and our robust technology platforms across the IBM portfolio; including Software and Red Hat.
Curiosity and a constant quest for knowledge serve as the foundation to success in IBM Consulting. In your role, you'll be encouraged to challenge the norm, investigate ideas outside of your role, and come up with creative solutions resulting in ground breaking impact for a wide network of clients. Our culture of evolution and empathy centers on long-term career growth and development opportunities in an environment that embraces your unique skills and experience.
Your Role and Responsibilities
· Minimum 3 years of experience in developing applications programs to implement the ETL workflow by creating the ETL jobs, data models in datamarts using Snowflake, DBT, Unix, SQL technologies.
· Redesign Control M Batch processing for the ETL job build to run efficiently in Production.
· Study existing system to evaluate effectiveness and developed new system to improve efficiency and workflow.
Responsibilities:
· Perform requirements identification; conduct business program analysis, testing, and system enhancements while providing production support.
· Developer should have good understanding of working in Agile environment, Good understanding of JIRA, Sharepoint tools. Good written and verbal communication skills are a MUST as the candidate is expected to work directly with client counterpart."
Required Technical and Professional Expertise
· Intuitive individual with an ability to manage change and proven time management
· Proven interpersonal skills while contributing to team effort by accomplishing related results as needed
· Up-to-date technical knowledge by attending educational workshops, reviewing publications
Preferred Technical and Professional Expertise
· Responsible to develop triggers, functions, stored procedures to support this effort
· Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems. Assist with design, testing, support, and debugging of new and existing ETL and reporting processes.
· Perform data profiling and analysis using a variety of tools. Troubleshoot and support production processes. Create and maintain documentation.