11+ Data archiving Jobs in India

Job Description – Developer (ETL + Database)

 Develop, document & Support ETL mappings, Database structures & BI reports.

 Perform unit testing of developments done by him/her.

 Participate in UAT process and ensure quick resolution of any UAT issue.

 Manage different environments and be responsible for proper deployment of code in all client

environments.

 Prepare release documents.

 Prepare and Maintain project documents as advised by Team Leads.

Skill-sets:

 3+ years of Hands on experience on ETL Pentaho Spoon Talend & MS SQL Server, Oracle & SYBASE Database tools.

 Ability to write complex SQL and database procedures.

 Good knowledge and understanding regarding Data warehouse Concepts, ETL Concepts, ETL

Loading Strategies, Data archiving, Data Reconciliation, ETL error handling etc.

 Problem Solving.

 Good communication skills – written and verbal.

 Self-motivated, team player, action and result oriented.

 Ability to successfully work under tight project schedule

Job Description: 

We are looking for an experienced SQL Developer to become a valued member of our dynamic team. In the role of SQL Developer, you will be tasked with creating top-notch database solutions, fine-tuning SQL databases, and providing support for our applications and systems. Your proficiency in SQL database design, development, and optimization will be instrumental in delivering efficient and dependable solutions to fulfil our business requirements.

Responsibilities:

 ● Create high-quality database solutions that align with the organization's requirements and standards.

● Design, manage, and fine-tune SQL databases, queries, and procedures to achieve optimal performance and scalability.

● Collaborate on the development of DBT pipelines to facilitate data transformation and modelling within our data warehouse.

● Evaluate and interpret ongoing business report requirements, gaining a clear understanding of the data necessary for insightful reporting.

● Conduct research to gather the essential data for constructing relevant and valuable reporting materials for stakeholders.

● Analyse existing SQL queries to identify areas for performance enhancements, implementing optimizations for greater efficiency.

● Propose new queries to extract meaningful insights from the data and enhance reporting capabilities.

● Develop procedures and scripts to ensure smooth data migration between systems, safeguarding data integrity.

● Deliver timely management reports on a scheduled basis to support decision-making processes.

● Investigate exceptions related to asset movements to maintain accurate and dependable data records.

Duties and Responsibilities: 

● A minimum of 3 years of hands-on experience in SQL development and administration, showcasing a strong proficiency in database management.

● A solid grasp of SQL database design, development, and optimization techniques.

● A Bachelor's degree in Computer Science, Information Technology, or a related field.

● An excellent understanding of DBT (Data Build Tool) and its practical application in data transformation and modelling.

● Proficiency in either Python or JavaScript, as these are commonly utilized for data-related tasks.

● Familiarity with NoSQL databases and their practical application in specific scenarios.

● Demonstrated commitment and pride in your work, with a focus on contributing to the company's overall success.

● Strong problem-solving skills and the ability to collaborate effectively within a team environment.

● Excellent interpersonal and communication skills that facilitate productive collaboration with colleagues and stakeholders.

● Familiarity with Agile development methodologies and tools that promote efficient project management and teamwork.

🚀 Exciting Opportunity: Data Engineer Position in Gurugram 🌐

Hello 

We are actively seeking a talented and experienced Data Engineer to join our dynamic team at Reality Motivational Venture in Gurugram (Gurgaon). If you're passionate about data, thrive in a collaborative environment, and possess the skills we're looking for, we want to hear from you!

Position: Data Engineer  

Location: Gurugram (Gurgaon)  

Experience: 5+ years 

Key Skills:

- Python

- Spark, Pyspark

- Data Governance

- Cloud (AWS/Azure/GCP)

Main Responsibilities:

- Define and set up analytics environments for "Big Data" applications in collaboration with domain experts.

- Implement ETL processes for telemetry-based and stationary test data.

- Support in defining data governance, including data lifecycle management.

- Develop large-scale data processing engines and real-time search and analytics based on time series data.

- Ensure technical, methodological, and quality aspects.

- Support CI/CD processes.

- Foster know-how development and transfer, continuous improvement of leading technologies within Data Engineering.

- Collaborate with solution architects on the development of complex on-premise, hybrid, and cloud solution architectures.

Qualification Requirements:

- BSc, MSc, MEng, or PhD in Computer Science, Informatics/Telematics, Mathematics/Statistics, or a comparable engineering degree.

- Proficiency in Python and the PyData stack (Pandas/Numpy).

- Experience in high-level programming languages (C#/C++/Java).

- Familiarity with scalable processing environments like Dask (or Spark).

- Proficient in Linux and scripting languages (Bash Scripts).

- Experience in containerization and orchestration of containerized services (Kubernetes).

- Education in database technologies (SQL/OLAP and Non-SQL).

- Interest in Big Data storage technologies (Elastic, ClickHouse).

- Familiarity with Cloud technologies (Azure, AWS, GCP).

- Fluent English communication skills (speaking and writing).

- Ability to work constructively with a global team.

- Willingness to travel for business trips during development projects.

Preferable:

- Working knowledge of vehicle architectures, communication, and components.

- Experience in additional programming languages (C#/C++/Java, R, Scala, MATLAB).

- Experience in time-series processing.

How to Apply:

Interested candidates, please share your updated CV/resume with me.

Thank you for considering this exciting opportunity.

• Strong Knowledge in Oracle Forms and Reports
• Should be familiar with various triggers, events , canvas, master child forms, record groups , build-ins, properties etc., in Forms and reports
• Strong Knowledge in SQL / PLSQL concepts
• Strong in Analytical and Aggregate functions
• Strong in writing Procedure / Function / Packages
• Strong knowledge in the user of Cursors / Collections / Exception handling
• Strong in Datatypes, Constrainsts , index
• Having exposure to JavaScript and ReactJS will be an added advantage

Required:
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have:
1) Experience in SAP BO / Crystal report / SSRS / Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities:

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another

JD – Attached Sample Profile for Reference

1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have
1) Experience in SAP BO / Crystal report /SSRS/ Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another

• Minimum 3 years of working experience in database related projects.
• Working experience on any of the leading Database management systems viz., Oracle,SQL-Server, etc. (Experience on Postgres database systems will be an added advantage).
• Adequate Database Development skills & should be proficient in SQL coding.
• Working experience in Database SQL Optimization/Performance Tuning.
• Working experience on any of the Database Programming languages viz., PL/SQL, PL/pgSQL,T-SQL,etc.
• Flexible to learn, adopt & scale to any data centric technologies as per the evolving Organizational product strategies.

• Good to have skill sets of the Candidate:
• Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts.
• Working experience on Data Analytics/Reporting/ETL or exhibits sound knowledge over the concepts.
• Database agnostic approach to data/database solutions.
• Exhibits sound knowledge on Big-data/Hadoop, Kafka, Map-Reduce programming, NoSQL,etc.

•   Minimum of 12 years of Experience with Informatica ETL, Database technologies.
•   Experience with  Azure database technologies including Azure SQL Server, Azure Data Lake Exposure to Change data capture technology Lead and guide development of an Informatica based ETL architecture.
•      Develop solution in highly demanding environment and provide hands on guidance to other team members. 
•      Head complex ETL requirements and design. 
•      Implement an Informatica based ETL solution fulfilling stringent performance requirements. 
•      Collaborate with product development teams and senior designers to develop architectural requirements for the requirements.
•      Assess requirements for completeness and accuracy. 
•      Determine if requirements are actionable for ETL team. 
•      Conduct impact assessment and determine size of effort based on requirements.
•      Develop full SDLC project plans to implement ETL solution and identify resource requirements.
•      Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture and Identify, recommend and implement ETL process and architecture improvements.
•      Assist and verify design of solution and production of all design phase deliverables. 
•      Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture

Roles and Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation, including Patch Management and Version Control. Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database/application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24x7 support when required.
• Perform general technical troubleshooting and give consultation to development teams.
• Interface with Oracle Corporation for technical support.
• Analyse potential impact of problem resolution and take corrective measures when needed.
• Root Cause Analysis.

Education, Skills and Experience required:

• Engineering or Technical Degrees (BE/ B.Tech/ ME/ M.Tech/ M.Sc / MCA)
• Minimum 4 years of relevant industry experience.
• Must have experience on multiple Hardware and Software Environments and be comfortable with complex heterogeneous systems environments.
• Must be an Oracle Certified Professional DBA (11g or above) with hands-on experience of RAC, RMAN.
• Good understanding of the Oracle database, related utilities and tools and underlying operating system.
• Excellent knowledge of the physical database design and all Oracle backup and recovery scenarios.
• Developing, managing and testing back-up and recovery plans. Data archival and space management.
• Ability to perform both Oracle and operating system performance tuning and monitoring.
• Good knowledge of Oracle security management and Oracle data integrity.
• Experience in code/data migration, database change management and data management through the various stages of the development life cycle.
• Sound knowledge of both database and system performance tuning and implemented application systems.
• Should have the ability to handle multiple projects and deadlines.
• Male candidates preferred as the role requires working in shifts.