11+ SQL Server Analysis Services (SSAS) Jobs in Chennai | SQL Server Analysis Services (SSAS) Job openings in Chennai

OJ Commerce Inc. is a fast-growing retailer serving the US market through OJ Commerce.com and various market places such as Amazon, Walmart, and eBay. OJ Commerce is a privately held, profitable company headquartered in Miami, Florida, USA with a 100% dedicated back-office in Chennai. The workhours are flexible with predominantly India business hours with some overlap with US Eastern Time business hours based on need.

Experience: 

4+ relevant experience

Role: Individual Contributor Role.

Location : Chennai - Ekaduthangal (Work From Office)

Skill Sets:

• In-depth knowledge in MS SQL Server and related tools & technologies such as SSIS, SSRS &SSAS

• Exposure to data modelling and ability to develop complex queries & procedures

• Manage and monitor performance, capacity and security of the database

• Continuously improve the performance of the database in alliance with the Database Adminstrator by optimizing jobs, procedures & queries

Desirable Skills:

➢ Candidates with experience in ecommerce / online retail is added value.

➢ Should be comfortable in dealing with senior leadership (internal & external)

➢ Communication Skills – Excellent verbal and written communication skills with ability to explain ideas very clearly.

➢ Self–motivated and flexible, with an ability to work independently.

Traits Expected: 

• Ability to work in a fast–paced, dynamic environment with limited resources

• Problem-solver with a desire to solve complex business problems with innovative & cost–effective solutions

• Excellent analytical and problem-solving skills, with out–of–the–box thinking.

Location: Chennai

Experience: 4 years

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.

BI Developer

Roles and Responsibilities:

• Comprehensive knowledge of SQL
• Expertise as a Microsoft BI Developer (SQL Server, SSIS)
• Experience and understanding of build and deploy processes
• A structured approach to software development (agile or waterfall), and a thorough understanding of the full software development lifecycle
• Knowledge and experience in experience banking
• Contribute to planning and estimation of sprints, features and releases
• Integrate new data sources using SQL, SSIS and C#
• Contribute to the testing and UAT phases
• In addition SQL Server 2014, Integration Services, Analysis Services, and Reporting Services (SSIS, ), Microsoft .NET, Tableau, Power BI, Data warehouse design

- Writing queries used for front- end applications (websites, desktop applications)

- Designing and coding database tables to store the application data

.- Data modeling to visualize database structure.

- Reviewing query performance and optimizing code.

FIRM OVERVIEW

Datazoic is a cutting edge, Capital Markets focused FinTech Company. Its core application is a predictive analytic platform designed for full service Investment Banks and Asset Management firms. Its user base extends to over 1500 users across four, large sell-side firms Now, if you are someone who can fit in, do read the roles listed below and apply!

Job Summary

Analyzes users' requests/issues to troubleshoot and suggest workarounds/solutionsfor customers

Monitor daily application feeds and proactively engage with the Engineering team should there be a need for escalation

Proficiency in SQL and Log analysis preferred

Must be comfortable working Night Shift

Strong English proficiency required, both oral and written

Freshers with excellent communication and analytical skills may apply

• 6 - 10 years’ experience in Oracle EBS (Techno-Functional)
• Experience in implementation, Support, and upgrade projects
• Experience at least in 2 R12.2 upgrade projects.
• Experience in Oracle EBS R12.2.7 or Higher versions of R12.
• Strong knowledge in SQL/PLSQL, Reports, Forms, and workflow. OAF is added advantage.
• At least 40% functional knowledge in SCM and Manufacturing (Modules: PO, OM, INV, WIP, BOM, Quality and Engineering)
• Excellent verbal and written communication skills

Job Description:

MySQL - DBA L3 Support

• 7 -10  years of experience in MySQL, handled multiple versions & flavors of MySQL servers both for standalone & enterprise version, Data center and VM/Cloud setup.
• Strong database Configuration and troubleshooting / problem solving skills.
• Strong knowledge of database backup and recovery concepts and practices.
• Enabling disabling scheduled Jobs on MySQL Server
• Work with Dev and DevOps engineers to ensure that all needed data is gathered and provided to them for any performance issues
• Experience in managing both on-prem DB as well as VM / cloud based DBs
• Maintenance of backups (perform backups, monitor backup, report obsolete backups)
• Maintenance of user access (creating user accounts, dropping user accounts, granting privileges)
• Maintenance of log and trace files (remove, initialize, archive them)
• Knowledge on SQL scripts
• Managing Database administration includes Daily health checks, Database tuning, Query optimization & Backup & Replication
• Experience in alert configurations using existing alerting tools or scripts