
Skill for BI Backend developer -
-SQL development (Snowflake preferred but any other version of SQL would work)
- ETL
- Stored Procedures
- Creating jobs and work flows in SQL
- some business knowledge

About 3K Technologies Pvt Ltd
About
Connect with the team
Similar jobs
Job Description
- 5- 8 yrs IT industry experience preferably Banking domain
- Strong Python Skills and good understanding of Java and Microservices
- Should have handled banking customers and exposure to Production support processes
- Good in database and Pl/SQL – Ability to write SQL as and when needed
- Good attitude and communication
- WFH not allowed – Working from Bank premises as per bank calendar in Saifabad or Hitech City – Saifabad Flexibility must
Job Description:
As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.
The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.
- Accountability and primary responsibility/duties:
- A typical day would look like as follows: -
- 40% support issues.
- 40% configuration/development work.
- 20% continuous improvement, automation, CICD, so on.
- Activities would range across the lifecycle from discovery to post-implementation support.
- Understanding client’s requirement, replicate the problem and providing the solution
- Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
- Update the existing functionality based on client needs.
- Develop changes that cater to enhancing the product and/or fixing production issues
- Prepare product releases of software components. (Java/SQL-PLSQL)
- Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
- Create technical document for all changes made.
Required Qualifications/Knowledge/Skills
- Bachelor’s degree in Computer Science or related field
- Strong basics and working experience in following technologies: -
- Core Java.
- SQL / PLSQL coding.
- Object Oriented Programming concepts and data structures.
- Working knowledge on Unix platform
- Working knowledge on XSLT and XML handling
- Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
- Advantageous to have:
- Working understanding on CICD, Dev-ops technologies.
- Queuing technologies including Kafka, MQ, Solace.
- Scripting including Python, Unix, java.
- Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
Requirements:
- Retrieve Data from Databases
SSRS developers optimize SQL server queries to retrieve data efficiently and quickly. As
teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.
- Design Data Solutions
To create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.
- Create and Maintain Reporting Processes
To maintain a record of the different reporting processes in place. Evolve ways & means for a more effective data management.
- Resolve IT and Data Issues
- Provide Delivery Plans and Estimates for Projects
- Actively participate in the exchanging of ideas and information within the department
- Participate in rollout of new business system integrations.
- Serve as escalation point for system and troubleshooting issues, assist in resolving production issues.
- Participate in or lead solution design sessions.
- Ability to work effectively under pressure with changing priorities and tight deadlines
- Provide technical advice, code reviews and assistance to other programmers.
- Write complex integration solutions, optimized data extracts, updates and interfaces.
- Interface with functional specialists to ensure solution design and integrity.
- Devise sample input data to test accuracy of program.
- Observe or runs test of program using sample or actual data, assist in user acceptance training.
- Understand and embrace the global IT strategic direction
- Adhere to all safety and health rules and regulations associated with this position and as directed by superior.
- Proactively organize verbal and written ideas clearly and use an appropriate business style
- Be effective and consistent in providing regular updates to appropriate managers
Communication :
- Ask questions; encourage input from team members
- Able to work with and participate within a small multicultural professional team.
- Provide regular updates to appropriate managers
- Confer with reporting manager on complex or unusual situations
- Maintain a thorough knowledge and in-depth field experience regarding emerging or job technologies required to fulfill the job, this could include formal or self paced professional development. Participate in the exchange of ideas and information within the department
- Offer new ideas and suggestions for improvement. Identify and implement new practices and processes that are - best in field-
Requirements:
KNOWLEDGE REQUIREMENTS :
- Experience in analysis, design, coding, and implementation of enterprise integration solutions.
- Experience with webMethods components: Integration Server, Broker, Trading Networks, and SAP Adapter. webMethods 9.x version preferred.
- Experience with RosettaNet PIP's and standards.
- Experience with XML and webservices (SOAP/REST).
- Experience with PL/SQL.
- Experience with FlatFile processing
- General understanding of scalability and high-availability systems.
- Excellent communication/documentation skills
- Experience in system administration a plus.
EDUCATION & EXPERIENCE REQUIREMENTS :
- B.E./B.Tech/M.Tech/MCA
- 3 to 5 years experience in a relevant IT position OR equivalent external work experience
WORKING CONDITIONS :
- Location:
- Travel requirements: Domestic and/or International, up to 10%.
- Climate controlled office environment during normal business hours
- 7 years of hands-on experience on database development
- Very strong and hands-on in Oracle Database and PL/SQL development
- Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
- Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
- Working experience in development of ETL process, DB Design and Data Structures
- Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
Excellent written and verbal communication skills
- Hands on Java experience with minimum 8 yrs. More experience is a plus but need to be hands on.
- Server side programming experience with technologies: Spring, Hibernate & Swing is a plus
- Good DB knowledge, hands on PL/SQL or T-SQL
- Experienced to work on Linux, git, IntelliJ, Eclipse
- Experience of designing and developing end-to-end solutions.
Role: Software Engineer
Location: Hyderabad
Experience: 3-5 years of experience in software development using Core Java, multi-threading, DS and Algos.
Key Requirements:
- • Develop robust Core Java code for advanced financial banking and trading applications, primarily using core Java principles around multi-threading and caching technologies.
- • Strong in Core Java concepts, JVM, API’s along with SQL and Java Message Service (JMS) skills.
- • Experience in Java server-side / backend development experience
- • Experience in Java Spring (Spring MVC, Spring batch, Spring Boot), Hibernate and JPA is a plus.
- • Knowledge of microservices development, container stack and CI/CD;
- - 2+ years experience in application support on Asp.Net and SQL
- - Should be able to debug production issues and bug fixes
- - Should be able to write queries for extracting data using joins
- - Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator
- - Provide daily status updates and time-sheets to on-site and offshore project
- - Ready to work in shifts
- - Knowledge Transfer / Training to stakeholders
Personal Attributes
- - Good communication skills
- - Highly committed and able to work independently and as a team
- - Positive attitude towards learning
- - Deadline orientated and escalate in advance in case of delays
- - Contribute towards improving quality, standardization and documentation for all
- changes & Support activity
- - Ability to remain calm in a fast-paced and highly pressure environment







