Diverse Lynx
SQL Developer
Diverse Lynx, Torrance, California, United States, 90504
Title - SQL Developer
Location - Torrance, CA (Day 1 Onsite)
Job Description -
ETL (Extract-Transform-Load) Developer will be part of a data and business intelligence team that develops full lifecycle data analytics applications. This individual will be responsible for all tasks related to the data integration activities to include performing analysis of source systems, source-to-target mapping, designing data integration routines, assisting with data modelling, developing data migration scripts, and performing testing. The ETL developer will primarily work using SQL Server Integration Services (SSIS) as the primary ETL tool.
Expertise in handling complex SQL queries Experience in creating complex packages Knowledge in Scheduling and scripting of the packages Excellent knowledge in Debugging and tracing errors in execution. Experience with Data warehousing concepts Good knowledge on Data modelling concepts Excellent communication skills. The SSIS- ETL Developer will be responsible for design and development of BI solutions, update of data analytics platforms A commitment to collaborative problem solving, sophisticated design, and quality BI solutions development is essential Job Responsibilities
Translate business needs to technical specifications Evaluate and improve existing SSIS projects Take ownership of SSIS projects Proficient in T-SQL coding: query writing, stored procedures, triggers and user-defined functions. Create SSIS packages with best practices, error handling, logging Able to troubleshoot SSIS errors by running and analysing underlying database queries Create visualizations and business intelligence reports for client projects using Power BI Take care of end-to-end project execution for clients Must have
Must have strong extensive experience in SQL Server Integration Services (SSIS)
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Location - Torrance, CA (Day 1 Onsite)
Job Description -
ETL (Extract-Transform-Load) Developer will be part of a data and business intelligence team that develops full lifecycle data analytics applications. This individual will be responsible for all tasks related to the data integration activities to include performing analysis of source systems, source-to-target mapping, designing data integration routines, assisting with data modelling, developing data migration scripts, and performing testing. The ETL developer will primarily work using SQL Server Integration Services (SSIS) as the primary ETL tool.
Expertise in handling complex SQL queries Experience in creating complex packages Knowledge in Scheduling and scripting of the packages Excellent knowledge in Debugging and tracing errors in execution. Experience with Data warehousing concepts Good knowledge on Data modelling concepts Excellent communication skills. The SSIS- ETL Developer will be responsible for design and development of BI solutions, update of data analytics platforms A commitment to collaborative problem solving, sophisticated design, and quality BI solutions development is essential Job Responsibilities
Translate business needs to technical specifications Evaluate and improve existing SSIS projects Take ownership of SSIS projects Proficient in T-SQL coding: query writing, stored procedures, triggers and user-defined functions. Create SSIS packages with best practices, error handling, logging Able to troubleshoot SSIS errors by running and analysing underlying database queries Create visualizations and business intelligence reports for client projects using Power BI Take care of end-to-end project execution for clients Must have
Must have strong extensive experience in SQL Server Integration Services (SSIS)
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.