Business Intelligence Data Warehouse Consultant

Location

Pune | India

Job description

Job Description

Experience - 7 +

Roles and Responsibilities -

Candidate would be responsible for developing various features and provide business solutions. Should be result oriented. Needs to groom the team members and should have sound technical understanding of Data warehousing, ETL and Business Intelligence related concepts and technologies. Should be able to properly assess effort and size of work. Should be able to drive and mature teams. Should have good client and stakeholder management skills.

Primary Responsibilities:

• Lead/Manage a team of developers/QA on both new development and issue fixing.
• Engage in hands-on technical design discussions and advise/unblock developers when they hit roadblocks.
• Ensure high quality code via design reviews and code reviews. Who we are: Incorporated in 2010, Futran Solutions is a specialized provider of digital technology solutions focused on Data Analytics, Cloud, Automation and New Age App Development. We believe in simplicity and agility. Our 'Make it Ez' framework and accelerators enable our clients to realize business value faster through rapid development, intelligent automation, and cloud adoption. Futran is headquartered in Edison, New Jersey, and has a global delivery center in Hyderabad, India. With a strong belief in 'Firgun' philosophy, Futran is a leading supporter of many community services, especially uplifting young, deserving talent. Specialties: Futran specializes in digital with 100% of its revenue from digital solutions. With a startup culture and product mindset, Futran has always adopted agile and lean way of working. Futran has a meritocratic, self-reliant, empowering culture that puts talent ahead of everything else, resulting into greater talent retention and productivity. For more details visit our website: Go to LinkedIn: About Futran Solutions Pvt. Ltd. Job Description for the Positions of DWBI
• Project planning and tracking based on business needs.
• Work breaks down, Estimation, Defect management.
• Hands on coding/PoC as per project needs
• Client management and interfacing.

Required Experience/Skills

• Should have good understanding of dimensional modeling, ETL architecture, Deployment process.
• Must have expertise Power BI, ADF (Data factory, data bricks)
• Should have experience in designing solutions and understanding of developing and delivering an end-to-end DW pipeline independently.
• Should have led a small to medium sized team.
• Should have strong experience with DB stored procs, complex SQLs, views and other concepts.
• Should have solid hands-on experience in writing complex queries and good hand-on on performance tuning.
• Good Data modeling experience
• Test Data setup for various business scenarios to be tested

Required Competencies.

• Strong analytical and problem-solving skills.
• Excellent verbal and written communication skills.
• Excellent interpersonal skills.
• Good Client interaction skills
• Disciplined and track things closely.
• Detailed oriented and strong work ethics

Job tags

Salary