11+ Oracle Warehouse Builder Jobs in India

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.

Role Summary

As a Data Engineer, you will be an integral part of our Data Engineering team supporting an event-driven server less data engineering pipeline on AWS cloud, responsible for assisting in the end-to-end analysis, development & maintenance of data pipelines and systems (DataOps). You will work closely with fellow data engineers & production support to ensure the availability and reliability of data for analytics and business intelligence purposes.

Requirements:

·      Around 4 years of working experience in data warehousing / BI system.

·      Strong hands-on experience with Snowflake AND strong programming skills in Python

·      Strong hands-on SQL skills

·      Knowledge with any of the cloud databases such as Snowflake,Redshift,Google BigQuery,RDS,etc.

·      Knowledge on debt for cloud databases

·      AWS Services such as SNS, SQS, ECS, Docker, Kinesis & Lambda functions

·      Solid understanding of ETL processes, and data warehousing concepts

·      Familiarity with version control systems (e.g., Git/bit bucket, etc.) and collaborative development practices in an agile framework

·      Experience with scrum methodologies

·      Infrastructure build tools such as CFT / Terraform is a plus.

·      Knowledge on Denodo, data cataloguing tools & data quality mechanisms is a plus.

·      Strong team player with good communication skills.

Overview Optisol Business Solutions

OptiSol was named on this year's Best Companies to Work for list by Great place to work. We are a team of about 500+ Agile employees with a development center in India and global offices in the US, UK (United Kingdom), Australia, Ireland, Sweden, and Dubai. 16+ years of joyful journey and we have built about 500+ digital solutions. We have 200+ happy and satisfied clients across 24 countries.

Benefits, working with Optisol

·      Great Learning & Development program

·      Flextime, Work-at-Home & Hybrid Options

·      A knowledgeable, high-achieving, experienced & fun team.

·      Spot Awards & Recognition.

·      The chance to be a part of next success story.

·      A competitive base salary.

More Than Just a Job, We Offer an Opportunity To Grow. Are you the one, who looks out to Build your Future & Build your Dream? We have the Job for you, to make your dream comes true.

Job Description - Jasper 

• Knowledge of Jasper report server administration, installation and configuration
• Knowledge of report deployment and configuration
• Knowledge of Jaspersoft Architecture and Deployment
• Knowledge of User Management in Jaspersoft Server
• Experience in developing Complex Reports using Jaspersoft Server and Jaspersoft Studio
• Understand the Overall architecture of Jaspersoft BI
• Experience in creating Ad Hoc Reports, OLAP, Views, Domains
• Experience in report server (Jaspersoft) integration with web application
• Experience in JasperReports Server web services API and Jaspersoft Visualise.JS Web service API
• Experience in creating dashboards with visualizations
• Experience in security and auditing, metadata layer
• Experience in Interacting with stakeholders for requirement gathering and Analysis
• Good knowledge ETL design and development, logical and physical data modeling (relational and dimensional)
• Strong self- initiative to strive for both personal & technical excellence.
• Coordinate efforts across Product development team and Business Analyst team.
• Strong business and data analysis skills.
• Domain knowledge of Healthcare an advantage.
• Should be strong on Co- ordinate with onshore resources on development.
• Data oriented professional with good communications skills and should have a great eye for detail.
• Interpret data, analyze results and provide insightful inferences
• Maintain relationship with Business Intelligence stakeholders
• Strong Analytical and Problem Solving skills 

About the co.– Our client is an agency of the world’s largest media investment company which is a part of WPP. It is a global digital transformation agency with 1200 employees across 21 nations. Our team of experts support clients in programmatic, social, paid search, analytics, technology, organic search, affiliate marketing, e-commerce and across traditional channels. 

Job Location: Gurgaon

Reporting of the role This role reports to the Technology Architect,

Key Accountabilities: This role is for a Technical Specialist who can understand and solves complex functional, technical, and architectural practices that cover data and can understand the end-to-end data lifecycle capabilities and technologies and provide architectural guidance in the selection, articulation, and use of the chosen solutions.

The successful candidate will be expected to interact with all levels of the business and technical community, seeking strong engagement with all stakeholders. The candidate should be an expert in functional data architecture & design, including strong data modelling. A candidate who is self-disciplined, with a keenness to master, suggest, and work with different technologies & toolsets. The role would also involve intensive interaction with the business and other technology functions, so good communication skills and the ability to work under pressure is essential

What you’ll bring:

 5-7 years of strong experience in working with SQL, Python, ETL development, and AWS.

 Strong Experience in writing complex SQLs

 Good Communication skills  Work with senior staff and business leaders to identify requirements for data/information across the core business domains

 Work with Project Managers Business Analysts and other subject matter experts to identify and understand requirements

 Good experience working with any BI tool like Tableau, or Power BI.  Familiar with various cloud technologies and their offerings within data specialization and Data Warehousing.

 Snowflake is good to have. 

Minimum qualifications:

 B. Tech./MCA preferred

 Excellent 5 years Hand on experience in Big data, ETL Development, and Data Processing

Regards

Team Merito

•   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

https://www.srclogix.com/">SourceLogix  - is a California based software development company. Founded in 2007, we have successfully built our client base with our values: Talent. Team. Trust.

SourceLogix experts help Fortune 500 clients in the areas of SaaS, eCommerce, VoIP, CRM, Transaction systems & Predictive Analytics.

Our CRM solutions division is the best-in-class salesforce consulting team that helps customers with their CRM challenges such as integrating CRM to other platforms. Homegrown tools or cloud-based apps: ERP, Billing systems, telephony & chat apps, productivity and collaboration apps. We also help our customers with data cleansing, governance, and meaningful metrics and dashboarding.

We are looking for a Certified Salesforce developer with 5 years of experience. Your primary focus will be to develop all salesforce interface components and implement them following well-known APEX. 

You will work with our team and end clients to ensure that the customer requirements are understood and implemented as expected. You will coordinate with the rest of the CRM team and demonstrate: collaborative, problem solving, sophisticated design and build a solution per client’s requirements.

• Salesforce certifications (Salesforce Certified Platform Developer I or II). - Must have
• Bachelor's degree in computer science or other related disciplines.
• Passion for creating and delivering great software with a strong sense of ownership. 
• Strong knowledge of JSON, XML, JavaScript, CSS2 & CSS3, HTML5 &  jQuery.
• Over three years of experience in building salesforce applications using APEX, VisualForce, Native, MySQL,and JavaScript.
• Demonstrated experience working with relational databases, and ETL tools.
• Familiarity with the Lightning component framework.
• Independently develop new user-facing features from designs and wireframes.
• Proficient in Version Control Software such as GIT, Bitbucket.
• Ability to understand business requirements and translate them into technical requirements.
• Strong organizational skills. Ability to prioritize tasks and work in a dynamic fast-changing environment.

• Knowledge of modern authorization mechanisms, such as JSON Web Token.
• Knowledge of the AWS platform and scalable application architecture.
• Experience with CI/CD - Build & Release process. Agile/ Scrum based development..

• Collaborate with different departments and resources to translate business needs to requirements.
• Create user documentation for all the code built.
• Configuration and customization of the client’s salesforce.com platform.
• Translate design and wireframe into high-quality code.
• Create documentation such as requirements, test cases, and test scripts.
• Diligently work on resolving reported issues and document root-cause analysis.
• Optimize components for maximum performance across a vast array of devices & browsers.
• Be responsive to change, adapt quickly with a talented team and work efficiently & remotely.
•  

• Competitive salary - based on experience.
• 100% remote work. All you need is a good laptop, headset, and internet connectivity.
• Ability to make a direct impact & build an award-winning Salesforce platform.
• Awesome culture! We are a friendly & collaborative team with a learning and growth mindset.