Senior Etl Engineer Resume
Seattle, WA
SUMMARY
- Experience in software development life cycle including architecture, analysis, design, development, implementation, testing and maintenance of Data warehouse applications, Windows Forms, Web based and distributed applications
- 10+ years’ experience in Confidential as vendor
- Extensive experience in data warehouse applications including designing Star Schema
- 9+ years’ experience in data warehousing and business intelligence end to end implementation
- Expert knowledge and experience in ETL involving complex data migrations along with design/implement dimensional model
- Strong DB experience including design/modelling/development
TECHNICAL SKILLS
Databases: SQL Server 7/2000/2005/2008 R2/2012/2014, Sybase, Teradata, Oracle EBS, PL/SQL, PostgreSQL, MS Access
Languages: C#, VB.NET, C, COBOL, PASCAL.
Business Intelligence: SSIS, SSAS, SSRS, Informatica, Wherescape, DSS, Business Object, OBIEE, Tableau, Power BI
Tools: Visual Studio, TFS, SVN, ALM, Source Depot, Visual Source Safe, Crystal Reports, MS Visio, ERWIN, MS Product Studio, MS Project, PowerShell.
Web: ASP.NET, XML, Web Services.
Others: COSMOS, SCOPE, Service Now.
PROFESSIONAL EXPERIENCE
Confidential, Seattle, WA
Senior ETL Engineer
Responsibilities:
- Review and Analyze Functional Specification Document/Mapping Specification Document
- Participate in Requirements and Design Reviews with Analysts, Architects and QA
- Design dimensional model and develop ETL packages for extracting data from various sources systems
- Worked on building new SSIS packages for all the new data flow streams
- Created Star schema model, built SSIS packages and create SSAS cube to consume for SSRS/Power BI reports
- Worked on generating reports, dashboards as per business needs
- Designing, developing data checks for all ETL Loads
- Perform SQL Validation to verify Data Extraction, Data Consistency, Data Completeness and Data Integrity
- Extensive analysis of Complex Business Transformations for resolving various data issues working with Users in UAT
- Extensively used Informatica to extract, transform data from different source systems and loaded data into the target databases
Technologies: SQL Server 2014/2012/2008 R2, SSAS, SSRS, SSIS, Informatica, WhereScape, Service Now, SVN, ALM, Oracle EBS, OBIEE, Business Objects, Tableau
Confidential Corporation, Redmond, WA, USA
Senior ETL Engineer
RDM (Retail IT Group)
ITDC (CFIT Group)
- Review and Analyze Functional Specification Document/Mapping Specification Document
- Participate in Requirements and Design Reviews with Analysts, Architects and QA
- Design dimensional model and develop ETL packages for extracting data from various sources systems
- Worked on building new SSIS packages for all the new data flow streams
- Created Star schema model, built SSIS packages and create SSAS cube to consume for SSRS/Power BI reports
- Extracted data from different sources like SQL Server, Excel, Cosmos and Flat files.
- Designed and developed complex ETL packages and updating existing packages
- Created several reports as per business needs
- Designing, developing data checks for regular data loads
- Perform SQL Validation to verify Data Extraction, Data Consistency, Data Completeness and Data Integrity
- Extensive analysis of Complex Business Transformations for resolving various data issues
- Designing, developing and executing robust data checks
Confidential, Seattle
Senior ETL Engineer
Responsibilities:
- Perform system functionality and data integrity checks from multiple, complex source systems on multiple platforms into our enterprise data warehouse
- Review, Analyze and Sign off Functional Specification Document and Mapping Specification Document
- Participate in Requirements and Design Reviews with Analysts, Architects and QA
- Worked on building new packages and updating existing packages
- Created reports as per business needs
- Developed stored procedures for tasks involving source pre load and target post load running Informatica jobs
- Involved in extracting data from various sources systems
- Designing, developing and executing robust data quality checks
- Perform SQL Validation to verify Data Extraction, Data Consistency, Data Completeness and Data Integrity
- Extensive analysis of Complex Business Transformations for resolving various Data Quality issues
Confidential, Redmond
Senior ETL Developer
Responsibilities:
- Strong and proven ETL Expertise and the ability to retrieve, analyze and compare data across different sources system
- Expertise in Analysis, developing and Testing of ETL Applications and Reporting Solutions
- Reviewed and Signed off Business Requirement Document, Functional Specification Document and Technical Specification Document
- Participate in Requirements and Design Reviews with Analysts, Architects, Developers
- Create and Schedule SCOPE jobs and validate data from COSMOS to verify Data Extraction
- Create ETL/SSIS packages to load and validate data
- Participated in Daily Team Scrums and provided Status to Team Members and Reporting Manager
- Used MS Visio for Process Modeling, Process Mapping and Business Process Flow Diagrams
- Database Maintenance, Data load and validation pertaining to different tools
- Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
Confidential
Senior SQL Developer
Responsibilities:
- Interaction with client for requirements gathering
- Analysis of the specifications provided by the client
- DB Design and Development of backend scripts and Implement Replication
- Participate in Requirements and Reviews with Analysts, Architects, Testers
- Worked with Business Users during UAT and provided further analysis on their Defects
- Identify performance bottleneck and enhance Performance
Confidential
Programmer Analyst
Responsibilities:
- Interaction with client for requirements gathering and analyze the specs
- Database Design, Database Development and Standardize Naming and Coding conventions
- Fine tune queries and stored procedures, Developed backup and restore utility
- Support .Net development team on Database related issues