Required Skills

SSIS ETL SQL

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 31st Jan 2024

JOB DETAIL

•             Creating and supporting SQL SSIS packages for ETL and other automated processes

•             Designing and coding database tables to store data

•             Creating table indexes to improve database performance

•             Programming views, stored procedures, and functions/triggers

•             Writing queries used for reporting and downstream data processes

•             Reviewing query performance and optimizing code

•             Able to take direction and work autonomously

•             Administering and documenting data dictionaries, requirements, specifications, data models and topology aides

•             Discuss and document evolving business requirements with business units, functions, management and users

•             Supports and troubleshoots SSIS job failures with IT

•             Works with IT to ensure end to end processes are aligned

•             This position may have high level access to all IT systems in the company, as necessary.

 

EDUCATION/EXPERIENCE:  

•             Bachelors’ degree or higher in Information Technology, Math or related degree, preferred

•             Extensive experience with Microsoft SQL Server, T-SQL, Visual Studio, and SQL Server Integration Services required.

•             Minimum 5 years of experience in Financial Services, preferred

•             Business Intelligence experience (Business Objects, Oracle, Tableau), preferred

•             Experience working with project teams preferred

•             MS Suite including MS Project and Visio, preferred

Company Information