Nazreen

Email: adplwf@r.postjobfree.com

Ph#: 469-***-****

Professional Summary:

ETL Developer with over 7+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application system.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Dimensional Data Modelling, Ralph Kimball Approach, Star/Snowflake Modelling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modelling.

Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.

Experienced in using ETL tools including Informatica PowerCenter 10.x/9.x/8.x, Power Mart, Power Exchange, Workflow Manager, Repository Manager, Administration console and Informatica Data Quality (IDQ).

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

Experience with dimensional modeling using star schema and snowflake models.

Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.

Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.

Strong information and aptitude in data conversion strategies, devices, and methods.

Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.

Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP.

Distinguish and resolve dangers and issues identified with information transformation exercises.

Experience in Erwin Database programming for Data Warehouses (Schemas), proficient in dimensional modeling, Star Schema, Snowflake and Hierarchy modeling.

Experience in creating UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Triggers, Views and Materialized Views.

Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.

Excellent communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

Technical Skills:

Packages & ETL Tools

Informatica Power Center 10.x/9.x/8.x/7.x, IDQ, TOAD, OLAP, OLTP, Erwin

Data Bases

SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6 (Oracle), Teradata, AQT v10 (Advanced query tool) (Oracle/Netezza), DB Artisan 9.0 (Sybase), SQL Browser (Oracle Sybase), Visio, ERWIN

Languages

SQL, PL/SQL, TSQL, UNIX Shell Scripting.

Data Modeling

Erwin 7.3, Star-Schema Modeling, Snowflakes Modeling

Methodologies

Agile, Waterfall

Operating Systems

Unix, Win NT, MS-DOS, Solaris

Education:

Bachelor’s in computer technology, 2008

Professional Experience:

Client: Delta airlines, Atlanta, GA Apr 2020 – Till Date

Role: ETL/Informatic Developer

Responsibilities:

Participate in design and analysis sessions with business analysts, source-system technical teams, and end users.

Responsible for developing and maintaining ETL jobs, including ETL implementation and enhancements, testing and quality assurance, troubleshooting issues and ETL/Query performance tuning

Designing, developing, maintaining, and supporting Data Warehouse or OLTP processes via Extract, Transform and Load (ETL) software using Informatica.

Report on progress of information transformations and supporter for explicit goal to interesting issues taking all things together inward gatherings with Implementation work force.

Manage and expand current ETL framework for enhanced functionality and expanded sourcing.

Translate business requirements into ETL and report specifications. Performed error handing using session logs.

Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Done Code reviews of ETL and SQL processes. Worked on upgrading Informatica from version 9.x to 10.x.

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence

Identifying performance issues in the code and tuning it to complete the jobs within the given SLA time.

Mythical being starter with solid critical thinking and logical abilities to deal with the most intricate information transformation issues and lessen any monetary openness issues to the organization.

Performance tuning at Informatica and database levels depending on the bottlenecks identified with the jobs.

Developed mappings using Informatica Power Center Transformations - Lookup (Unconnected, Connected), Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Worked with Informatica Data Quality 9.x (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.

Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management.

Worked with the testing team to resolve bugs related to day one ETL mappings before production.

Maintained ETL release document for every release and migrated the code into higher environments through deployment groups.

Created change request before code deployment into production to get required approvals from business.

Created weekly project status reports, tracking the progress of tasks according to schedule and reported any risks and contingency plan to management and business users.

Environment: Informatica Power Center 10.x/9.x, IDQ, OLAP, Oracle, MS SQL Server, PL/SQL, SSIS, SSRS, SSAS, SQL*Plus, SQL*Loader, Windows, UNIX.

Client: Voya Financial, New York, NY. Jan 2018 – Mar 2020

Role: ETL Developer

Responsibilities:

Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer

Using Informatica Power center 10.1 to make the changes to the existing ETL Wrote PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load delete records based on a condition and re-name the tables.

Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.

Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 10.x.

Extensively worked on building workflows, worklets, sessions, command tasks etc.

Designed and developed Informatica mappings including Type-I, Type-II and Type-IIIslowly changing dimensions (SCD).

Created mappings using different IDQ transformations like Parser, Standardizer, Match, Labeler and Address Validator.

Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.

Supported monthly data load activity using SSIS for Account Assignment System.

Involved in writing SQL Stored procedures and Shell Scripts to access data from various sources.

Assisted other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

Performed System, Integration testing and supported User Acceptance Testing.

Managed stakeholder communication and validated the fixed issues in order to ensure support availability as per agreed SLAs.

Client: Epsilon, New York, NY May 2016 – Dec 2017

Role: ETL Developer

Responsibilities:

Designed and developed complex mappings by using lookup, expression, update, sequence generator, aggregator, router, etc., transformations to implement complex logics while coding a mapping.

Worked in requirement analysis, ETL design and development for extracting data from the Oracle DB.

Involved and analyzed the business requirement and design of the Informatica mappings. Performed data cleansing activities to ensure high quality Cognos report deliveries.

Developed and maintained ETL (extract, transformation and loading) mappings to extract the data from multiple source systems like oracle, SQL Developer, SQL server and flat files and loaded into oracle.

Developed Informatica workflows and sessions associated with the mappings using workflow manager.

Created sessions, reusable worklets and workflows in Workflow Manager Used Event wait to trigger the file and run the process.

Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Used Debugger to test the data flow and fix the mappings.

Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.

Performed unit and integration testing and written test case.

Debug through session logs and fix issues utilizing database for efficient transformation of data.

Extracted data from different databases like oracle and external source systems like flat files using ETL tool.

Developed Mapplets, reusable transformations, Source and target definitions, mappings in Informatica.

Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the business requirements.

Migrated the ETL -Workflows, Mappings and sessions to QA and Production Environment.

Created documents that have the detail explanation of the mappings, test cases and the expected results and the actual results.

Good understanding of source to target data mapping and business rules associated with the ETL processes.

Environment: Informatica Power center 9.6.1/9.5.1, Informatica Data Quality, XML/HL7/delimited Files, Toad for Oracle 11, Batch Scripting, dynamic deployment groups, Informatica Scheduler, Oracle 11g, SQL Server 2012, Windows Server.

Environment: Informatica Power Center 10.x/9.x, IDQ, Oracle, MS SQL Server 2014, Business Objects, MS Access, Windows.

Client: Target Corporation, Minneapolis, MN. Nov 2015 – May 2016

Role: ETL Developer

Responsibilities:

Interacted with business analysts, data architects, application developers to develop a data model.

Involved in the warehouse design using a Star Schema.

Joined relational tables existing in separate database using Joiner Transformation.

Used the Router Transformation to load user-defined groups for the business units based on group filter conditions.

Involved in Performance Tuning of sources, targets, mappings and sessions.

Performed unit testing to validate mappings and populate the database.

Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.

Performed data analysis based on the source systems and existing OLTP database systems.

Involved in production support working with various mitigation tickets created while the users working to retrieve the database.

Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.

Tested data and data integrity among various sources and targets.

Environnent: Informatica Power Center, Oracle, DB2, SQL, PL/SQL, UNIX, TOAD, SQL Server, Windows 2000.

Company: Indi technologies, India. Sep 2012 – Aug 2014

Role: ETL Developer

Responsibilities:

Extracted Data from Different Sources by using Informatica.

Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplets Designer.

Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.

Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update Transformation rules.

Developed schedules to automate the update processes and Informatica sessions and batches.

Analyze, design, construct and implement the ETL jobs using Informatica.

Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplets designer in Informatica Power Center 6.1.

Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.

Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Center, Oracle, MS SQL SERVER, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.

Contact this candidate