Etl Developer And Data Analyst Resume
Coppell, TexaS
SUMMARY:
- Performance - driven, industrious, and seasoned SQL/ETL Developer with 8 years experience inData Analysis and Reporting, Dimensional Modeling, and Data Warehouse design and implementation using SQL Server, Oracle and TeraData
- 8 years comprehensive professional experience in Data Base Design, Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica PowerCenter 8.6.x/9.0.x/9.1/9.5.x/9.6.x/10.1
- Experience in creating the mapping, assigning workflow, testing the flow and monitoring the job
- Experience in creating Sessions, Workflows, and Worklets by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer
- Experience with complex mappings using Filter, Aggregator, Expression, Router, Joiner, Lookup, Update Strategy, Sequence generator, XML Source Qualifier, Rank
- Created mappings in Informatica Data Quality (IDQ) using parser, standardizer and address validator transformations
- Expert in designing and developing efficient ETL solutions to load huge volumes of data to/from various Flat files, XML files and Relational Databases i.e. Teradata, Oracle, SQL Server.
- Experience in Erwin Database programming for Data Warehouses (Schemas), proficient in Logical and Physical Database design, dimensional modeling, Star Schema, Snowflake and Hierarchy modeling.
- In-depth knowledge of SQL, and PL/SQL programming, Python, and Unix shell scripting
- Experienced with reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Actions, Parameter's etc., in Tableau.
- Ability to read and parse JSON in Python and Tableau for Data Analysis and visualization
- Expertise in importing Data files into Python and using Python for Data visualization projects
- Proficiency in Unix commands and file management in the Unix environment
- Working knowledge of InformaticaPowerCenter 9.6 for ETL projects and Informatica Data Quality (IDQ V 10) for data profiling and data cleansing projects
- Knowledge working with different data sources such as flat files, JSON files, XML, Excel, Oracle, and SQL Server
- Knowledgeable in VBA Macros in Excel for reports creation and data analysis
- Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors
- Thorough understanding of both Waterfall & Agile methodologies including SCRUM
- Extensive database experience and highly skilled in SQL in Oracle, MSSQL Server, DB2, Teradata, Sybase, Flat Files, CSV files, MS Access.
- Knowledge in creating drill-through reports, lists reports, crosstab reports and different charts using Tableau
- Excellent problem-solving skills and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure
TECHNICAL SKILLS:
ETL Tools: Informatica (Power Center 10x/9X//8x)
Operating Systems: Windows server 2012, Ubuntu Server 18.04, Red Hat Linux 7.2/7.3
RDBMS: Oracle7/ 8i/9i /10g, MS-Access 2002/2003, SQL Server 2014, DB2
Data Base Tools: Toad, SQL Navigator 4.0, SQL Loader
Data Modeling: Erwin
Reporting tools: Tableau 9.2/9.3/10.0 , Cognos, MS Excel
Scripting: Unix Shell Scripting
Languages: HTML, PL/SQL, Python, JSON, VBA
WORK EXPERIENCE:
Confidential, Coppell, Texas
ETL Developer and Data Analyst
Responsibilities:
- Development of data collection processes and data management systems
- Maintenance of data integrity (0% error rate)
- Designing of queries, c Ssis ompiling of data, and generation of reports using VBA MS Access and Excel
- Charting and graphing of data for reporting purposes
- In depth research of defect trends
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center 9.5
- Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
- Effective coding with Creation of mapplets and reusable stored procedures
- Used Informatica IDQ Normalizer transformation for effectively capturing multiple errors in feed files thus ensuring excellent data quality
- Data mining, defect analysis, resolution, tracking, and general data flow problem solving
- Present analysis in easily digestible standard reports
- Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and requirements gathering, and line of business in understanding the high-level requirements etc
- In-depth analysis and designing of parent and child referential integrity
- Designed end to end Data Flow model using Toad data Modeler
- Documenting Root Cause Analysis (RCA) reports and lesson learnt for avoiding similar error/bugs in next releases
- Back up for Process Assistant duties
Confidential, ARLINGTON, TX
ETL developer
Responsibilities:
- Standardize data from heterogeneous sources such as Oracle, SQL Server, and DB2 from an AS/400 and load into Data Staging area
- Developing various Mappings and Transformations using Informatica Designer
- Used Mapping designer and Mapplets to generate different mappings for different loads
- Used Server Manager to schedule and monitor different sessions of loading
- Used the PL/SQL procedures for data extraction, transformation and loading
- Performance Tuning of sources, targets, mappings and SQL queries in transformations
- Created various transformations like Joiner, Aggregate, Expression, Filter, update Strategy
- Carried out precise documentation of all mappings, workflows and reports
- Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management
Confidential, DAYTON OH
Informatica ETL Developer
Responsibilities:
- Involved in preparation and analysis of Functional HLD requirements and development of LLD artifacts for ETL
- Development of mappings, workflows, session and tasks using Informatica power center
- Examining the session logs in case of workflows failures and debugging mappings using Debugger tool in Mapping Designer
- Participated in testing Data matching between source to target Databases
- Worked on transformations like Lookup, Sequence Generator, Filter, Transformation etc
- Involved in Data loading to staging tables and from staging tables to Target tables i.e. Data loading from source to target Database
- Testing the codes and deploying it to the QA environment for UAT
- Perform system and requirement analysis, coding, unit testing of load into EDW
- Implemented a new methodology in the form of dashboard using Informatica and unix to determine a process or a job run status and stats
- Configuring BMC Control M scheduler to execute the ETL workflows and monitoring daily ETL data load
- Involved in Informatica Mappings migration from development, testing, to production
- Involved in mock deployment activity prior to the main release activity where the code is migrated to new environment
Confidential, SCRANTON, PA
ETL Developer
Responsibilities:
- Examining the session logs in case of workflows failures and debugging mappings using Debugger tool in Mapping Designer
- Extensive experience in using ETL process using Informatica Power Center 8.6/ 9.1
- Participated in exporting the sources, targets, mappings, workflows, tasks etc. and importing them into the new Informatica 9.1 platform
- Developed the Mappings using needed Transformations in Informatica tool according to technical specifications
- Tested and reviewed imported Informatica objects to make sure that all the workflows are Execute as per the Design documents and Tech specification
- Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to Oracle that met business requirements for reporting and analysis
- Extensively used XML Source, XML target and XML Parser transformations
- Imported Source and Target tables from their respective databases
- Used Informatica Designer to develop Mapplets and Transformations for migration of data from existing systems to the new system
- Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, Sorter
- Interacted with the off-shore ETL and Database teams
- Prepared Documentation material for the mapping according to the designed logic used in the mapping
Confidential
ETL Developer
Responsibilities:
- Primarily responsible to convert business requirementsinto system design
- Further implemented system model in Informatica, comprehensively using the functionality of the tool
- Used ETL to standardize data from various sources and load into Data Stage area
- Used several transformations like source qualifier, expression, lookup, aggregator, Joiner, sequence generator, router and update strategy transformations for complex mappings
- Designed and developed catalogs that reflected business view of the data to enable other developers to design cubes and reports
- Extensively used PL/SQLProcedures/Functions to build business rules
- Extensively worked in the performance tuning of Developed Mappings and Sessions
- Troubleshooting bottlenecks in existing Data transformation mappings