Data Warehouse (DWH) Jobs in Pune

Job Title/Designation: Technical Manager - Big Data, Data Warehousing, BI Job Description: Location - Pune   Experience - 8 + Years Responsibilities: Responsible to work closely with customer to understand the requirements, discuss and define various use cases Liaise with key stakeholders to define the big data solutions roadmap, prioritize the deliverables Responsible for end to end project delivery of Big Data Solutions from project estimations, project planning, resourcing and monitoring perspective Drive and participate in requirements gathering workshops, estimation discussions, design meetings and status review meetings Participate and contribute in Solution Design and Solution Architecture for implementing Big Data Projects Monitor and review the status of the project and ensure that the deliverables are on track with respect to scope, budget and time Transparently communicate the status of the project to all the stakeholders on a regular basis Identify and manage risks / issues related to deliverables and arrive at mitigation plans to resolve the issues and risks Seek proactive feedback continuously to identify areas of improvement Ensure the team is creating and maintaining the knowledge artifacts with reference to the project deliverables   Mandatory Skills:   Hands on experience in design, development and managing big data technologies Experience of managing projects in the area of Big Data, Data warehousing, Business Intelligence using open source or top of the line tools and technologies Good knowledge of Dimensional Modeling Experience of managing medium to large projects Proven experience in project planning, estimation, execution and implementation of medium to large projects Proficient with various development methodologies like waterfall, agile/scrum and iterative Good Interpersonal skills and excellent communication skills Advanced level Microsoft Project, PowerPoint, Visio, Excel and Word Other Skills:   Knowledge of Big Data ecosystem Business Domain Knowledge Project Management Training/Certification such as PMI's Project Management Professional (PMP) or Certified SCRUM Master

Job Title/Designation: Big Data Engineers - Hadoop, Pig, Hive, Spark Employment Type: Full Time, Permanent Job Description:   Work Location - Pune Work Experience - 2.5 to 6 Years   Note - Candidates with short notice periods will be given preference.   Mandatory Skills: Working knowledge and hands-on experience of Big Data / Hadoop tools and technologies. Experience of working in Pig, Hive, Flume, Sqoop, Kafka etc. Database development experience with a solid understanding of core database concepts, relational database design, ODS & DWH. Expert level knowledge of SQL and scripting preferably UNIX shell scripting, Perl scripting. Working knowledge of Data integration solution and well-versed with any ETL tool (Informatica / Datastage / Abinitio/Pentaho etc). Strong problem solving and logical reasoning ability. Excellent understanding of all aspects of the Software Development Lifecycle. Excellent written and verbal communication skills. Experience in Java will be an added advantage Knowledge of object oriented programming concepts Exposure to ISMS policies and procedures.

What you will do• Develop and maintain CI/CD tools to build and deploy scalable web and responsive applications in production environment• Design and implement monitoring solutions that identify both system bottlenecks and production issues• Design and implement workflows for continuous integration, including provisioning, deployment, testing, and version control of the software.• Develop self-service solutions for the engineering team in order to deliver sites/software with great speed and qualityo Automating Infra creationo Provide easy to use solutions to engineering team• Conduct research, tests, and implements new metrics collection systems that can be reused and applied as engineering best practiceso Update our processes and design new processes as needed.o Establish DevOps Engineer team best practices.o Stay current with industry trends and source new ways for our business to improve.• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.• Manage timely resolution of all critical and/or complex problems• Maintain, monitor, and establish best practices for containerized environments.• Mentor new DevOps engineersWhat you will bring• The desire to work in fast-paced environment.• 5+ years’ experience building, maintaining, and deploying production infrastructures in AWS or other cloud providers• Containerization experience with applications deployed on Docker and Kubernetes• Understanding of NoSQL and Relational Database with respect to deployment and horizontal scalability• Demonstrated knowledge of Distributed and Scalable systems Experience with maintaining and deployment of critical infrastructure components through Infrastructure-as-Code and configuration management tooling across multiple environments (Ansible, Terraform etc)• Strong knowledge of DevOps and CI/CD pipeline (GitHub, BitBucket, Artifactory etc)• Strong understanding of cloud and infrastructure components (server, storage, network, data, and applications) to deliver end-to-end cloud Infrastructure architectures and designs and recommendationso AWS services like S3, CloudFront, Kubernetes, RDS, Data Warehouses to come up with architecture/suggestions for new use cases.• Test our system integrity, implemented designs, application developments and other processes related to infrastructure, making improvements as neededGood to have• Experience with code quality tools, static or dynamic code analysis and compliance and undertaking and resolving issues identified from vulnerability and compliance scans of our infrastructure• Good knowledge of REST/SOAP/JSON web service API implementation•

Consultants will have the opportunity to : - Build a team with skills in ETL, reporting, MDM and ad-hoc analytics support- Build technical solutions using latest open source and cloud based technologies- Work closely with offshore senior consultant, onshore team and client's business and IT teams to gather project requirements - Assist overall project execution from India - starting from project planning, team formation system design and development, testing, UAT and deployment - Build demos and POCs in support of business development for new and existing clients - Prepare project documents and PowerPoint presentations for client communication - Conduct training sessions to train associates and help shape their growth