Sr. Data Architect

  • Expertise in full project life cycle development for implementation and integration of software solution with polished leadership skills and the ability to motivate teams to increase productivity.
  • 12 years of Experience Microsoft SQL Server 2014, 2016, SQL Query Analyzer, T-SQL, stored procedures, database design and implementation.
  • Provide expert guidance in design development and implementation of database solutions.
  • Data architect, capable of designing, defining and implementing data model and schema for operation data store and data warehouse.
  • Provide direction and coordination for the development team by identifying best practices in database implementation and mentoring team.
  • Ability to identify and put in place methodologies and best practices for team members to improve database and etl process development.
  • Experience and knowledge with various Agile project management priciples, Scrum, Kanban, stories, estimation techniques and lean software development.
  • Responsible of managing and guiding ETL development through a test-driven approach.
  • 10+ of experience providing deep understanding and analysis of requirements and defining strategies and architecture plans for implementation.
  • Highly skilled data analyst capable of understanding and designing complex data driven domain systems.
  • Senior ETL developer with 7+ years demonstrable experience using ETL tools with SQL Server 2008, SQL Server Integration Services 2008, Altova MapForce experience preferred.
  • Strong knowledge of and experience with  Data Warehousing methodologies and architectures, including and not limited to: ETL design, staging, transformations, delta/change data capture, star-schemas, snowflakes, cubes, history loading, dimensional modeling and reporting tools.
  • Should have good understanding of SSIS architecture and SQL Server data base artifacts
  • Experience in analysis, design and construction of data marts and data warehouses from functional and system requirements as well as existing data structures.
  • Experience creating and administering databases.  Hands on experience in MS SQL db a must.  Must be able to dive into database and recommend strategies to improve performance, scalability, and security of application.
  • Strong in T-SQL, Stored Procedures and other database related artifacts.  Strong SQL architecting experience.
  • Must demonstrate the ability to analyze, research or query existing relational and dimensional databases using SQL.
  • Experience in performance tuning of database execution.
  • Demonstrated understanding of Test Driven Development (TDD) and an understanding of the principles of Lean Software Development is a desired.
  • Ability and willingness to follow established development and testing practices.
  • Strong .Net application knowledge preferred.
  • Bachelor’s degree or higher in computer technology discipline is desired.
Upload your resume or any other relevant file. Max. file size: 128 MB.

tekResource