Home

Senior SQL (SSIS) Data Engineer -- Hopkins, MN 55343 Remote at Hopkins, Minnesota, USA
Email: [email protected]
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=834860&uid=

From:

Shravan,

Smart Folks INC

[email protected]

Reply to:   [email protected]

Hi  

Greetings from Smart Folks!!!

My name is Kumar we have a job opportunity for you as Informatica Data Archival Lead one of our client based at Hopkins, MN 55343 Remote Please find the Job description below, if you are available and interested, please send us your word copy of your resume with following detail to [email protected] Or please call me on 469 888 5467 to discuss more about this position.  

Job Title: Senior Data Engineer

Location: Hopkins, MN 55343 Remote

Duration: 06 -12 Months

Start Date: ASAP

Job Details:  

Knowledge of more than one technology SQL & TSQL queries & stored procedures, and performance tuning

5 or more years of SSIS development experience with ETL and complex data processing

Knowledge of Agile methodologies

Detailed Job Description

Performs and participates in all required design reviews (e.g., peer reviews, business/partner reviews)

Develops technical specifications/design documents as defined in application/system designs

Develops application/system code as defined in technical specifications

Creates unit test plans, executes unit testing and documents results to ensure that code works as designed

Ensures integration with testing groups (e.g., UAT, CTP)

Conducts all required reviews (e.g., code coverage, code reviews, test plan reviews), as applicable

Works with database teams to evaluate and establish applicable database technical requirements

Works with configuration/release management to develop release plans that ensure proper applications deployment

Analyzes defects identified by operational support groups (e.g., Systems Support) for remediation and inclusion in future application/system releases

Participates in the application deployment process, as needed

Provides ongoing expertise to operational support groups (e.g., Systems Support) in order to address identified application problems/issues, as requested

Required Skills:

Bachelor's Degree or higher

5 or more years of SQL Server 2016+ database applications design and development experience

5 or more years of SQL Stored procedures development experience dealing with large volume health care data utilizing complex database T-SQL queries & stored procedures, and performance tuning

5 or more years of SSIS development experience with ETL and complex data processing

5 or more years of SQL data analysis using SQL Server 2016+ and/ or other compatible RDBMS (Oracle, DB2, Teradata)

3 or more years of working experience using Microsoft Visual Studio in developing SQL applications

3 or more years of Relational database design and data modeling experience

Assets:

Microsoft SQL Server Certification

Solid understanding of databases, SQL and data warehousing/marts including Query analysis and performance tuning

Solid understanding of the full Systems Development Life Cycle (SDLC) with Agile/Scrum and associated practices

Working knowledge of .NET concepts

Working knowledge of Microsoft Team Foundation server

Working knowledge of Project Management functions

Experience with Big Data platforms

Experience working with team members in multiple locations, including off-shore

Knowledge of Healthcare Services industry helpful

Familiarity of Symmetry Episode Treatment Groups (ETG), Symmetry Procedure Episode Groups (PEG), Symmetry Episode Risk Groups (ERGs), Symmetry EBM Connect data

Other Tasks:

Identifies and resolves operational problems using defined processes, expertise and judgment

Reviews and fully understands application/system designs

Demonstrates understanding of application architecture (e.g., MS SQL Server) and how the design integrates with it

Adheres to applicable enterprise development methodologies and processes

Anticipates design scalability and ensures inclusion in application/system designs

Ensures that application/system designs are clearly and comprehensively documented, understood and traceable back to business requirements (e.g., requirements traceability matrix)

Ensures compliance with application code standards

Ensures that technical specifications/design documents are clearly and comprehensively documented, understood and traceable to the application/system design (e.g., traceability matrix)

Adheres to applicable enterprise development methodologies and processes (e.g., UDP, RSA, ADR, EPMO processes)

Demonstrates understanding of applicable data models and enterprise data standards

Identifies applicable Design Patterns for use in technical specifications/design documents

Accounts for applicable security requirements in technical specifications/design documents

Optimizes user experience/interface design

Ensures technical compliance with applicable operating systems

Ensures that technical specifications/design documents optimize application/systems performance (e.g., use of appropriate keys, indexes)

Ensures appropriate integration/interface with applicable partner specifications/design documents

Ensures that the deployment process is fully documented and compliant with all operational requirements for the application/system

Communicates and ensures full understanding of application/system changes to applicable groups, in order to facilitate ongoing application stability

Ensures that operational documentation is updated to include system maintenance/update changes

Ensures that system maintenance/updates adhere to security standards

Top 3 responsibilities you would expect the subcon to shoulder and execute

Basics of Healthcare domain to understand the business requirements

Analytical abilities, Strong Technical Skills, Good communication skills

Good understanding of the SQL and ETL technology and Healthcare domain

If you are interested in the position, please fill the details:  

First Name (As per passport):  

Last Name:             

Contact no:  

DOB:  

Email id:  

Skype id:  

Current location:  

Visa status:  

Relocation:  

Skype interview (Yes/No):  

F2F interview (Yes/No):  

Interview availability for Next 3 days:  

1st slot:  

2nd Slot:  

3rd Slot:  

4th Slot:  

5th Slot:  

Availability for new project:  

SSN last 4 digits:  

Linked In:  

Highest degree and years of completed:  

Masters (Course) (University) (Year of Passing):  

Bachelors (Course) (University) (Year of Passing):  

Passport no/I-94 copy (Must):  

Two professional references:  

Ref#1  

Designation:  

Name:  

Contact no:  

Email Id (Official):  

Ref#2  

Designation:  

Name:  

Contact no:  

Email Id (Official):  

USA. INDIA. Mexico, UK

Thanks & Regards

Shravan Kumar Kataboina

Team Lead Talent Acquisition

Smart Folks Inc

Direct 469-888-5467

E-mail: [email protected]

www.smartfolksinc.com

Keywords: information technology microsoft Idaho Minnesota
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=834860&uid=
[email protected]
View All
11:18 PM 07-Nov-23


To remove this job post send "job_kill 834860" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]


Time Taken: 8

Location: Hopkins, Minnesota