Proven 17+ years of industry experience working as Data Architect/Modeler/ETL/BI Architect/Database Developer
As Data Architect/ETL Architect/Data Engineer, I had followings role responsibilities
• Defined best practices and standards around data platforms tools & technologies around Warehousing, ETL, data modelling, data integration etc. Focuses on continual improvement of data quality, security, availability, performance and consistency, ensured compliance to standards and guidelines, implemented the data architecture, and supporting technical developers at a project or business unit level
• Developed deep understanding of vast data sources and know exactly how, when, and which data to be used to solve business problem
• Build durable ETL solution with ability to scale elegantly with data volume growth.
• Created ETL mappings which take data from various operational systems and design a unified dimensional or star/snowflake data model for different ETL strategies SCD, etc. for analytics and reporting
• Developed error handling processes, tuning, scheduling strategy
• Worked deployment, optimization, support and defect fixes
As Database Developer, I had followings role responsibilities
• Wo• Worked extensively in variety of database systems such as Oracle, SQL Server, MySQL for the development of database packages, procedures, functions, views, triggers, data validation queries using PL/SQL, T-SQL and SQL
• Design, Model and development of relational and dimensional data