We provide IT Staff Augmentation Services!

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

Hire Now