data engineer
• 7+ years Industry experience as a Data Engineer with solid understanding of Data Modeling, Data migration, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008/2012 and Teradata Vertica and Hive.
• Experience in OLTP, OLAP Data warehouse and Business Intelligence modeling.
• Experience in various Databases like Vertica, Data Lake and EDW.
• Experience in Hive, Hadoop and Big Data Tools.
• Expertise in creating Conceptual, Logical and Physical data models in OLTP and dimensional models, star schemas data marts and cubes for data warehouse.
• Experience in working with Logical and Physical data mapping from source to target.
• Experience in gathering and validating reporting requirements and designed optimized reports.
• Experience in working on the testing and condition of data and validation of the data.
• Experience in gathering business requirements and writing business and functional requirement documents.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution
• Worked on the data architecture framework implementation for Informatica ETL environment.
• Experience in Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Expert in writing SQL queries and analysis of the data patterns.
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Experience in working on the testing and condition of data and validation and migration and workday integration of the data.
• Experience on general DataStage work, target mappings, source-to-target, etc.
• Experience in Data Augmentation, Data Scrubbing, Data Quality, Data Profiling and Data Cleansing.
• Experience in the implementation of the Data Management Standards for the projects.
• Facilitated the model walkthrough sessions with Business users and Developers.
• Experience in working with the SDLC methodologies.
• Possess excellent communication skills and team player.
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000 / 7.0.
• Good experience in Data Modeling using Star Schema and SnowFlake Schema and well versed with UNIX shell wrapper and Oracle PL/SQL programming.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.