BI Developer

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.

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

Hiring for Data Analyst

Exp : 5 - 7 yrs

Edu : BE/B.Tech

Work Location : Noida WFO

Skills :

Expertise in SQL Server, including database design, performance tuning, query optimization, and security.

Hands-on experience developing ETL solutions using SSIS, Azure Data Factory (ADF), and Python.

Only Immediate joiners are considered.

Key Skills:

Technical Skills

• Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
• DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
• Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
• Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
• SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
• Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
• Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
• API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
• Knowledge of data visualization best practices and UI/UX principles for dashboard design
• Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)

Additional Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Business Analytics, or related field
• Strong analytical and problem-solving abilities
• Excellent communication skills to work with both technical and non-technical stakeholders
• Ability to manage multiple projects and prioritize tasks effectively
• Detail-oriented with commitment to delivering high-quality work
• Client-facing experience with ability to gather requirements and present solutions

Preferred Qualifications

• Microsoft Power BI certification (PL-300 or equivalent)
• Experience with Azure ecosystem (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database)
• Knowledge of other Microsoft BI tools (SSRS, SSAS, Excel Power Pivot)
• Familiarity with Python or R for advanced analytics integration
• Experience with Dataflows and incremental refresh strategies
• Understanding of API development for custom visuals or Power BI embedded solutions
• Experience working in Agile/Scrum development environments

Senior Software Engineer – SQL Server / T-SQL

Chennai | IIT Madras Research Park | Full-Time

About Novacis Digital

Novacis Digital is a product-first technology company building AI-driven platforms and large-scale data systems. Our products process complex, high-volume data to power real-time analytics and GenAI-driven experiences.

We don’t see SQL as “just a database layer” - we treat it as a core compute engine. If you love writing efficient SQL and solving performance problems, this is the role for you.

What You Will Do

·      Design and build complex T-SQL stored procedures involving Dynamic SQL, along with views, functions, and triggers

·      Implement flexible, metadata-driven query frameworks using sp_executesql and parameterized Dynamic SQL

·      Engineer high-performance, set-based queries using CTEs, window functions, temp tables and table variables

·      Optimize queries using execution plans, statistics and DMVs

·      Refactor inefficient queries and redesign schemas for performance and scalability

·      Solve real-world challenges related to locks, blocking, deadlocks and transaction isolation

·      Collaborate with application engineers to build reliable, high-performance data access layers

What We’re Looking For

We’re looking for true SQL engineers — people who think in execution flow, logic and data behavior rather than just syntax.

You should have:

·      4+ years of deep hands-on experience with Microsoft SQL Server & T-SQL

·      Strong expertise in:

o  Stored Procedures (with Dynamic SQL)

o  Views

o  Functions

o  Triggers

·      Strong experience with:

o  Dynamic SQL best practices and secure execution patterns

o  Indexing strategies and query plan optimization

o  Handling parameter sniffing and plan instability

·      Strong knowledge of:

o  Temp tables vs table variables

o  Cardinality estimation

o  Cost-based optimization concepts

Nice to Have

·      Exposure to GenAI data pipelines or analytical architectures

·      Exposure to Graph, Vector and No SQL Databases

How We Work

·      We write production-grade T-SQL

·      We value performance, clarity, and correctness

·      We invest heavily in query readability and maintainability

·      Engineering quality is non-negotiable

Apply Now

If you enjoy designing complex Dynamic SQL-powered stored procedures and tuning systems at scale, we’d like to talk.

Job Summary

The Technical Lead will be responsible for overseeing and leading projects related to Azure Data Factory (ADF), Azure Databricks, SQL, Oracle PL/SQL, and Python. The role involves designing, developing, and implementing data solutions while ensuring they meet the business requirements and align with best practices. (1.) Key Responsibilities

1. Lead and manage end-to-end data engineering projects using azure data factory, azure databricks, sql, oracle pl/sql, and python.

2. Collaborate with stakeholders to gather and understand requirements for data pipelines and analytics solutions.

3. Design and develop etl processes, data models, and data integration solutions.

4. Provide technical guidance and mentorship to the team members.

5. Ensure data quality, data governance, and data security standards are maintained throughout the project lifecycle.

6. Troubleshoot and optimize data pipelines and processes for performance and efficiency.

7. Stay updated on the latest trends and technologies in data engineering and contribute to continuous improvement efforts.

Skill Requirements

1. Proficiency in azure data factory (adf) and azure databricks for building and managing data pipelines.

2. Strong experience with sql and oracle pl/sql for data querying and manipulation.

3. Advanced programming skills in python for scripting and data processing tasks.

4. Knowledge of data modeling, data warehousing concepts, and database design principles.

5. Ability to work in a collaborative team environment and communicate effectively with stakeholders.

6. Strong analytical and problem-solving skills with attention to detail.

7. Experience in data visualization tools and techniques is a plus.

Certifications: Relevant certifications in Azure Data Factory, Azure Databricks, SQL, Oracle PL/SQL, or Python are advantageous.

Skill (Primary)

Data Fabric-Azure-Azure Data Factory (ADF)

Job Description

We are looking for an experienced Azure Synapse Data Engineer with strong hands-on expertise in Azure data engineering, data warehousing, ETL/ELT, and SQL performance optimization.

Key Responsibilities

• Design, develop, and optimize solutions using Azure Synapse Analytics.
• Build and maintain data integration pipelines using Azure Data Factory (ADF) and Synapse Pipelines.
• Design and implement scalable Azure Data Lake Storage Gen2 (ADLS Gen2) architectures.
• Develop robust and high-performance ETL/ELT frameworks for enterprise data platforms.
• Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
• Identify and resolve performance bottlenecks across data movement and transformation processes.
• Ensure data quality, availability, reliability, and consistency across analytics platforms.
• Perform advanced SQL query analysis and optimization.
• Analyze execution plans and optimize complex analytical workloads.
• Configure and tune Synapse Dedicated SQL Pools.
• Design efficient partitioning strategies for large datasets.
• Optimize indexing, statistics, and workload distribution to improve query performance.

Mandatory Skills

• Azure Synapse Analytics
• Azure Data Factory (ADF)
• Synapse Pipelines
• ADLS Gen2
• ETL/ELT
• Strong SQL
• Synapse Dedicated SQL Pool
• SQL query/execution plan optimization
• Partitioning, indexing, and statistics
• Azure data warehouse / data lake architecture
• Performance tuning and troubleshooting

Ideal Candidate

A strong Azure Data Engineer with hands-on experience in Synapse + ADF + ADLS Gen2 + Advanced SQL + Dedicated SQL Pool performance tuning.

Key Skills:

Technical Skills

• Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
• DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
• Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
• Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
• SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
• Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
• Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
• API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
• Knowledge of data visualization best practices and UI/UX principles for dashboard design
• Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)

Additional Required Qualifications

• Bachelor’s degree in computer science, Information Systems, Business Analytics, or related field
• Strong analytical and problem-solving abilities
• Excellent communication skills to work with both technical and non-technical stakeholders
• Ability to manage multiple projects and prioritize tasks effectively
• Detail-oriented with commitment to delivering high-quality work
• Client-facing experience with ability to gather requirements and present solutions

Preferred Qualifications

• Microsoft Power BI certification (PL-300 or equivalent)
• Experience with Azure ecosystem (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database)
• Knowledge of other Microsoft BI tools (SSRS, SSAS, Excel Power Pivot)
• Familiarity with Python or R for advanced analytics integration
• Experience with Dataflows and incremental refresh strategies
• Understanding of API development for custom visuals or Power BI embedded solutions
• Experience working in Agile/Scrum development environments

Location: 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.