Database Architect

Job Description: 

We are looking for an experienced SQL Developer to become a valued member of our dynamic team. In the role of SQL Developer, you will be tasked with creating top-notch database solutions, fine-tuning SQL databases, and providing support for our applications and systems. Your proficiency in SQL database design, development, and optimization will be instrumental in delivering efficient and dependable solutions to fulfil our business requirements.

Responsibilities:

 ● Create high-quality database solutions that align with the organization's requirements and standards.

● Design, manage, and fine-tune SQL databases, queries, and procedures to achieve optimal performance and scalability.

● Collaborate on the development of DBT pipelines to facilitate data transformation and modelling within our data warehouse.

● Evaluate and interpret ongoing business report requirements, gaining a clear understanding of the data necessary for insightful reporting.

● Conduct research to gather the essential data for constructing relevant and valuable reporting materials for stakeholders.

● Analyse existing SQL queries to identify areas for performance enhancements, implementing optimizations for greater efficiency.

● Propose new queries to extract meaningful insights from the data and enhance reporting capabilities.

● Develop procedures and scripts to ensure smooth data migration between systems, safeguarding data integrity.

● Deliver timely management reports on a scheduled basis to support decision-making processes.

● Investigate exceptions related to asset movements to maintain accurate and dependable data records.

Duties and Responsibilities: 

● A minimum of 3 years of hands-on experience in SQL development and administration, showcasing a strong proficiency in database management.

● A solid grasp of SQL database design, development, and optimization techniques.

● A Bachelor's degree in Computer Science, Information Technology, or a related field.

● An excellent understanding of DBT (Data Build Tool) and its practical application in data transformation and modelling.

● Proficiency in either Python or JavaScript, as these are commonly utilized for data-related tasks.

● Familiarity with NoSQL databases and their practical application in specific scenarios.

● Demonstrated commitment and pride in your work, with a focus on contributing to the company's overall success.

● Strong problem-solving skills and the ability to collaborate effectively within a team environment.

● Excellent interpersonal and communication skills that facilitate productive collaboration with colleagues and stakeholders.

● Familiarity with Agile development methodologies and tools that promote efficient project management and teamwork.

Roles and Responsibilities:

Perform detailed feature requirements analysis along with a team of Senior Developers, 

define system functionality, work on system design and document the same

● Design/Develop/Improve Cogno AI’s backend infrastructure and stack and build fault￾tolerant, scalable and real-time distributed system

● Own the design, development and deployment of code to improve product and platform 

functionality

● Taking initiative and giving ideas for improving the processes in the technology team 

would lead to better performance of the team and result in robust solutions

● Writing high-performance, reliable and maintainable code

● Support team with timely analysis and debugging of operational issues

● Emphasis on automation and scripting

● Cross-functional communication to deliver projects

● Mentor junior team members technically and manage a team of software engineers

● Taking interviews and making tests for hiring people in the technology team

What do we look for?

The following are the important eligibility requirements for this Job:

● Bachelor's or Master's degree in computer science or equivalent.

● 5+ years of experience working as a software engineer, preferably in a product-based 

company.

● Experience working with major cloud solutions AWS (preferred), Azure, and GCP.

● Familiarity with 3-Tier, microservices architecture and distributed systems

● Experience with the design & development of RESTful services

● Experience with developing Linux-based applications, networking and scripting.

● Experience with different data stores, data modelling and scaling them

● Familiarity with data stores such as PostgreSQL, MySQL, Mongo-DB etc.

● 4+ years of experience with web frameworks (preferably Django, Flask etc.)

● Good understanding of data structures, multi-threading and concurrency concepts.

● Experience with DevOps tools like Jenkins, Ansible, Kubernetes, and Git is a plus.

● Familiarity with elastic search queries and visualization tools like grafana, kibana

● Strong networking fundamentals: Firewalls, Proxies, DNS, Load Balancing, etc.

● Strong analytical and problem-solving skills.

● Excellent written and verbal communication skills.

● Team player, flexible and able to work in a fast-paced environment.

● End-to-end ownership of the product. You own what you develop.

Hello,

Greetings for the day !!!

Tridat Technologies is hiring “Senior PostgreSql Developer" for one of the tech based organization specialized in banking domain @ Navi Mumbai !!!

JOB QUALIFICATIONS & PROFESSIONAL SKILLS:

• Bachelor's degree

What You Will Do:

• Ensure top quality for our PostgreSQL offerings
• Take an active role in the development lifecycle and enforce appropriate quality gates at the required stages.
• Analyze and continuously improve the test automation frameworks and infrastructure
• Monitor the coverage and efficacy of the automated test suites and take proactive actions to ensure satisfactory results
• Research and recommend new tools, strategies, or processes to improve testing and delivery capabilities.
• Prepare test plans for upcoming releases and ensure appropriate visibility for delivery status and test results.

Your Experience:

• Knowledge and experience working with SQL Databases
• Working with multiple automation tools and frameworks
• Solid debugging skills (analyze logs, spot patterns, etc.)
• Hands-on experience with Ansible, Jenkins, Python, and Github
• Familiarity with the Linux ecosystem

What Will Make You Stand Out:

• Exposure to database-related technologies
• Experience with compiling/building/packaging
• Worked with container or virtualization environments
• Experience working with PostgreSQL
• Working experience in the opensource world or contributions to open-source projects
• Experience with Molecule
• Great attitude and capability to easily communicate and work well with people from distributed teams.

EXPERIENCE: 7+ years

Key role interactions

• Will be expected to work from office

Location: Rabale, Navi Mumbai

Working Days: Monday to Friday

Employment Mode: Contract to hire (Full time opportunity)

Joining Period: Immediate to max 15 days

Thank You & Regards,

Shraddha Kamble

HR Recruiter

Job Description - Jasper 

• Knowledge of Jasper report server administration, installation and configuration
• Knowledge of report deployment and configuration
• Knowledge of Jaspersoft Architecture and Deployment
• Knowledge of User Management in Jaspersoft Server
• Experience in developing Complex Reports using Jaspersoft Server and Jaspersoft Studio
• Understand the Overall architecture of Jaspersoft BI
• Experience in creating Ad Hoc Reports, OLAP, Views, Domains
• Experience in report server (Jaspersoft) integration with web application
• Experience in JasperReports Server web services API and Jaspersoft Visualise.JS Web service API
• Experience in creating dashboards with visualizations
• Experience in security and auditing, metadata layer
• Experience in Interacting with stakeholders for requirement gathering and Analysis
• Good knowledge ETL design and development, logical and physical data modeling (relational and dimensional)
• Strong self- initiative to strive for both personal & technical excellence.
• Coordinate efforts across Product development team and Business Analyst team.
• Strong business and data analysis skills.
• Domain knowledge of Healthcare an advantage.
• Should be strong on Co- ordinate with onshore resources on development.
• Data oriented professional with good communications skills and should have a great eye for detail.
• Interpret data, analyze results and provide insightful inferences
• Maintain relationship with Business Intelligence stakeholders
• Strong Analytical and Problem Solving skills 

Job Description – Developer (ETL + Database)

 Develop, document & Support ETL mappings, Database structures & BI reports.

 Perform unit testing of developments done by him/her.

 Participate in UAT process and ensure quick resolution of any UAT issue.

 Manage different environments and be responsible for proper deployment of code in all client

environments.

 Prepare release documents.

 Prepare and Maintain project documents as advised by Team Leads.

Skill-sets:

 3+ years of Hands on experience on ETL Pentaho Spoon Talend & MS SQL Server, Oracle & SYBASE Database tools.

 Ability to write complex SQL and database procedures.

 Good knowledge and understanding regarding Data warehouse Concepts, ETL Concepts, ETL

Loading Strategies, Data archiving, Data Reconciliation, ETL error handling etc.

 Problem Solving.

 Good communication skills – written and verbal.

 Self-motivated, team player, action and result oriented.

 Ability to successfully work under tight project schedule

• 2-3 years of experience in development using core Java, Spring Boot Framework
• Should have knowledge of Design Patterns
• Working knowledge of  RDBMS like PostGreSQL
• Having worked with tools like bitbucket, Jenkins, Jira etc would be an added advantage
• Should have good analytical and problem solving skills 
• Experience in multi-threaded server side Java programming                                                          
• Working knowledge on web services.
• Working knowledge on hibernate and springs framework.
• Experience in writing SQL queries.
• Should have worked in SDLC environment.
• Good communication skills.
• Experience in working effectively within a team

• Minimum 3 years of working experience in database related projects.
• Working experience on any of the leading Database management systems viz., Oracle,SQL-Server, etc. (Experience on Postgres database systems will be an added advantage).
• Adequate Database Development skills & should be proficient in SQL coding.
• Working experience in Database SQL Optimization/Performance Tuning.
• Working experience on any of the Database Programming languages viz., PL/SQL, PL/pgSQL,T-SQL,etc.
• Flexible to learn, adopt & scale to any data centric technologies as per the evolving Organizational product strategies.

• Good to have skill sets of the Candidate:
• Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts.
• Working experience on Data Analytics/Reporting/ETL or exhibits sound knowledge over the concepts.
• Database agnostic approach to data/database solutions.
• Exhibits sound knowledge on Big-data/Hadoop, Kafka, Map-Reduce programming, NoSQL,etc.

https://www.srclogix.com/">SourceLogix  - is a California based software development company. Founded in 2007, we have successfully built our client base with our values: Talent. Team. Trust.

SourceLogix experts help Fortune 500 clients in the areas of SaaS, eCommerce, VoIP, CRM, Transaction systems & Predictive Analytics.

Our CRM solutions division is the best-in-class salesforce consulting team that helps customers with their CRM challenges such as integrating CRM to other platforms. Homegrown tools or cloud-based apps: ERP, Billing systems, telephony & chat apps, productivity and collaboration apps. We also help our customers with data cleansing, governance, and meaningful metrics and dashboarding.

We are looking for a Certified Salesforce developer with 5 years of experience. Your primary focus will be to develop all salesforce interface components and implement them following well-known APEX. 

You will work with our team and end clients to ensure that the customer requirements are understood and implemented as expected. You will coordinate with the rest of the CRM team and demonstrate: collaborative, problem solving, sophisticated design and build a solution per client’s requirements.

• Salesforce certifications (Salesforce Certified Platform Developer I or II). - Must have
• Bachelor's degree in computer science or other related disciplines.
• Passion for creating and delivering great software with a strong sense of ownership. 
• Strong knowledge of JSON, XML, JavaScript, CSS2 & CSS3, HTML5 &  jQuery.
• Over three years of experience in building salesforce applications using APEX, VisualForce, Native, MySQL,and JavaScript.
• Demonstrated experience working with relational databases, and ETL tools.
• Familiarity with the Lightning component framework.
• Independently develop new user-facing features from designs and wireframes.
• Proficient in Version Control Software such as GIT, Bitbucket.
• Ability to understand business requirements and translate them into technical requirements.
• Strong organizational skills. Ability to prioritize tasks and work in a dynamic fast-changing environment.

• Knowledge of modern authorization mechanisms, such as JSON Web Token.
• Knowledge of the AWS platform and scalable application architecture.
• Experience with CI/CD - Build & Release process. Agile/ Scrum based development..

• Collaborate with different departments and resources to translate business needs to requirements.
• Create user documentation for all the code built.
• Configuration and customization of the client’s salesforce.com platform.
• Translate design and wireframe into high-quality code.
• Create documentation such as requirements, test cases, and test scripts.
• Diligently work on resolving reported issues and document root-cause analysis.
• Optimize components for maximum performance across a vast array of devices & browsers.
• Be responsive to change, adapt quickly with a talented team and work efficiently & remotely.
•  

• Competitive salary - based on experience.
• 100% remote work. All you need is a good laptop, headset, and internet connectivity.
• Ability to make a direct impact & build an award-winning Salesforce platform.
• Awesome culture! We are a friendly & collaborative team with a learning and growth mindset.