Datawarehouse Developer at Wissen Technology · Bengaluru (Bangalore) · 5 - 8 years · ₹1L - ₹18L / yr · Profitable · Posted 3 Aug 2024
Position Description
We are looking for a highly motivated, hands-on Sr. Database/Data Warehouse Data Analytics developer to work at our Bangalore, India location. Ideal candidate will have solid software technology background with capability in the making and supporting of robust, secure, and multi-platform financial applications to contribute to Fully Paid Lending (FPL) project. The successful candidate will be a proficient and productive developer, a team leader, have good communication skills, and demonstrate ownership.
Responsibilities
- Produce service metrics, analyze trends, and identify opportunities to improve the level of service and reduce cost as appropriate.
- Responsible for design, development and maintenance of database schema and objects throughout the lifecycle of the applications.
- Supporting implemented solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, and communicating functional and technical issues.
- Helping the team by taking care of production releases.
- Troubleshoot data issues and work with data providers for resolution.
- Closely work with business and applications teams in implementing the right design and solution for the business applications.
- Build reporting solutions for WM Risk Applications.
- Work as part of a banking Agile Squad / Fleet.
- Perform proof of concepts in new areas of development.
- Support continuous improvement of automated systems.
- Participate in all aspects of SDLC (analysis, design, coding, testing and implementation).
Required Skill
- 5 to 7 Years of strong database (SQL) Knowledge, ETL (Informatica PowerCenter), Unix Shell Scripting.
- Database (preferably Teradata) knowledge, database design, performance tuning, writing complex DB programs etc.
- Demonstrate proficient skills in analysis and resolution of application performance problems.
- Database fundamentals; relational and Datawarehouse concepts.
- Should be able to lead a team of 2-3 members and guide them in their day to work technically and functionally.
- Ensure designs, code and processes are optimized for performance, scalability, security, reliability, and maintainability.
- Understanding of requirements of large enterprise applications (security, entitlements, etc.)
- Provide technical leadership throughout the design process and guidance with regards to practices, procedures, and techniques. Serve as a guide and mentor for junior level Software Development Engineers
- Exposure to JIRA or other ALM tools to create a productive, high-quality development environment.
- Proven experience in working within an Agile framework.
- Strong problem-solving skills and the ability to produce high quality work independently and work well in a team.
- Excellent communication skills (written, interpersonal, presentation), with the ability to easily and effectively interact and negotiate with business stakeholders.
- Ability and strong desire to learn new languages, frameworks, tools, and platforms quickly.
- Growth mindset, personal excellence, collaborative spirit
Good to have skills.
- Prior work experience with Azure or other cloud platforms such as Google Cloud, AWS, etc.
- Exposure to programming languages python/R/ java and experience with implementing Data analytics projects.
- Experience in Git and development workflows.
- Prior experience in Banking and Financial domain.
- Exposure to security-based lending is a plus.
- Experience with Reporting/BI Tools is a plus.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Wissen Technology
About
The Wissen Group was founded in the year 2000. Wissen Technology, a part of Wissen Group, was established in the year 2015. Wissen Technology is a specialized technology company that delivers high-end consulting for organizations in the Banking & Finance, Telecom, and Healthcare domains.
With offices in US, India, UK, Australia, Mexico, and Canada, we offer an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation.
Leveraging our multi-site operations in the USA and India and availability of world-class infrastructure, we offer a combination of on-site, off-site and offshore service models. Our technical competencies, proactive management approach, proven methodologies, committed support and the ability to quickly react to urgent needs make us a valued partner for any kind of Digital Enablement Services, Managed Services, or Business Services.
We believe that the technology and thought leadership that we command in the industry is the direct result of the kind of people we have been able to attract, to form this organization (you are one of them!).
Our workforce consists of 1000+ highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like MIT, Wharton, IITs, IIMs, and BITS and with rich work experience in some of the biggest companies in the world.
Wissen Technology has been certified as a Great Place to Work®. The technology and thought leadership that the company commands in the industry is the direct result of the kind of people Wissen has been able to attract. Wissen is committed to providing them the best possible opportunities and careers, which extends to providing the best possible experience and value to our clients.
Company social profiles
Similar jobs (4)
Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile
2
Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.
3
Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.
4
Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.
5
Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.
6
Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.
7
Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.
8
Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.
9
Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.
10
Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.
PythonLocation: Hyderabad / Chennai
Experience: 5+ years
Employment type: Full-time, permanent
Work Hours: General Shift
website: www.amazech.com
Qualifications:
- B.E./B.Tech/M.E./M.Tech in Computer Science, Information Technology, Data Science, or related disciplines.
- Strong academic background with relevant industry experience in Data Engineering and Data Warehousing.
Key Responsibilities:
· Design, develop, and maintain scalable data warehouse solutions using Snowflake.
· Write, optimize, troubleshoot, and enhance Snowflake SQL queries with a focus on performance and scalability.
· Develop and support ETL processes using Talend to ensure reliable and efficient data movement.
· Collaborate with business, analytics, and application teams to enable reporting, dashboards, metrics, and data exploration capabilities.
· Perform data analysis and resolve issues across data ingestion, transformation, and reporting pipelines.
· Debug and troubleshoot Python-based data processing scripts and automation workflows.
· Implement best practices for data quality, testing, deployment, and code reviews.
· Work across UI, API, and Data Warehouse layers to support end-to-end data integration and business requirements.
· Monitor, optimize, and maintain data warehouse performance and operational stability.
· Create and maintain technical documentation, data models, and process workflows.
Required Skills and Experience:
· Strong hands-on expertise in Snowflake Data Warehouse.
· Advanced SQL skills with experience handling large-scale datasets.
· Strong understanding of Data Warehousing concepts, dimensional modelling, and data architecture.
· Hands-on experience with Analytical SQL functions, query tuning, and performance optimization.
· Experience developing and maintaining ETL solutions using Talend.
· Proficiency in Python for scripting, debugging, automation, and data processing.
· Experience integrating UI, API, and Data Warehouse workflows.
· Strong problem-solving and analytical skills.
· Experience with testing, code reviews, and deployment best practices.
· Excellent communication and stakeholder management skills.
Data & BI Support Specialist - JD
Professional Work Experience
• Microsoft SQL Server skills including SSIS, SSAS, DW and Power BI
• ADF, Databricks and Azure synpase skills will be preffered
• Excellent E-Mail and phone communication skills
• Experience in guiding BI Support Engineers
• Experience in global environment
• Ability to read code and support applications, reports and processes
• Excellent analytical and problem-solving skills
• Ability to contribute both independently and as part of a team
• Excellent listening, communication, interperson
• Excellent analytical and problem-solving skills
Looking for a strong Microsoft SQL Server + SSIS resource with L1, L2, L3 (mix) Production Support experience. Role is 75% support and 25% development. Candidate should be able to troubleshoot existing SQL code, ETL jobs, incidents, and perform RCA. Power BI is only 10%. Please prioritize SQL Support Engineers, SSIS Developers, and SQL Developers with production support exposure
Must have experience in Java
Must have experience in Spark
Must have experience in ETL coding
Strong expertise in coding
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon