Etl Consultant

About C&R Software:

We are a division of Jonas Software, Inc (www.jonassoftware.com). which is the valued technology partner of over 80,000 customers worldwide in more than 15 countries. Jonas employs over 2,700 skilled individuals consisting of a cross-section of industry experts and technology professionals. Jonas is headquartered in Canada and operates offices throughout North America, South America, the United Kingdom, Europe, Australia and New Zealand. Jonas is a 100% owned subsidiary of Constellation Software Inc. (www.csisoftware.com), headquartered in Toronto and traded on the TSX (CSU.TO).
C&R Software (www.crsoftware.com) delivers optimized solutions across the Collection and Recovery lifecycle, empowering organizations to manage their end-to-end collections operation more effectively and compliantly.
Collections is an increasingly complex and evolving landscape, but with C&R’s sophisticated systems, it becomes simple for users to drive process automation while having the flexibility to easily adapt to change. Our cloud-native software is fast and easy to deploy and provides unlimited scale to grow with your business.
C&R Software has evolved over the last 35 years, with its flagship product, Debt Manager, the industry-leading Collections technology trusted by hundreds of organizations in over 50 countries. Given the highly configurable nature of the solution, it supports businesses across many verticals, including financial institutions, governments, utility and telecoms, collection agencies and debt buyers, and more.
C&R Software specializes in Debt Collection and Risk Innovation, Compliance, Placement Optimization, Digital Transformation, and Emerging Technology.
Debt Manager deployed in AWS, is the only cloud-native, end-to-end collections and recovery platform in the world. It connects collections, recovery, and communications in one system. It prioritizes the consumer journey, automating operational processes and making consumers happy. More than $3 trillion is managed on Debt Manager as a System of Record, offering extensive capabilities unmatched by any other provider.

Job description:

Qualified candidates are being considered for openings within the Professional Services group at C&R Software, Bangalore. These candidates will possess a strong background in understanding business requirements, architecting technical solutions, designing technical specifications and developing data extraction/load programs
The position is part of the Solutions Integration practice which focuses on the integration of information, process and people through the application of multiple technologies. The candidate is expected to handle small to medium scale consulting projects and should possess skills in the design, development, integration, and deployment of data extraction/load programs. Previous experience within Banking and Financial Services is preferred.
To be considered, a candidate should be available for traveling (5% or more) and possess the required skills as mentioned below.
The position will be based in the C&R Software Office in Bangalore, India . We shall offer Hybrid model of working.
Position description – Solution Integration - Lead ETL Consultant – Band D
Role/responsibilities:

Design, develop, deploy, and support modules of our world-class enterprise-level solution into our international client base
Drive technical architecture and design process in conjunction with client requirements
Evaluate new design specifications, raise quality standards, and address architectural concerns
Evaluate stability, compatibility, scalability, interoperability, and performance of the solution
Own design aspects, performance, re-startablity, logging, error handling, security for both on-premises and cloud customers
Continually learn new technologies in related areas
Single point of contact (SPOC) for the technical implementation.
Work with Project Manager to plan and deliver projects from requirements till Go-Live
Be responsible to successfully deliver projects with accountability and ownership
Getting the broader picture of the project and contributing accordingly. This includes understanding the business, technical & architectural aspects of project implementations.
Thought process to build reusable artefacts and to make use of them to reduce development / testing / deployment / maintenance efforts.
Ability to work with multiple customers at the same time.
Adaptability to work in SDLC, Iterative and Agile methodology.
Interact with clients/onsite team members to understand project requirements and goals.
Lead client workshops (face to face or over the phone) for consulting, drive solutioning and issue resolution with client
Follow up and escalate gaps, issues and enhancements identified throughout the project and drive them to closure
Display high level of knowledge and consistent service in all interactions with client
Establish positive client relationship(s) to facilitate our implementations
Support client activities throughout the implementation of project life cycle including testing phases
Support & review test strategy / planning of the end to end solution
Lead in developing detailed business and technical specifications based on project requirements and turn into data extraction/load programs.
Program ETL tool with business rules to be applied to data from source input to target data repository.
Develop and assist in automating data extraction/load programs to run on regular schedule.
Assist in managing daily, weekly, and monthly data operations and scheduled processes.
Perform data conversion, quality, and integrity checks for all programs/processes
Mentor junior members on team and be responsible for their deliverables
Engage in Pre-Sales demonstrations, providing solutions and providing estimates
In addition to these skills, the individual needs to be skilled in business analysis and knowledge acquisition . An integration consultant interacts with clients (both business and technical personnel) on a constant basis. Hence, it is necessary that an Integration Consultant have extremely good communication skills, should be able to listen carefully to clients and facilitate information gathering sessions.

Skills/Experience requirements:

Overall 5 to 8 years of IT industry experience
Undergraduate / Graduate in Computer Science or Computer Applications such as B. Sc. / B.C.A. / B. Tech. / B. E. / M. Sc. / M. Tech. / M. E. / M.C.A.
Strong experience in understanding business requirements and converting those requirements into detailed functional and technical specifications
5-6 years’ experience with ETL tool preferably Kettle with knowledge on Metadata Injection, Kettle DB logging, Carte.
5-6 years’ experience in writing PL/SQL or T-SQL programming and queries on Oracle / SQL Server
Strong knowledge on RDBMS concept and OLTP system architecture.
Minimum 4 years’ experience in writing shell scripts on UNIX Sun Solaris
Competent with SQL/database, SQL Server / Postgres, SSRS and other analytical programs, with the desire and ability to understand new software applications
Experience reviewing query performance and optimizing/developing more efficient code
Experience with creating table indexes to improve database performance
Experience writing complex operations, views, stored procedures, triggers and functions to support business needs in a high availability environment
Strong knowledge on source code control mechanism on any tool. Knowledge on GIT / BitBucket is added advantage.
Strong knowledge of XML and JSON structures and Jenkins.
Experience of job scheduling and working knowledge on at least one 3rd party scheduler
Hands-on experience in AWS services like PostgreSQL, Aurora, Lambda is preferred
Ability to perform data research and root cause analysis on data issues/discrepancies.
Experience utilizing SOAP and REST to access web services
Experience in Javascript, HTML, CSS
Excellent written and verbal communication skills
Excellent inter-personal skills and comfortable establishing professional relationships especially remotely (electronic, phone, written)
Proven ability to plan and execute effectively to meet critical time-sensitive objectives
Ability to effectively work alone and independently
Experience in either the Banking or Financial Industry is preferred
Experience in SSRS reports development
Working knowledge of Python scripting is preferred
Good mentorship skills
Ability to deliver effectively in high pressure situations