Who are we:
Fulcrum Digital is an agile and nextgeneration digital accelerating company providing digital transformation and technology services right from ideation to implementation. These services have applicability across a variety of industries including banking & financial services insurance retail higher education food healthcare and manufacturing.
Primary Skills SQL ETL Python Data Pipelines Google Data lakes Data warehouse
Secondary Skills .net Web Development
Techincal Skills
Experience with SQL Server SQL relational database etc. 3 to 5 years Required
Ability to recognize past issue patterns and apply them to the existing problem resolution process
Selfmotivated team player with the ability to work and mentor junior resources in different regions Ability to work with the other groups and lead the ETL solution
Excellent Analytical problemsolving written and oral communication skills
Experience with Google Data lakes and Data warehouse 2 years
Experience with Data Pipelines ETL process 34 yrs
Comfortable working with complex ETL solutions and large data sets
Organized with Strong written and Verbal communication skills
Familiar with Jira Confluence and Agile Processes
Requirements
- A strong understanding of common data integration requirements
- Study and Identifying source Data Points and Data Elements from Data Lakes and Data Warehouse for AI/ ML Solutions and Dashboard Reports
- Work with business customers BA Google AI Architect and IT managers in understanding the business requirements and translating to solution design
- Must have detailed knowledge of data warehouse technical architectures data modelling infrastructure components Data Pipelines ETL/ ELT and reporting/ analytic tools and environments data structures and handson SQL coding.
- Map data fields between systems to ensure accurate and consistent information flow. Perform ad hoc analysis using SQL to extract data sets
- Implement data transformations to facilitate compatibility between different data structures.
- Create configure test deploy and maintain jobs for inbound and outbound processing
- Develop new or improve the existing ETL solutions as the company & data grow
- Develop and implement APIs and other protocols for integrating with custom solution based on project needs.
- Develop and integrate with Web Pages as needed using Web technologies (.NET) would be added advantage (not mandatory)
- Conduct integration testing to ensure that connected systems operate harmoniously.
- Ensure compliance with security standards and protocols.
- Must have worked on large IT project delivery using Agile framework.
- Must have strong grasp of SQL Scripting and Python programming language.
Primary Skills - SQL, ETL, Python, Data Pipelines, Google Data lakes, Data warehouse Secondary Skills - .net Web Development