Mouser Electronics Inc. Hiring for ETL Developer II at BANGALORE, India Full Time

ETL Developer II

Location BANGALORE INDIA

Hours Needed 11:00AM – 8:00PM

Requisition Number 14224

Apply Now (https://phf.tbe.taleo.net/phf03/ats/careers/v2/applyRequisition?org=MOUSER&cws=40&rid=14224)

JOB DESCRIPTION Title: ETL Developer II The ETL Developer is responsible for the performance, integrity and security of a database. The DBA will create database, structures, data flows and reports. They will collaborate with developers, analysts and business partners to design data solutions based on best practices.

ACCOUNTABILITIES & ESSENTIAL FUNCTIONS

• Analyze, solve, and correct issues in real time.

• Provide suggestions for solutions.

• Create ETL packages. (Mandatory on SSIS, Knowledge of other ETL is good to have).

• Experience with complicated SSIS Package coding and maintenance.

• Participate in ongoing DW/BI performance tuning activities.

• Refine and automate regular processes, track issues, and document changes.

• Assist developers with query tuning and schema refinement.

• Provide support for critical production systems as required.

• Maintaining code versioning and support code deployments.

• Perform scheduled maintenance and support deployment activities as required.

• Manage SQL Databases but not limited and can extend to NoSQL/Cloud Database as applicable.

• Preserve data integrity.

• Maintains contemporary knowledge of industry trends, concepts, and techniques.

• Experience in creation of SQL Tables, Views, MV’s, Stored Procedures and working on complex T- SQL statements.

SKILLS & CERTIFICATIONS

• Expert knowledge in traditional relational database concepts and design.

• Fluent in SQL

• Database design and query optimization.

• Write and debug stored procedures and ability in advanced SQL operations.

• Advanced query, join operation, and aggregate.

• Knowledge of data warehousing.

• Automate manual data tasks through workflows and ETL packages.

• Should possess skill to maintain, monitor, troubleshoot daily jobs using SQL Server Agent.

• Administrate application and server environments.

• Analyze data quality and make recommendations for data preparation.

• Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents).

• Experience with data manipulation, data engineering, and working with large data sets.

• Follow guidance from senior team members to plan, deploy, and maintain critical data solutions .

• Data engineering and manipulation of large data sets.

• Perform system monitoring and technical support.

• Analyze data quality and make recommendations for data preparation.

• Engage with end-users to identify opportunities where data can enable them to make data-driven decisions.

• (OPTIONAL/ GOOD TO HAVE)

• Configure and maintain database servers and processes.

• Monitor system’s health and performance.

• Handle scheduled maintenance and support deployment activities as required.

• Installing and configuring SQL Server, applying patches and fixes and monitoring, troubleshooting and optimizing performance.

• Creating backup plans, developing and testing disaster recovery scenarios, managing security, server sizing, and performance tuning.

REQUIREMENT

• A degree from a four-year college, technical school or university in technology , Masters degree preferred.

• 2+ years ETL Developer experience required. For internal candidates, experience can be a combination of internal and external experience.

• Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents).

• Experience with data manipulation, data engineering, and working with large data sets.

This is a summary of the primary accountabilities and requirements for this position. The company reserves the right to modify or amend accountabilities and requirements at anytime at its sole discretion based on business needs. Any part of this job description is subject to possible modification to reasonably accommodate individuals with disabilities.

Mouser Electronics endeavors to make its Career page accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact Human Resources at (817) 804-8050 or hr@mouser.com . This contact information is for accommodation requests only and cannot be used to apply for positions or to inquire about the status of applications.

Mouser is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click HERE (https://www.mouser.com/pdfdocs/eeo-policy-statement.pdf) . If you would like more information on your EEO rights under the law, please click HERE (https://www.mouser.com/pdfdocs/eeo-poster.pdf) .