Role and responsibilities
· Collect requirements, design, develop and test software code.
· Fix bugs and provide production support.
· Prioritize multiple tasks and manage time effectively.
· Learn new technologies outside his/her primary skills.
· Develop solutions to challenging problems.
· Effectively communicate with team members, project managers and clients, as required.
Technical skills requirements
The candidate must demonstrate proficiency in,
· SQL, PL-SQL & RICE Components.
· Develop applications, reports and interfaces using standard Oracle development methodologies.
· BI Publisher, RDF/XML & Discoverer Reports.
· Form Personalizations.
· Unit test the reports with standard E-Business suite application.
· Performance Tuning & Optimization.
· Table-level technical knowledge of OM, Inventory Management, Purchasing, GL, AR, AP, and FA.
· SQL Developer, TOAD, SQL Loader
Nice-to-have skills
· SQL Tuning
· EBS Finance/SCM functional knowledge
· Performance Improvements and External Integrations
· Ability to develop applications and modules keeping scalability and performance in mind.
About Strawberry Infotech Pvt. Ltd.
Similar jobs
About Us:
Cognitio Analytics is an award-winning, niche service provider that offers digital transformation solutions powered by AI and machine learning. We help clients realize the full potential of their data assets and the investments made in related technologies, be it analytics and big data platforms, digital technologies or your people. Our solutions include Health Analytics powered by Cognitio’s Health Data Factory that drives better care outcomes and higher ROI on care spending. We specialize in providing Data Governance solutions that help effectively use data in a consistent and compliant manner. Additionally, our smart intelligence solutions enable a deeper understanding of operations through the use of data science and advanced solutions like process mining technologies. We have offices in New Jersey and Connecticut in the USA and in Gurgaon in India.
What we're looking for:
- Ability in data modelling, design, build and deploy DW/BI systems for Insurance, Health Care, Banking, etc.
- Performance tuning of ETL process and SQL queries and recommend & implement ETL and query tuning techniques.
- Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.
- Translate business needs into technical specifications, evaluate, and improve existing BI systems.
- Use business intelligence and visualization software (e.g., Tableau, Qlik Sense, Power BI etc.) to empower customers to drive their analytics and reporting
- Develop and update technical documentation for BI systems.
Key Technical Skills:
- Hands on experience in MS SQL Server & MSBI (SSIS/SSRS/SSAS), with understanding of database concepts, star schema, SQL Tuning, OLAP, Databricks, Hadoop, Spark, cloud technologies.
- Experience in designing and building complete ETL / SSIS processes and transforming data for ODS, Staging, and Data Warehouse
- Experience building self-service reporting solutions using business intelligence software (e.g., Tableau, Qlik Sense, Power BI etc.)
Oracle OAS Developer
Senior OAS/OAC (Oracle analytics) designer and developer having 3+ years of experience. Worked on new Oracle Analytics platform. Used latest features, custom plug ins and design new one using Java. Has good understanding about the various graphs data points and usage for appropriate financial data display. Worked on performance tuning and build complex data security requirements.
Qualifications
Bachelor university degree in Engineering/Computer Science.
Additional information
Have knowledge of Financial and HR dashboard
As an Oracle Process Manufacturing Functional Consultant, he will be providing functional inputs and support to the Oracle EBS team. The selected candidate must have experience in modules like Oracle Process Manufacturing, Sub ledger accounting and OPM financials with at least 2 implementations.
- - Bachelor’s Degree or foreign equivalent, will consider work experience in lieu of a degree.
- - 5 Years & above relevant Experience.
- - Have full life cycle implementations experience, with hands-on configuration, implementation and support.
- - Should be able to understand Business requirements and map them to proposed solutions/enhancements.
- - Testing and deployment of custom solutions.
- - Participate in functional testing and co-ordinate with cross functional stakeholders for timely delivery of the solutions developed
Company Description
At Bungee Tech, we help retailers and brands meet customers everywhere and, on every occasion, they are in. We believe that accurate, high-quality data matched with compelling market insights empowers retailers and brands to keep their customers at the center of all innovation and value they are delivering.
We provide a clear and complete omnichannel picture of their competitive landscape to retailers and brands. We collect billions of data points every day and multiple times in a day from publicly available sources. Using high-quality extraction, we uncover detailed information on products or services, which we automatically match, and then proactively track for price, promotion, and availability. Plus, anything we do not match helps to identify a new assortment opportunity.
Empowered with this unrivalled intelligence, we unlock compelling analytics and insights that once blended with verified partner data from trusted sources such as Nielsen, paints a complete, consolidated picture of the competitive landscape.
We are looking for a Big Data Engineer who will work on the collecting, storing, processing, and analyzing of huge sets of data. The primary focus will be on choosing optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them.
You will also be responsible for integrating them with the architecture used in the company.
We're working on the future. If you are seeking an environment where you can drive innovation, If you want to apply state-of-the-art software technologies to solve real world problems, If you want the satisfaction of providing visible benefit to end-users in an iterative fast paced environment, this is your opportunity.
Responsibilities
As an experienced member of the team, in this role, you will:
- Contribute to evolving the technical direction of analytical Systems and play a critical role their design and development
- You will research, design and code, troubleshoot and support. What you create is also what you own.
- Develop the next generation of automation tools for monitoring and measuring data quality, with associated user interfaces.
- Be able to broaden your technical skills and work in an environment that thrives on creativity, efficient execution, and product innovation.
BASIC QUALIFICATIONS
- Bachelor’s degree or higher in an analytical area such as Computer Science, Physics, Mathematics, Statistics, Engineering or similar.
- 5+ years relevant professional experience in Data Engineering and Business Intelligence
- 5+ years in with Advanced SQL (analytical functions), ETL, Data Warehousing.
- Strong knowledge of data warehousing concepts, including data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures, data modeling and performance tuning.
- Ability to effectively communicate with both business and technical teams.
- Excellent coding skills in Java, Python, C++, or equivalent object-oriented programming language
- Understanding of relational and non-relational databases and basic SQL
- Proficiency with at least one of these scripting languages: Perl / Python / Ruby / shell script
PREFERRED QUALIFICATIONS
- Experience with building data pipelines from application databases.
- Experience with AWS services - S3, Redshift, Spectrum, EMR, Glue, Athena, ELK etc.
- Experience working with Data Lakes.
- Experience providing technical leadership and mentor other engineers for the best practices on the data engineering space
- Sharp problem solving skills and ability to resolve ambiguous requirements
- Experience on working with Big Data
- Knowledge and experience on working with Hive and the Hadoop ecosystem
- Knowledge of Spark
- Experience working with Data Science teams
Preferred Education & Experience:
-
Bachelor’s or master’s degree in Computer Engineering, Computer Science, Computer Applications, Mathematics, Statistics or related technical field or equivalent practical experience. Relevant experience of at least 3 years in lieu of above if from a different stream of education.
-
Well-versed in and 5+ years of hands-on demonstrable experience with:
▪ Data Analysis & Data Modeling
▪ Database Design & Implementation
▪ Database Performance Tuning & Optimization
▪ PL/pgSQL & SQL -
5+ years of hands-on development experience in Relational Database (PostgreSQL/SQL Server/Oracle).
-
5+ years of hands-on development experience in SQL, PL/PgSQL, including stored procedures, functions, triggers, and views.
-
Hands-on experience with demonstrable working experience in Database Design Principles, SQL Query Optimization Techniques, Index Management, Integrity Checks, Statistics, and Isolation levels
-
Hands-on experience with demonstrable working experience in Database Read & Write Performance Tuning & Optimization.
-
Knowledge and Experience working in Domain Driven Design (DDD) Concepts, Object Oriented Programming System (OOPS) Concepts, Cloud Architecture Concepts, NoSQL Database Concepts are added values
-
Knowledge and working experience in Oil & Gas, Financial, & Automotive Domains is a plus
-
Hands-on development experience in one or more NoSQL data stores such as Cassandra, HBase, MongoDB, DynamoDB, Elastic Search, Neo4J, etc. a plus.
- Assisting developers to write efficient code.
- Tuning and debugging customer installations.
- Maintaining internal development and test databases.
- Working closely with leading experts in Supply Chain management to support various E2open teams.
- Provides on-call support in a 24x7 environment.
The position requires night shift work to support the US time zone.
Required Experience/Skills:
- Bachelor's/Master's/PhD degree in Engineering, Computer Science, Mathematics, or other Science with a consistent academic record (Preferably more than 70%)
- Oracle-certified DBA with 3+ years of DBA experience
- Oracle 12c and 19c experience is a must.
- Experience in Performance Tuning and Query Optimization is a must.
- Expertise and development experience in PL/SQL and SQL
- Experience in Oracle installation, upgrade backup, and recovery methods.
- Experience in Unix/Linux shell scripting.
- Track record of delivering quality work on time and ability to expand own expertise.
- Self-motivated, detail and team-oriented
- Solid verbal and written communication skills
- Enjoys dynamic, result-oriented work culture.
- Excellent problem-solving and troubleshooting skills.
- Experience considered a plus:
- MySQL and PostgreSQL
- Knowledge of server, storage, and networking technology.
- Supply Chain background