SSIS Developer at Bangalore based company · Bengaluru (Bangalore) · 5 - 9 years · ₹10L - ₹16L / yr · Posted 14 Apr 2023
Bangalore
Immediate
- Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
- Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
- Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
- Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
- Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
- Create and execute test plans,document issues and track progress at resolving issues.
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs (3)
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
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.
PythonWe are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.
Qualifications and Skills:
- Minimum 4 years of experience as a Data Engineer
- Hands-on experience with Azure cloud-based data solutions
- Fabric experience is a must – designing, implementing, and managing data workflows and pipelines
- Expertise in database design and management, including SQL databases such as SQL Server
- Proficient in ETL (Extract, Transform, Load) design for data integration and processing
- Strong knowledge of data modeling principles and techniques
- Experience with Azure Data Factory (ADF) for orchestrating data workflows
- Ability to analyze and translate data into actionable insights, reports, and visualizations
- Proficiency in Power BI for reporting and data visualization
Desirable Skills:
- Experience with Power BI Report Builder / Reporting Services
- Knowledge of statistical analysis or Data Science
- Experience within the UK Insurance industry is a plus
- Python or R coding skills
Responsibilities:
- Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
- Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
- Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
- Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
- Implement different methods of streaming data and create reconciliations for datasets
- Build analytical models to support reporting and analytics
- Collaborate with an agile delivery team to work on the backlog of specified work
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon