Senior SQL BI Developer ( ETL)
Bangalore, India
Full Time
Experienced
Simeio is a global identity and access management service provider focused on protecting organizations key data and access requirements to business-critical systems and applications.
Simeio provides services such as Access Management, IGA, PAM & CIAM plus our wider service offerings include support, upgrades, governance and application onboarding.
The Opportunity:
Skilled SQL BI Developer responsible for designing, developing, and maintaining ETL processes to support our data integration and data warehousing needs. Will work closely with data analysts, data scientists, and other stakeholders to ensure data is accurately and efficiently processed and available for analysis.
The Role:
Design and Architecture:
Design, develop, and maintain ETL processes using SQL and ETL tools.
Extract, transform, and load data from various data sources into data warehouses and data marts.
Implement data validation and error handling mechanisms.
Design, develop, and maintain SQL databases and queries.
Write and optimize complex SQL queries for data extraction and reporting.
Automate SSIS packages using SQL Agent.
Hands on experience with windows scheduler and bat file processing
Develop stored procedures, functions, and triggers to support application development.
Performance Monitoring and Optimization:
Optimize and tune ETL processes for performance and scalability.
Monitor and troubleshoot database issues to ensure high availability and performance.
Monitor and troubleshoot ETL processes to ensure data accuracy and integrity.
Stakeholder Collaboration:
Collaborate with data analysts and data scientists to understand data requirements and ensure data quality.
Best Practices and Standard
Develop and maintain documentation for ETL processes and data flows.
Participate in code reviews and provide feedback to ensure best practices are followed.
Stay up to date with industry trends and best practices in ETL and data integration.
Preferred Skills:
Proven experience as an SQL ETL Developer or similar role.
Strong proficiency in SQL and experience with ETL tools (e.g., SSIS, Informatica, Talend).
Experience with data warehousing concepts and technologies.
Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).
Familiarity with data visualization tools (e.g., Tableau, Power BI).
Knowledge of scripting languages (e.g., Python, Shell scripting, C#).
Strong problem-solving and analytical skills.
Excellent communication and collaboration skills.
Ability to work independently and as part of a team.
About Simeio:
Simeio has over 650 talented employees across the globe. We have offices in USA (Atlanta HQ and Texas), India, Canada, Costa Rica and UK.
Founded in 2007, and now backed by private equity company ZMC, Simeio is recognized as a top IAM provider by industry analysts.
Alongside Simeio’s identity orchestration tool ‘Simeio IO’ - Simeio also partners with industry leading IAM software vendors to provide access management, identity governance and administration, privileged access management and risk intelligence services across on-premise, cloud, and hybrid technology environments.
Simeio provides services to numerous Fortune 1000 companies across all industries including financial services, technology, healthcare, media, retail, public sector, utilities and education.
Simeio is an equal opportunity employer. If you require assistance with completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to our recruitment team - [email protected].
Thank you
About your application:
We review every application received and will get in touch if your skills and experience match what we’re looking for. If you don’t hear back from us within 10 days, please don’t be too disappointed – we may keep your CV on our database for any future vacancies and we would encourage you to keep an eye on our career opportunities as there may be other suitable roles.
Simeio provides services such as Access Management, IGA, PAM & CIAM plus our wider service offerings include support, upgrades, governance and application onboarding.
The Opportunity:
Skilled SQL BI Developer responsible for designing, developing, and maintaining ETL processes to support our data integration and data warehousing needs. Will work closely with data analysts, data scientists, and other stakeholders to ensure data is accurately and efficiently processed and available for analysis.
The Role:
Design and Architecture:
Design, develop, and maintain ETL processes using SQL and ETL tools.
Extract, transform, and load data from various data sources into data warehouses and data marts.
Implement data validation and error handling mechanisms.
Design, develop, and maintain SQL databases and queries.
Write and optimize complex SQL queries for data extraction and reporting.
Automate SSIS packages using SQL Agent.
Hands on experience with windows scheduler and bat file processing
Develop stored procedures, functions, and triggers to support application development.
Performance Monitoring and Optimization:
Optimize and tune ETL processes for performance and scalability.
Monitor and troubleshoot database issues to ensure high availability and performance.
Monitor and troubleshoot ETL processes to ensure data accuracy and integrity.
Stakeholder Collaboration:
Collaborate with data analysts and data scientists to understand data requirements and ensure data quality.
Best Practices and Standard
Develop and maintain documentation for ETL processes and data flows.
Participate in code reviews and provide feedback to ensure best practices are followed.
Stay up to date with industry trends and best practices in ETL and data integration.
Preferred Skills:
Proven experience as an SQL ETL Developer or similar role.
Strong proficiency in SQL and experience with ETL tools (e.g., SSIS, Informatica, Talend).
Experience with data warehousing concepts and technologies.
Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).
Familiarity with data visualization tools (e.g., Tableau, Power BI).
Knowledge of scripting languages (e.g., Python, Shell scripting, C#).
Strong problem-solving and analytical skills.
Excellent communication and collaboration skills.
Ability to work independently and as part of a team.
About Simeio:
Simeio has over 650 talented employees across the globe. We have offices in USA (Atlanta HQ and Texas), India, Canada, Costa Rica and UK.
Founded in 2007, and now backed by private equity company ZMC, Simeio is recognized as a top IAM provider by industry analysts.
Alongside Simeio’s identity orchestration tool ‘Simeio IO’ - Simeio also partners with industry leading IAM software vendors to provide access management, identity governance and administration, privileged access management and risk intelligence services across on-premise, cloud, and hybrid technology environments.
Simeio provides services to numerous Fortune 1000 companies across all industries including financial services, technology, healthcare, media, retail, public sector, utilities and education.
Simeio is an equal opportunity employer. If you require assistance with completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to our recruitment team - [email protected].
Thank you
About your application:
We review every application received and will get in touch if your skills and experience match what we’re looking for. If you don’t hear back from us within 10 days, please don’t be too disappointed – we may keep your CV on our database for any future vacancies and we would encourage you to keep an eye on our career opportunities as there may be other suitable roles.
Simeio is an equal opportunity employer. If you require assistance with completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to any of the recruitment team at recruitment@simeio.com or +1 404-882-3700.
Apply for this position
Required*