Job Description:
Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:
- Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
- Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
- Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
- SQL Query tuning and performance tuning.
- Develop/migrate existing scripts to SSIS.
- Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
- Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
- Importing and exporting the data from different sources using tools, writing required scripts.
- Works closely with other members of the team to accomplish the projects.
- Assists project teams to design and develop core business components utilizing industry-accepted analysis and design standards.
- Provides and/or assists with, project management and project leadership.
- Create and maintain documentation for all the projects.
- Working with NOSQL databases (Mostly on MongoDB) .
PRIMARY SKILLS:
TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.
SECONDARY SKILLS:
Database Administration
REQUIRED SKILLS:
- 3+ years of professional experience in working with MSSQL Server 2008 and above.
- 3+ years of professional experience in writing TSQL scripts.
- Thorough experience in SQL query tuning and performance tuning.
- Experience in developing and maintaining SSIS packages.
- Experience in working with NoSQL databases. MongoDB would be preferable.
- Fluent knowledge of MSSQL server DBA.
- Should be a good team player and should possess good attitude and work ethics.
- Should possess excellent communication and written skills.
PREFERRED SKILLS:
- MSSQL DBA.
- SSIS.
- NOSQL, MongoDB
About Mirabel Technologies, Inc
The Next Generation of Automation:
Mirabel Technologies is a privately owned, international tech company that provides all-in-one software solutions for businesses. President Mark McCormick founded Mirabel Technologies in 2003 with the vision to help publishers streamline operations in an ever-changing media environment.
After launching over a dozen successful magazines in South Florida, McCormick introduced Mirabel’s flagship product, The Magazine Manager. As the first web-based CRM made for publishers, it now serves more than 17,000+ media properties worldwide.
Since then, other publishing products followed suit, including The Newspaper Manager, a CRM specific to newspapers, and Mirabel’s Magazine Central, a library-like platform to display digital editions.
In 2019, Mirabel Technologies expanded into marketing automation and email verification with Mirabel’s Marketing Manager and Clean Your Lists, respectively.
Coming Soon: The company plans to join the subscription industry with ChargeBrite, a brand-new digital platform tailored to any business with a recurring revenue model.
Similar jobs
About the role
We are looking for an experienced Product Analyst to join our team.
As a Senior Product Analyst, you will play a crucial role at the intersection of Product and Impact. You will independently lead analytics in order to understand how users interact with the product, and you will work with the Product Manager to turn product insights into improvements in user experience.
The ideal candidate should have a natural curiosity to uncover insights from data, and a passion for transforming these insights into actionable strategies. A deep understanding of mobile application analytics is a must.
Responsibilities
- Collect, analyze, and interpret product data to gain product insights and provide recommendations to the product team.
- Critically think about user experience in our product and how it can be measured
- Analyzing user journeys and cohorts to identify trends and behaviors
- Generating insights from product data to influence decision-making
- Performing customer segmentation to drive targeted marketing and product strategies
- Conduct A/B testing to assess the efficacy of product enhancements, providing data-driven recommendations for product development.
- Lead customer segmentation initiatives to drive targeted marketing and product strategies, enhancing customer engagement and satisfaction.
Key Skills and Experience
- Minimum of 2 years experience in a product analytics role, preferably for a mobile application
- Proficiency in SQL and relational databases
- Proficiency in Python for data manipulation (Pandas and NumPy)
- Experience in user journey tracking, segmentation, cohort analysis, A/B analysis
- Proficiency in data visualization tools (e.g., Google Data Studio)
- Experience Google Analytics, Firebase, and other web and mobile app analytics tools such as Mixpanel or Amplitude (we use Posthog).
Job Description
- Meeting with the client and internal team to review website and application requirements.
- Setting up project completion timelines with client and tracking it to closure.
- Configuring the company SharePoint systems to specified requirements.
- Developing new web components using XML, .NET, SQL, and C#.
- Designing, coding, and implementing scalable applications.
- Extending SharePoint functionality with forms, web parts, and application technologies.
- Testing and debugging code, troubleshooting software issues.
- Reviewing website interface and software stability.
- Maintaining and updating SharePoint applications.
- Prepare Solution Design Documentation of projects.
- Providing systems training to staff and customers.
- Reporting - Dashboard, Growth Report, All Project Reports MTD, QTD, YTD wise
- Collect the Data from Project Team to analyze it daily or monthly basis
- Expertise in MS Office and Report Generation
- Work very closely with teams across delivery locations and client
- SharePoint and VBA skills
- To be willing to work in US shifts
- Perform requisite MIS (Count sheets, internal & external reporting)
- Adhere to reasonable operational requests from the management
- Expert in managing new SharePoint sites with approval workflow and maintenance of the existing sites.
- High-level coding skills.
- Ability to solve complex software issues.
- Detail orientated.
- Self-motivated.
Title: Technical Analyst - OTM
Experience: 3-9 Years
Work Location: Mohali
Shift Timing: Rotational Shift 24x5
Notice Period: Immediate to 30 days Max
Key Skills: OTM, OBIEE, BI Publisher, Oracle ERP
Job Description:
The Oracle Transportation Management Technical Analyst will share the responsibility for design, implementation, and support of business solutions based on Emerson’s instance of Oracle Transportation Management commonly referred to as SCO (Supply Chain Optimization). The Technical Analyst utilizes expertise in Oracle Transportation Management to provide assistance in the ongoing implementation, enhancement, and support of SCO functionality.
Roles and Responsibilities:
- Provide support (e.g., break/fix, how to expertise, enhancements, monitoring, testing, troubleshooting) for the SCO application.
- Works collaboratively with Corporate Logistics and SCO IT Program/Project Managers to understand program requirements and assist with the evaluation of alternative solutions.
- Assist with program rollout activities, including business unit and trading partner on-boarding, project coordination, status reporting and communication to program management.
- Proactively monitors processes to identify trends; analyses/predicts trends and develops a long-range plan designed to resolve problems and prevent them from recurring to ensure high service levels.
- Ensures SCO system documentation is complete and maintained.
- Works effectively in a global highly matrixed team environment.
Skills & Experience Required:
- 4 to 8 years of IT experience, including implementation of Oracle Transportation Management.
- OTM Expert, both Functionally and technically (Setup configuration, Order Management, Shipment management, Financials, rates, master data, bulk planning parameters, VPDs, user configuration, screen set development, SQL queries, Tracking Events and working with CSV & XML files).
- Hands on experience with triage of day-to-day OTM systems issues and providing resolution on complex issues.
- Knowledge of Logistics management principles and processes.
- Broad knowledge and experience with various ERP systems. Working knowledge of Oracle eBusiness Suite (Procurement, Shipping, XML Gateway) is highly preferred.
- Working knowledge of BI Publisher, FTI/OAC, OBIEE and ETL.
- Good knowledge of EDI and any other Middleware systems.
- Strong customer service orientation with strong written and verbal communication skills, including comfort with presenting to diverse technical and non-technical audiences at all levels of the organization.
- Ability to multi-task and work within diverse multi-disciplinary global project teams.
- Detail-oriented with strong problem-solving skills.
- Comfortable with performing detailed data analysis to identify opportunities and gain higher level insight.
- Knowledge on GTM (Global Trade Management) will be a plus.
- Some travel might be required.
Education
- Bachelor’s degree in computer science, Information Systems, or another related field.
We are looking for an exceptionally talented Lead data engineer who has exposure in implementing AWS services to build data pipelines, api integration and designing data warehouse. Candidate with both hands-on and leadership capabilities will be ideal for this position.
Qualification: At least a bachelor’s degree in Science, Engineering, Applied Mathematics. Preferred Masters degree
Job Responsibilities:
• Total 6+ years of experience as a Data Engineer and 2+ years of experience in managing a team
• Have minimum 3 years of AWS Cloud experience.
• Well versed in languages such as Python, PySpark, SQL, NodeJS etc
• Has extensive experience in Spark ecosystem and has worked on both real time and batch processing
• Have experience in AWS Glue, EMR, DMS, Lambda, S3, DynamoDB, Step functions, Airflow, RDS, Aurora etc.
• Experience with modern Database systems such as Redshift, Presto, Hive etc.
• Worked on building data lakes in the past on S3 or Apache Hudi
• Solid understanding of Data Warehousing Concepts
• Good to have experience on tools such as Kafka or Kinesis
• Good to have AWS Developer Associate or Solutions Architect Associate Certification
• Have experience in managing a team
Responsibilities of senior java developer
- Every role comes with responsibilities and the employees have to justify those responsibilities. Following are some crucial responsibilities senior java developers entitled for.
- Senior Java developers have to analyze and assess the business needs of the client to find the best solution for the client. Overall strong analytical and problem-solving skills are highly important for this role.
- Senior Java Developer responsibilities include gathering system requirements, building application specification document, draw flow charts, design application architecture and implement modernised application design and testing features before release.
- You should have hands-on experience in developing software with agile or scrum methodologies and are ready to lead our junior developer's team.
- You should have an innovative thought process and creative thinking which can bring out of box and alternate way of system implementation.
- Ensure our applications must be secure and up-to-date.
- To interact with the customer and internal teams in Identifying and analyzing requirements for development purposes.
- To perform activities related to the creation of documents for client requirements.
- Prioritizing the task and executing tasks throughout the SDLC.
- Provide technical help to junior developers.
- You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
- Development of high quality database solutions
- Create complex functions, scripts, stored procedures and triggers to support application development.
- Develop, implement and optimize stored procedures and functions using T-SQL
- Review and interpret ongoing business report requirements
- Build appropriate and useful reporting deliverables
- Analyze existing SQL queries for performance improvements
- Fix any issues related to database performance and provide corrective measures.
- MIS Automation
- Provide timely scheduled management reporting
- Create Business dashboard using Tableau BI Tool
Requirement / Desired Skills:
- 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
- Excellent understanding of T-SQL programming
- Excellent understanding of Microsoft SQL Server
- Good knowledge of HTML and JavaScript
- SQL Server Reporting Services and SQL Server Analysis Services
- Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)
Minimum 4 to 14 Years OTM Technical / Functional experience
- Must have functional and techno-functional experience in OTM implementation and/or have supported projects dealing with these systems, and/or have worked on OTM Cloud
- Must have strong technical and functional knowledge of the latest OTM Application
- Must have knowledge of preparing mapping document to interface OTM system with EDI, WMS, order management and finance systems, and be able to translate the functional specifications into design specifications for the Offshore Delivery Centre
- Must have ability to write SQL statements for automation agents and other technical topics
- Hands on experience on JSPX/XSL will be additional advantage.
- Experience in end-to-end OTM life cycle/implementations/up-gradation and OTM architecture will be preferred
Mandatory Skills required:
1. Ability to translate business requirements into technical requirements for QlikView
2. Perform detailed analysis of source systems and source system data and model that data in
Qlikview
3. Design, develop, and test QlikView scripts to import data from source systems, data feeds, flat files
to create Qlik marts
4. Proficiency with QlikView Scripting, use of complex QlikView functions,
advanced QlikView Expressions, experience with complex data models and optimization of data
model for query performance to create Qlik Marts
5. Architecture optimization ( includes hardware sizing , security setup , performance tuning )
6. Development of Qlikview/ QlikSense
Understanding PowerApps formulas and development methods. Ability to develop
POWER BI Min 2+ years of hand on experience in POWER BI Reports and dashboard development, MS SSAS, MS SSAS & POWER BI Candidate
Should have hands on experience on writing complex SQL queriesworkflows using PowerApps and Microsoft PowerAutomate.
Customizing SharePoint lists and disparate systems with PowerApps Knowledge of PowerApps and PowerAutomate licensing Automating business processes with Microsoft PowerAutomate.
Automating business processes with Microsoft PowerAutomate.
Ability to create custom connectors for Microsoft PowerAutomate.
Experience with API or rest services integrations.
Understanding of how to implement solutions with multiple data source Understanding PowerApps formulas and development methods
Peoplesoft Technical - SSE
Sr.Software Engineer with 5 to 9 years of experience in PeopleSoft
Mandatory:
Good knowledge and minimum 5 years hands-on Technical experience on Application Designer, PeopleCode, Application Engine, Component Interface, Application Package and Integration Broker.
Good Verbal & Written communication Skills
Preferred:
Sound techno-functional and business process conceptual knowledge on Peoplesoft Finance procure to pay modules - AP,GL,PC, AM, PO, ePro, SCMT, Catalog Management & eSettlements.
Experience on reporting tools like BI Publisher, SQR, PS Query, PS Security, and nVision reports will be added advantage.
Worked in Upgrade/ Support/Development projects in PeopleSoft Financials.
Worked on all phases of a project - design, development, testing etc.
Knowledge in mainframes would be an added advantage