ETL/SQL Analyst

Back to job search
  • Location:

    The Woodlands

  • Job type:

    Contract

  • Job ref:

    811195

  • Published:

    about 1 month ago

  • Duration:

    12

  • Expiry date:

    02/03/2023

  • Startdate:

    ASAP

Job Title:- ETL SQL Analyst

Location:- Spring Texas (On-Site)

Job Type:- Long Term Contract

Interview: 30-minute Zoom interview

Skills:

  • This role will support existing SQL databases, SSIS package scheduling and automation to ensure accurate and timely transfer of data. Candidate should become familiar with business requirements and translate them into SQL/SSIS development work for both new and existing functionality.

SQL

  • Query and View Creation / Troubleshooting / Optimization (SQL, DAX)

  • Stored Procedure Creation / Troubleshooting / Optimization

  • Automation Jobs Scheduling and Maintenance

  • Performance testing and monitoring

  • Ability to review existing queries, views, and stored procedures and quickly understand their purpose

  • Documentation of interdependencies and impact analysis

SSIS / Visual Studio

  • Data Flow Task (DFT) creation / maintenance / troubleshooting

  • Familiar with creating connectors for various sources (DAX, OLE DB, Excel, SharePoint, etc.)

  • Check-In process, promoting changes to Git Hub

  • Error troubleshooting and resolution

Visualizations (nice to have, but not required)

  • Tableau

  • Power BI

  • Upkeep / refresh of existing dashboards

  • Changes to existing visualizations

Thanks and Regards,

Aman Kumar Verma

Lead Technical Recruiter

Digital Intelligence Systems (DISYS)

Digital Intelligence Systems, LLC (DISYS) is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.