Description
ETL/Database Developer (Minneapolis)
We are currently looking for an ETL/Database Developer for a long term contract position in Minneapolis, MN. The ETL/Database Developer will partner with additional client team members by developing and maintaining a thorough understanding of the needs of the assigned customer group from a business and technical perspective and create Business Intelligence solutions.
She/he must possess excellent verbal and written communications skills as you will be interfacing directly with employees at all levels of the organization.
You must be a self-starter, able to work independently while balancing multiple projects and maintaining high levels productivity.
Responsibilities:
- ETL/Database developer will be responsible for analysis, design specifications, development, implementation and maintenance of SSIS packages that require migrating data from source systems to warehouse systems in a BI environment.
- Develop cross validation rules to ensure mapping accuracy.
- Work closely with Data Architect to enable data governance strategy and overall Business Intelligence vision and strategy.
- Create ETL that supports the logical data model in the BI environment.
- Work with business users, other IT team members (Source system SMEs and managers) and management to ensure delivery of quality ETL in a timely basis.
- Conduct root cause analysis and resolve production problems and data issues as necessary.
- Participate in requirement gathering meetings to understand the business problems and assist data architect with data modelling.
- Educate the BI team with best practices and develop optimization plan for ETL.
Required Skills:
- 3+ years of experience with Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and ActiveX Scripting.
- 3+ years of experience in data modelling using, CA ERwin, or, Sparx EA, Embarcadero or other data modelling tools.
- 2+ years of strong experience with Strong SQL Server (2008).
Preferred Skills:
- Working knowledge and successful use of Agile methodology.
- Experience with Visual Studio, .NET, Microsoft Office Suite (Word, Access, and Excel), Windows Operating Systems, and Windows Server Applications (IIS, Cluster Administrator, Terminal
- Services).
Education:
BA/BS degree (CS or MIS preferred) or equivalent experience