Ssis and Db Development-jp1

3 days ago

Bengaluru, India Atlas Systems Full time

**Location: Bangalore**

**Shift: EST Timings**

**About Atlas**:
Atlas Systems Inc. is a Software Solutions company headquartered in East Brunswick, NJ. Incorporated in 2003, Atlas provides comprehensive range of solutions in the area of GRC, Technology, Procurement, Healthcare Provider and Oracle to customers across the globe. Combining our unparalleled experience of over a decade in the software industry and global reach, we have grown with extensive capabilities across industry verticals.

**SSIS, Database development, data migration roles and responsibility**:
Atlas needs a strong database developer to support one of our banking clients to help with load, transform the data from the bank source systems in MS Access, SQL Server and Oracle to the Target system in SQL Server 2019 version..
- This position requires thorough understanding of the production database environment to read the data without causing performance penalty to the existing source systems. Every month end, the required data is automated from back end to back end system.
- Legacy MS Access based reports and often broken when underlying DB schema is changed.
- The MS Access based reports will be migrated to data visualization tools such as Microsoft Power BI or QlikView or Tableau, experience in migration required
- The database developer consultant work with Database engineering team members to deliver the services.
- This role needs a consultant with combination of strong database development, knowledge of DBA skills and strong ETL - SSIS packages development skills.
- Must have reporting tools experience with Microsoft Power BI or QlikView or Tableau or SSRS.
- Having DBA skills is nice to have

**Requirements**:

- A minimum of 3 years of experience with SQL/TSQL developing TSQL, stored procs, views, triggers, and functions
- 3 years of experience developing ETL packages using SSIS, SSRS, and/or SSAS
- 1 to 3 years of programming experience in one of the leading languages such as C#, Java,.Netetc.
- Experience supporting SQL/server environment: SQL tunning, optimization, partitioning, datafiles, drives and space configuration
- Assists in collecting new requirements for development to meet customer’s needs.
- Provides suggestions as appropriate on situations requiring changes in resources, impacts on established policies, broad program goals, or projected timetables.
- Writes and maintains program documentation.
- Technical documentation of the work including all scripts and commands applicable in a standard word format.
- Provide status of the accomplishment on a daily or weekly basis.
- Implement changes to the production environment as per the Buyer’s standard change management guidelines established via ServiceNow (AKA: SNOW) tool for Incident Tickets, Service Requests and Change Requests.
- Work independently on all complex projects and within a collaborative team driven environment such as infrastructure groups and other Suppliers.
- Understand current support processes, definition of the to-be processes and gap analysis.
- Provide monthly reports of tasks completed during the month via Jira or Service Now along with the time spent.
- Implement security controls to prevent data loss/leakage or unauthorized access to databases.

  • Ssis

    3 days ago

    Bengaluru, India Tata Consultancy Services Full time

    Designand develop SQL Server stored procedures, functions, views and triggers to beused during the ETL process Designingand developing SSIS / SQL ETL solutions to acquire and prepare data fromnumerous upstream systems for processing by QRM Buildsdata transformations with SSIS including importing data from files, moving datafrom one database platform to...

  • Support- SSIS

    4 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Support-SSIS+ ssis development expSQL Server Integration ServicesProduction supportsecondary skill: CI/CD, DataStage5 to 9 yrsLoc: pune Bengaluru and chennaiThanks & Regards,Indumati

  • SSIS ETL Specialist

    5 days ago

    Bengaluru, Karnataka, India beBeeEtlsupport Full time ₹ 9,00,000 - ₹ 12,00,000

    SSIS Developer PositionWe are seeking a skilled SSIS Developer to join our team.The ideal candidate will be responsible for monitoring production SSIS jobs and ETL pipelines, ensuring timely completion.Investigate and troubleshoot issues related to SSIS packages, providing L3 support by analyzing logs and debugging SQL queries.A proactive approach is...

  • Support- SSIS

    4 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Support-SSIS+ ssis development expSQL Server Integration ServicesProduction supportsecondary skill: CI/CD, DataStage5 to 9 yrsLoc: pune Bengaluru and chennaiThanks & Regards,Indumati NIndumati.nakate@alphacom.inwww.alphacom.in

  • MSBI-SSIS Developer

    4 days ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Job Title: MSBI-SSIS DeveloperLocation : Bangalore.Mandatory Skill : MSBI, TSQL, SQL Server, ADF, Azure SQL MI, PowerBI, SSRS, Azure DevOpsExperience range: Yrs (Min exp 5.5 required)Notice Period: Immediate or 30 D (Note: Please don't apply or share profiles of 60 and 90 D)Job description:· Must have knowledge in SQL Server environment, T-SQL, writing...

  • ssis developer+sql dba

    4 days ago

    Chennai, Bengaluru, Pune, India Coders Brain Full time

    Job DescriptionPrimary Skills:- SQL Server & Advance SQL concepts- SSRS & Crystal Reports- SSIS and its concepts with SQL Jobs & profiler- Azure Data Services (SQL Azure, Azure Data Factory, Data lake)- Experience of Data Migration, Restoration & Archival- Prior development experience with .NET & Web APIRoles & Responsibilities:- Design and develop SQL...

  • SQL DBA + SSIS developer

    5 days ago

    Chennai, Bengaluru, Pune, India Coders Brain Full time

    Job DescriptionRequirement Title :Require ExperiencedSQL DBA + SSISdeveloperAvailability:EST time zone(till 6 PM EST) - ( till 4.30 am IST- approximately)Experience: 8+ YearsPrimary Skills:SQL Server & Advance SQL concepts SSRS & Crystal Reports SSIS and its concepts with SQL Jobs & profiler Azure Data Services (SQL Azure, Azure Data Factory, Data lake)...

  • MSBI-SSIS Developer

    5 days ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Job Title: MSBI-SSIS Developer Location : Bangalore. Mandatory Skill : MSBI, TSQL, SQL Server, ADF, Azure SQL MI, PowerBI, SSRS, Azure DevOps Experience range: 5.5-12 Yrs (Min exp 5.5 required) Notice Period: Immediate or 30 D (Note: Please don't apply or share profiles of 60 and 90 D) Job description: · Must have knowledge in SQL Server environment,...

  • MSBI-SSIS Developer

    3 days ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Job Title: MSBI-SSIS DeveloperLocation : Bangalore.Mandatory Skill : MSBI, TSQL, SQL Server, ADF, Azure SQL MI, PowerBI, SSRS, Azure DevOpsExperience range: 5.5-12 Yrs (Min exp 5.5 required)Notice Period: Immediate or 30 D (Note: Please don't apply or share profiles of 60 and 90 D)Job description:· Must have knowledge in SQL Server environment, T-SQL,...

  • Ssis+ Adf

    4 days ago

    Bengaluru, Karnataka, India Virtusa Full time

    Experience in SQL Server Exp in writing complex stored procedures Exp in database designing and solutioning Performance Improvements Experience in ETL tool - SSIS. In depth knowledge of SSIS Experience in creating complex SSIS packages Knowledge and handson with ADF **About Virtusa** Teamwork, quality of life, professional and personal development:...