Database developer

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

Key Responsibilities & Job Duties

● To provide functional support for our ERP

Finance applications (Oracle eBusiness Suite)

○ Assist users in case of question

○ Manage functional requests

● Train users to keep the right level of skill

○ To organize audits of the use of systems

○ Detect and collect issues

○ Implement action plan and coordinate actions

● To manage enhancements in accordance with the procedures which apply in the department

○ Collect enhancements from users

○ Challenge the user requirements

● Define priorities

○ Write functional specifications and coordinate developments with the technical team

● Test and train the users

○ Regularly communicate to the users the status of the enhancement

○ Report activity to the management

○ Collaborate with functional support in other zones to share information

○ Optionally, may manage some projects

Key Technical & Functional Competencies
● Functional competencies

○ Strong Business processes: Finance

● Technical competencies

○ Good Knowledge of Oracle SQL

○ Strong Oracle eBusiness Suite

Modules: AP, AR, GL, FA (At least at a professional for two Modules)

○ Basic knowledge of Oracle eBusiness Suite Modules: INV, PO, OE, WSH is preferable

• Working with Banks in 24x7 based environment and identify Application problems and advising on the solution.
• Analyzing application/OS logs to spot common trends and underlying problems.
• Analyzing underlying database using SQL queries (MS SQL /Oracle or any other relational database).
• Deploying, testing, and reporting bugs/issues in new modules and support clients in testing.

Skills Required:

• Good analytical and problem-solving skills.
• knowledge of Linux Commands and database queries.
• Knowledge of Application servers i.e Apache Tomcat/ Jboss.
• Knowledge of shell script 
• knowledge on Banking Digital Products i.e. IMPS, UPI

Requirements

• Graduates from CS/IT/MCA/EC/EE stream with no backlogs (10th, 12th and graduation above 65%)

• Candidate should be aware with Software Development Life Cycle and

• Participating as team member in all phases of software development life cycle including the analysis and design of system

• Candidate Should have Effective Problem-Solving skills with excellent communication skills
• Exceptional analytical and conceptual thinking skills
• Advanced technical skills and Excellent documentation skills
• Good Knowledge about creating detailed reports and giving presentations
• Competency in Microsoft applications including Word, Excel, and PowerPoint
• Excellent planning, organizational, and time management skills

Responsibilities:

• Responsible for on call support for our software system to customers
• Responsible for End user training of our software products
• Responsible to implement software system to the end user/customer end
• Responsible for business requirement gathering and preparations of BRD FRD documents according to business needs
• Responsible for data management of software system for implementation purpose

JD:

Cloud Technical

Total Exp 4-9  Yrs

Cloud Technical
Need minimum4+ years of experience person in Oracle apps and 2+ year in cloud
Modules - AP PO GL FA
Expertise in BI reports/OTBI/FBDI/Personalization,
Excellent in SQL and PL/SQL

• Strong knowledge in Power BI (DAX + Power Query + Power BI Service + Power BI  Desktop
• Visualizations) and Azure Data Storages.
• Should have experience in Power BI mobile Dashboards.
• Strong knowledge of SQL.
• AAS Data model Deployment in Azure, Querying data from AAS to build Reports
• Experience in developing, optimizing, and administering Tabular Models in 'Azure Analysis service'.

• Design and Create AAS/OLAP/ Tabular cubes and automate processes for analytical needs.
• Good knowledge of DWH concepts.  
• Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using DAX functions in - Azure Analysis service

• Experience in Developing QlikView / Qlik Sense BI visualizations and dashboards. QlikSense and NPrintiing experience is a must.
• Strong knowledge of building Qlik Sense dashboards applying business rules and data validations.
• In-depth understanding of Qlik Sense Server Architecture, building QVDs and QVFs, applying business rules and data validations.
• Familiarity with charts and graphs, creating complex visualizations for dynamic aggregation Good Knowledge of Incremental data loading concepts and data modeling.
• Additionally, Qlik developers have to troubleshoot issues and provide the necessary solution

REQUIRED CITIZENSHIP / WORK PERMIT / VISA STATUS:
Should be currently based in Japan with Valid work visa

MUST HAVES:

• * Mandatory Skills - Mainframe, Cobol, JCL ,DB2
• * Should have working knowledge on at least one database – MS SQL server, Oracle, DB2, PostgreSQL, MongoDB, Firebird SQL diagnose
• * Language Skills - JLTP N3 would be fine if the

Requirements:

• · Graduate with 6+ years of experience in Mainframe based applications development, maintenance & run mode operations.
• · Ability to collaborate with a diversity of customer's teams to address important issues and to resolve them.
• · Experienced in collaborating with internal and external stakeholders, adaption and learning of the business processes.
• · Should have experience working with Mainframe, Cobol, JCL ,DB2.
• · Working knowledge on at least one database – MS SQL server, Oracle, DB2, PostgreSQL, MongoDB, Firebird SQL diagnose, troubleshoot and fix complex issues.

Only Japan based candidates with relevant experience can apply.