11+ Database analysis Jobs in Pune | Database analysis Job openings in Pune

• 6-8 years direct experience as a SQL Developer.
• 3+ years’ experience in ETL tools like SSIS, SSRS- Reports
• Proven Microsoft T-SQL skills.
• 3+ years of Data Analysis in a financial institution is preferred.
• Demonstrated knowledge of large, relational databases and data structures.
• Strong experience in database security
• Strong understanding of ETL concepts.
• Proficient in standard business and database software including: MS Office, MS Access, and SSMS.
• Experience with Agile using JIRA software, Confluence or combination of both.

Key skills : Python, Numpy, Panda, SQL, ETL 

Roles and Responsibilities:

- The work will involve the development of workflows triggered by events from other systems

- Design, develop, test, and deliver software solutions in the FX Derivatives group

- Analyse requirements for the solutions they deliver, to ensure that they provide the right solution

- Develop easy to use documentation for the frameworks and tools developed for adaption by other teams

Familiarity with event-driven programming in Python

- Must have unit testing and debugging skills

- Good problem solving and analytical skills

- Python packages such as NumPy, Scikit learn

- Testing and debugging applications.

- Developing back-end components.

Enterprise Data Architect - Dataeconomy (25+ Years Experience)

About Dataeconomy:

Dataeconomy is a rapidly growing company at the forefront of Information Technology. We are driven by data and committed to using it to make better decisions, improve our products, and deliver exceptional value to our customers.

Job Summary:

Dataeconomy seeks a seasoned and strategic Enterprise Data Architect to lead the company's data transformation journey. With 25+ years of experience in data architecture and leadership, you will be pivotal in shaping our data infrastructure, governance, and culture. You will leverage your extensive expertise to build a foundation for future growth and innovation, ensuring our data assets are aligned with business objectives and drive measurable value.

Responsibilities:

Strategic Vision and Leadership:

Lead the creation and execution of a long-term data strategy aligned with the company's overall vision and goals.

Champion a data-driven culture across the organization, fostering cross-functional collaboration and data literacy.

Advise senior leadership on strategic data initiatives and their impact on business performance.

Architecture and Modernization:

Evaluate and modernize the existing data architecture, recommending and implementing innovative solutions.

Design and implement a scalable data lake/warehouse architecture for future growth.

Advocate for and adopt cutting-edge data technologies and best practices.

ETL Tool Experience (8+ years):

Extensive experience in designing, developing, and implementing ETL (Extract, Transform, Load) processes using industry-standard tools such as Informatica PowerCenter, IBM DataStage, Microsoft SSIS, or open-source options like Apache Airflow.

Proven ability to build and maintain complex data pipelines that integrate data from diverse sources, transform it into usable formats, and load it into target systems.

Deep understanding of data quality and cleansing techniques to ensure the accuracy and consistency of data across the organization.

Data Governance and Quality:

Establish and enforce a comprehensive data governance framework ensuring data integrity, consistency, and security.

Develop and implement data quality standards and processes for continuous data improvement.

Oversee the implementation of master data management and data lineage initiatives.

Collaboration and Mentorship:

Mentor and guide data teams, including architects, engineers, and analysts, on data architecture principles and best practices.

Foster a collaborative environment where data insights are readily shared and acted upon across the organization.

Build strong relationships with business stakeholders to understand and translate their data needs into actionable solutions.

Qualifications:

Education: master’s degree in computer science, Information Systems, or related field; Ph.D. preferred.

Experience: 25+ years of experience in data architecture and design, with 10+ years in a leadership role.

Technical Skills:

Deep understanding of TOGAF, AWS, MDM, EDW, Hadoop ecosystem (MapReduce, Hive, HBase, Pig, Flume, Scoop), cloud data platforms (Azure Synapse, Google Big Query), modern data pipelines, streaming analytics, data governance frameworks.

Proficiency in programming languages (Java, Python, SQL), scripting languages (Bash, Python), data modelling tools (ER diagramming software), and BI tools.

Extensive expertise in ETL tools (Informatica PowerCenter, IBM DataStage, Microsoft SSIS, Apache Airflow)

Familiarity with emerging data technologies (AI/ML, blockchain), data security and compliance frameworks.

Soft Skills:

Outstanding communication, collaboration, and leadership skills.

Strategic thinking and problem-solving abilities with a focus on delivering impactful solutions.

Strong analytical and critical thinking skills.

Ability to influence and inspire teams to achieve goals.

ROLE DESCRIPTION

The ideal candidate will be passionate about building resilient, scalable, and high-performance distributed systems products. This individual will thrive and succeed in delivering high-quality technology products in a fast-paced and rapid growth environment where priorities could shift quickly. We are looking for an engineer who prioritizes well, communicates clearly, and understands how to drive a high level of focus and excellence within a strong team. This person has an innate drive to build a culture centered on customer focus, efficient execution, high quality, rigorous testing, deep monitoring, and solid software engineering practices.

WHO WILL LOVE THIS JOB?

• Attracted to creativity, innovation, and eagerness to learn.

• Alignment to a fast-paced organization and its short-term and long-term goals.

• An engaging, open, genuine personality that naturally encourages interaction with individuals at all levels. • Strong value system and sense of ethics.

• Absolute dedication to premium quality.

• Want to build a strong core product team capable of developing solutions for complex, industry-first problems

• Build a balance of experience, knowledge and new learnings

ROLE & RESPONSIBILITIES

• Driving the success of the software engineering team at Datamotive.

• Driving go-nogo decisions of product releases to customers.

• Drive QE team for developing test scenarios & product automation.

• Collaborating with senior and peer engineers to identify and improve upon feature improvements.

• Build a strong customer focussed mindset for qualifying product features and use cases.

• Develop, Build & Perform functional, scale and performance testing.

• Assist in Identifying, Researching & Designing newer features and cloud platform support in areas of disaster recovery, data protection, workload migration etc.

• Conduct pilot tests to assess the functionality of newly developed programs.

• Front-facing customers for product introduction, knowledge transfer, solutions, bug triaging etc.

• Assist customers by giving product demos, conducting POCs, training etc.

• Manage Datamotive infrastructure, bringing innovative automation for optimizing infrastructure usage through monitoring and scripting. 

• Design test environments to simulate customer behaviors and use cases in VMware vSphere, AWS, GCP, and Azure clouds.

• Help write technical documentation, and generate marketing content like blogs, webinars, seminars etc.

TECHNICAL SKILLS

• 8 - 12 years of experience in software testing with a relevant domain understanding of Data Protection, Disaster Recovery, and Ransomware Recovery.

• A strong understanding and demonstrable experience with at least one of the major public cloud platforms (GCP, AWS, Azure or VMware)

• A strong understanding and experience in qualifying complex, distributed systems at feature, scale and performance.

• Insights into the development of client-server SaaS applications with good breadth across networking, storage, micro-services, and other web technologies.

• Programming knowledge in either Python, Shell scripts or Powershell.

• Strong knowledge of test automation frameworks E.g. Selenium, Cucumber, and Robot frameworks

• Should be a computer science graduate with strong fundamentals & problem-solving abilities.

• Good understanding of virtualization, storage and cloud platforms like VMware, AWS, GCP, Azure and/or Kubernetes will be preferable.

WHAT’S IN IT FOR YOU?

• Impact. Backed by our TEAM, Investors and Advisors, Datamotive is on the path to rapid growth. As we take our products to the market, your position will be vital as you play a crucial role in innovating and developing our products, identifying new features, and filing patents, while also gaining personal experience and responsibilities. As a key player in our company's success, the impact of your work will be felt as we grow as an organization.

• Career Growth. At Datamotive, we highly value the input made by each employee to help us achieve our company goals. To this end, we strive to ensure that everyone has access, and exposure to be up-to-date in the industry, and to learn and improve their expertise. We ensure that each employee is given exposure to understanding the functional and technical elements of our products as well as all related business functions. As your knowledge grows, so do the opportunities for advancement to more senior opportunities or into other areas of our business. We strive to be a company where you can truly chart out a career path for yourself.

We are looking for a Ruby on Rails developer responsible for managing the interchange of data between the server and the users. Your primary focus will be development of all server-side logic, definition and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. You will also be responsible for integrating the front-end elements built by your co-workers into the application. Therefore, a basic understanding of front-end technologies is necessary as well.

Responsibilities:

• Design, build, and maintain efficient, reusable, and reliable Ruby code.
• Integration of data storage solutions (may include databases, key-value stores, blob stores, etc. )
• Integration of user-facing elements developed by front-end developers with server side logic.
• Identify bottlenecks and bugs, and devise solutions to these problems.

Requirements:

• Bachelor's Degree or Master's in Computer Science, Engineering, Software Engineering or a relevant field.
• More than 3 years of experience in a ROR Developer (or similar role); experience in software development and infrastructure development is a plus
• Experience with Ruby on Rails, along with other common libraries such as RSpec and Resque.
• Good understanding of the syntax of Ruby and its nuances.
• Solid understanding of object-oriented programming.
• Good understanding of server-side templating languages (such as Liquid, Slim, etc depending on your technology stack).
• Good understanding of server-side CSS preprocessors (such as Sass, based on project requirements).
• Basic understanding of front-end technologies, such as JavaScript, HTML5 and CSS3
• Familiarity with concepts of MVC, Mocking, ORM, and RESTful.
• A knack for writing clean, readable Ruby code.

• Participate in requirements analysis
• Collaborate with internal teams to produce software design and architecture
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code
• Improve existing software
• Develop documentation throughout the software development life cycle (SDLC)
• Serve as an expert on applications and provide technical support.

• Requirements

  • Proven experience as a .NET Developer or Application Developer
  • Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
  • Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
  • Familiarity with architecture styles/APIs (REST, RPC)
  • Understanding of Agile methodologies
  • Excellent troubleshooting and communication skills

Roles and responsibilities

• • Develop well-designed, performant and scalable microservices
  • Write reusable, testable, and efficient code that follow software development best practices
  • Integrate data storage solutions including databases, key-value stores, blob stores, etc.
  • Expose business functionality to frontend/mobile applications and partner systems through secure and scalable APIs.
  • Build integrations with 3rd party applications through apis’ to ingest and process data
  • Ensure security and data protection aspects within the applications
  • Contribute to devops by building CD/CI pipelines to automate releases
  • Ensure high performance and availability of distributed systems and applications
  • Interact directly with client project team members and operational staff to support live customer deployments and production issues.

• 4+ years of experience in developing applications using Scala and related technologies.
• Thorough understanding of multithreading concepts and async execution using Actor model.
• Thorough understanding of Play framework, GraphQL and GRPC technologies.
• Experience in using DAL and ORM (Object Relational Mapper) libraries for data access.
• Experiencing in developing and hosting APIs and integration with external applications.
• Experience in building data models and repositories using relational and NoSql databases.
• Knowledge of JIRA, Bitbucket and agile methodologies.
• Good to have knowledge of AWS services like Lambda, dynamodb, kinesis and others.
• Understanding of fundamental design principles behind a scalable application.
• Familiarity with event-driven programming and distributed architectures.
• Strong unit test and debugging skills
• Affinity for learning and applying new technologies and solving new problems
• Effective organizational skills with strong attention to detail
• Experience in working with docker is a plus
• Comfortable in working with Unix/Linux environment
• Strong communication skills — both written and verbal