SSIS Developer

4 weeks ago

Bangalore, India RapidBraiins Full time

Overview :


At EY, were dedicated to helping our clients, from startups to Fortune 500 companies and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments.


Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:


- Support, coaching and feedback from some of the most engaging colleagues around


- Opportunities to develop new skills and progress your career


- The freedom and flexibility to handle your role in a way thats right for you


Job Description :

  • The ideal candidate must have a good understanding of the value of data warehouse and ETL and proven experience in delivering solutions to different lines of business and technical leadership.
  • Working with the client team, perform development and provide L3 support to database integrations and data warehouse using SQL Server, SSIS, Azure, 3rd party tools, etc.
  • Good research, analysis and problem-solving skills
  • Ability to estimate work items in a systemic manner
  • Strong understanding of Software Development Life Cycle (including agile development methodology)
  • Hands on development and maintenance of the SQL based systems and various associated components for data ingestion, transformation and processing.
  • Hands on development and maintenance of integrations with various (including bespoke) Financial (Applications and Management Information Systems), Underwriting and Claims Management Systems and other systems based on business requirements.
  • Ensure data quality and accuracy by implementing business and technical reconciliations via scripts, profiling and data analysis; analyse and create data mappings.
  • Develop and support objects and code for data profiling, extraction, load and updates.
  • Provide and maintain documentation for all developed objects and processes, in strict timelines.
  • Integration testing of deliverables.
  • Develop and run test scripts to ensure the quality of code and integrity.
  • Use source code control repository (using VSTS, GIT) preferred GIT
  • Following data / integration design patterns and architecture as prescribed by the Architects. Come up with suggestions and recommendations where required

Skill Set & Experience :

  • Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of SQL, PL/SQL, SSIS, SSAS knowledge and industry expertise to support delivery to clients
  • Demonstrate management and an ability to lead projects or teams individually
  • Experience in team management, communication, and presentation.
  • Minimum of 3 years of ETL development on SQL Integration Projects using SQL Server Integration Services (SSIS) and SQL Server database objects
  • Experience in implementing Type 2 Dimension Data models and data warehouse ETL techniques for historical data
  • Experience in development of complex / enterprise data warehouse implemented over standard RDBMS (using SQL Server Integration Services (SSIS) and SQL Server database objects)
  • Ability to understand/re-write nested complex SQL script
  • Experience of analysis and resolution of data quality and integration issues
  • Experience of Database queries (SQL) and performance tuning
  • Experience in providing and maintaining technical documentation, specifically Data Mapping and Low Level / ETL Design Documentation
  • Experience of working both independently and collaboratively with various teams and global stakeholders (Business Analysts/Architects/Support/Business) in an agile approach while working on projects or data quality issues
  • Experience of upgrading/converting SQL based system to new versions (SQL Code and Objects) preferable
  • Microsoft Azure - PaaS fundamental knowledge - preferable
  • Experience in Attunity tools (e.g., Compose, replicate) preferable
  • Insurance Domain Experience nice to have
  • Experience working on SSAS Cubes (development & design), along with troubleshooting performance and processing issues nice to have
  • Experience in BIML based development nice to have
  • Experience in source control using GIT
  • Possess and demonstrate deep knowledge of data warehouse concepts, techniques, various design alternatives, and overall data warehouse strategies.
  • Knowledge of Type 2 Dimension Data model and data warehouse ETL techniques for historical data
  • Excellent communication and interpersonal skills
  • Ability to work in a geographically dispersed team environment.
  • Demonstrable ability to work on multiple activities simultaneously, and work to deadlines.
  • Good written and verbal communication and interpersonal skills.
  • Good understanding of development methodologies, frameworks and best practices.
  • Ability to work outside of regular working hours where necessary to ensure global migrations are successfully tested.

Additional Requirements :

  • Strong knowledge of ELT/ETL concepts, design and coding
  • Expertise in data handling to resolve any data issues as per client needs
  • Experience in designing and developing Oracle object such as
  • Tables, Views, Indexes, Materialized Views and Analytical functions
  • Experience of creating complex SQL queries for retrieving, manipulating, checking and migrating complex datasets in oracle
  • Experience in SQL tuning and optimization using explain plan and SQL trace files
  • Candidate ideally should have good knowledge of ETL technologies/tools such as SSAS, SSRS, Azure Analysis Services, Azure Power Apps.
  • Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
  • Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
  • Candidates having additional knowledge of BI tools such as PowerBI, Tableau, etc will be preferred.
  • Experience with Cloud data bases and multiple ETL tools.

Skills & Requirements :

  • Knowledge of ELT/ETL concepts, design and coding Knowledge of ELT/ETL concepts, design and coding, ETL development, SQL Server Integration Services (SSIS), SQL Server database, RDBMS, SQL script, Data Mapping, ETL Design, Attunity tools like Compose, replicate, SSAS Cubes, Azure Analysis Services, Azure Power Apps.
(ref:hirist.tech)

  • SSIS Developer

    5 days ago

    bangalore, India CGI Full time

    Senior SSIS / Informatica Developer cum Support AnalystPosition DescriptionSkills Required with 7+ Years experienceProficient in designing, developing, and maintaining ETL processes using tools such as Informatica, and SSIS. Solid understanding of data integration concepts, data mapping, and data modeling.Expertise in SQL programming and relational database...

  • Ssis Sql Developer With Guidewire

    4 weeks ago

    bangalore, India Nityo Infotech Full time

    "Guidewire ETL Developer – SSIS+SQLMust have extensive working knowledge of SSIS, SQL and Data WarehousingHands-on design, workflow, development and performance tuning experience in data warehouse, SQL Server/Oracle.Must be experienced in designing and building complete ETL/SSIS process Should have good exposure in writing Stored Procedures, Functions,...

  • SSIS/SQL Server Developer

    1 week ago

    bangalore, India Quess Full time

    About Us “Quess IT Staffing is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names...

  • SQL/SSIS Developer

    2 weeks ago

    Any Location/Bangalore/Hyderabad, India Saasvaap techies pvt lmd Full time

    As a part this team, you will :- Develop, test, and deploy SQL scripts and stored procedures to support business requirements.- Design, develop, and optimize SSIS packages for ETL processes, data migration, and data integration.- Work closely with business analysts and stakeholders to understand data requirements and translate them into technical solutions.-...

  • SQL/SSIS Developer

    3 weeks ago

    Any Location/Bangalore/Hyderabad, IN Saasvaap techies pvt lmd Full time

    As a part this team, you will :- Develop, test, and deploy SQL scripts and stored procedures to support business requirements.- Design, develop, and optimize SSIS packages for ETL processes, data migration, and data integration.- Work closely with business analysts and stakeholders to understand data requirements and translate them into technical solutions.-...

  • ETL Developer

    5 days ago

    Bangalore/Hyderabad, India Hitya Global Full time

    Job Position : We are seeking an ETL Sr Software Engineer who will be responsible for analysis, design, and implementation of code/workflows/sessions/mappings/query changes within application and provide end to end application support. ETL SSE's primary role will be to have an end-to-end responsibility in data Migration from Legacy system to HR Payor...

  • ETL Developer

    6 days ago

    Bangalore/Hyderabad, Karnataka, India Hitya Global Full time

    Job Position :We are seeking an ETL Sr Software Engineer who will be responsible for analysis, design, and implementation of code/workflows/sessions/mappings/query changes within application and provide end to end application support. ETL SSE's primary role will be to have an end-to-end responsibility in data Migration from Legacy system to HR Payor...

  • SSIS Developer

    17 hours ago

    Bangalore/Gurgaon/Gurugram, India TCCS Full time

    Job Title : SSIS Developer with ETL and US Helathcare domain ExpLocation : BengaluruJob description : 6 plus years of experience in Developing, Designing, and implementing large scale enterprise ETL applications. 6 plus years of experience in SSIS/Informatica/Data stage and SQL/Oracle and related tech stacks Experience with US healthcare Experience with...

  • SSIS Developer

    1 day ago

    Bangalore/Gurgaon/Gurugram, IN TCCS Full time

    Job Title : SSIS Developer with ETL and US Helathcare domain ExpLocation : BengaluruJob description :6 plus years of experience in Developing, Designing, and implementing large scale enterprise ETL applications.6 plus years of experience in SSIS/Informatica/Data stage and SQL/Oracle and related tech stacksExperience with US healthcareExperience with Amisys...

  • SSIS Developer

    4 weeks ago

    bangalore, India HyreFox Consultants Full time

    Job Description: # 4 years of experience in the IT Industry# 3 years of DW Project execution experience and a good understanding of DW concepts# 2 years of Development experience in TSQL & SSIS, SQL server 2012 19# Prior experience in data analysis and SQL query tuning.# Good Communication skills Preferable # Banking and Financial domain experience...

  • SSIS / SSRS with SQL, .Net

    4 weeks ago

    bangalore, India XENIA Full time

    Job Role: Microsoft MSBI (SSIS) and T SQL - SQL Server Resource Required Skills • Strong hands on experience with RDBMS (SQL Server 2012) and SSIS with Approx 5 years exposure• Experience with database consolidation and integration development projects, specifically focused on customer data desired.• Expertise in relational...

  • ETL Specialist

    2 weeks ago

    Bangalore, India Nilasu consulting Full time

    Position Overview :We are seeking an experienced ETL Specialist to join our team. The ETL Specialist will be responsible for designing, developing, and maintaining ETL processes using SSIS, Talend, and SQL. The ideal candidate will have a strong background in ETL tools, database management, and data pipeline management.Key Responsibilities :- ETL...

  • ETL Specialist

    2 weeks ago

    Bangalore, Karnataka, India Nilasu consulting Full time

    Position Overview :We are seeking an experienced ETL Specialist to join our team. The ETL Specialist will be responsible for designing, developing, and maintaining ETL processes using SSIS, Talend, and SQL. The ideal candidate will have a strong background in ETL tools, database management, and data pipeline management.Key Responsibilities :- ETL...

  • MySQL Developer

    4 weeks ago

    Chennai,Bangalore,Hyderabad,Noida, India Resource Tree Global Services Full time

    Job Description :Job Title : MySQL DeveloperResponsibilities : - Strong development experience in MySQL, complex stored procedure and functions- Proficient in writing and optimizing SQL statements - Handle common database procedures, such as upgrade, backup, recovery, migration, etc. - Managing performance, security, and availability of databases - Write...

  • Azure Data Engineer

    2 weeks ago

    Any Location/Bangalore, India Zyoin group Full time

    Skills : Proficiency in Azure Data Engineering Strong expertise in SSIS (SQL Server Integration Services) Extensive experience in ETL (Extract, Transform, Load) processes Advanced skills in Power BI for data visualization and analytics Responsibilities : Design, develop, and implement data solutions leveraging Azure Data Engineering services. Utilize SSIS...

  • Azure Data Engineer

    3 weeks ago

    Any Location/Bangalore, IN Zyoin group Full time

    Skills :Proficiency in Azure Data EngineeringStrong expertise in SSIS (SQL Server Integration Services)Extensive experience in ETL (Extract, Transform, Load) processesAdvanced skills in Power BI for data visualization and analyticsResponsibilities :Design, develop, and implement data solutions leveraging Azure Data Engineering services.Utilize SSIS for...

  • Junior Data Engineer

    2 weeks ago

    Bangalore/Noida, India Xperthunt Full time

    About the Role : We're seeking a passionate and detail-oriented Junior Data Engineer to join our growing team! In this role, you'll play a vital role in designing, developing, and maintaining data pipelines to support our organization's data-driven initiatives. You'll work closely with data analysts, scientists, and other engineers to...

  • Junior Data Engineer

    3 weeks ago

    Bangalore/Noida, IN Xperthunt Full time

    About the Role :We're seeking a passionate and detail-oriented Junior Data Engineer to join our growing team! In this role, you'll play a vital role in designing, developing, and maintaining data pipelines to support our organization's data-driven initiatives.You'll work closely with data analysts, scientists, and other engineers to ensure...

  • Tableau Developer( 8+ Years)

    4 weeks ago

    bangalore, India Encora Inc. Full time

    Senior Tableau Developer - JD 8+ years-experience implementing ETL for Data Warehouse and Business Intelligence Solution 8+ years-experience in RDBMS design, development and performance tuning 4+ years-experience with ETL/ELT on AWS or other cloud environments with working experience on Redshift or Snowflake 2+ years-experience using Tableau ...

  • Azure Data Engineer

    4 weeks ago

    Bangalore, India Infiniti Research Full time

    Company: Quantzig Analytics. Job Role : Azure Data Engineer. About Quantzig: Quantzig is a global analytics and advisory firm with offices in the US, UK, Canada, China, and India. We have assisted our clients across the globe with end-to-end advanced analytics, visual storyboarding, Machine Learning and data engineering solutions implementation for prudent...