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