Senior Database Developer - Data Modeling & DB Design Schema

The Sr. Analytics Engineer would provide technical expertise in needs identification, data modeling, data movement, and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.

Understands and leverages best-fit technologies (e.g., traditional star schema structures, cloud, Hadoop, NoSQL, etc.) and approaches to address business and environmental challenges.

Provides data understanding and coordinates data-related activities with other data management groups such as master data management, data governance, and metadata management.

Actively participates with other consultants in problem-solving and approach development.

Responsibilities :

Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs.

Perform data analysis to validate data models and to confirm the ability to meet business needs.

Assist with and support setting the data architecture direction, ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.

Coordinate and consult with the Data Architect, project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.

Work closely with Business Analysts and Solution Architects to design the data model satisfying the business needs and adhering to Enterprise Architecture.

Coordinate with Data Architects, Program Managers and participate in recurring meetings.

Help and mentor team members to understand the data model and subject areas.

Ensure that the team adheres to best practices and guidelines.

Requirements :

- Strong working knowledge of at least 3 years of Spark, Java/Scala/Pyspark, Kafka, Git, Unix / Linux, and ETL pipeline designing.

- Experience with Spark optimization/tuning/resource allocations

- Excellent understanding of IN memory distributed computing frameworks like Spark and its parameter tuning, writing optimized workflow sequences.

- Experience of relational databases (e.g., PostgreSQL, MySQL) and NoSQL databases (e.g., Redshift, Bigquery, Cassandra, etc).

- Familiarity with Docker, Kubernetes, Azure Data Lake/Blob storage, AWS S3, Google Cloud storage, etc.

- Have a deep understanding of the various stacks and components of the Big Data ecosystem.

- Hands-on experience with Python is a huge plus

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

Job brief DotNet (2 to 3 years)
We are looking for a .Net developer to build software using languages and technologies of the .NET framework. You will create applications from scratch, configure existing systems and provide user support.

In this role, you should be able to write functional code with a sharp eye for spotting defects. You should be a team player and excellent communicator.

Your goal will be to work with internal teams to design, develop and maintain software.

Responsibilities
-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 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 http://asp.net/">ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
-Familiarity with architecture styles/APIs (e.g RESTful)
-Understanding of Agile methodologies
-Excellent troubleshooting and communication skills
-Any Graduate (Computer Science, Engineering or a related field)

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation

 Role:

• Understand complex business problems and implement product features that are secure, scalable, robust and easy to implement and maintain.
• Take full ownership of product features to implement, provide bug fixes and write tests and tooling for those features to ensure they work well at cloud scale.
• Take pride of ownership in features that are used by users of Top 100 Global enterprises.

 Required skills:

• C#/ASP.NET/Javascript/MVC guru with the ability to understand complex domain problems and churn out a PoC quickly.
• A great communicator of ideas and solutions and a lateral thinker when faced with complex performance or production issues.