Data Integration Power Center

Nishazia Moghal(Nisha)

Email: ********.*@*****.***

Phone: +1-786-***-****

PROFESSIONAL SUMMARY:

•I have over 8+ years of IT, related to various aspects involving Data integration and Data Warehousing techniques using ETL tools like Informatica Power Center.

•Strong working experience in all phases of development including Extraction, Transformation and Loading data from Various sources into Data warehouses and Data Mart using Power center components.

•Solid understanding and Development experience in Data Warehousing, Business Intelligence, Data Migration, Data Integration using various RDBMS and Web based and other application

•Experience in all the phases of the Data Warehouse project life cycle.

•Experience in designing, reviewing implementing and optimizing data transfer process in Hadoop and Informatica systems.

•Basic Knowledge on Hadoop Big data Technologies like Spark, Hive, HDFS.

•Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) / (STM) and transform it into technical requirements.

•Worked with Business Analyst in understanding the requirements and Source to Target Mapping document.

•Worked with Data Modelers for business model review.

•Strong experience in Understanding Logical and Physical Data Modeling, Dimensional Data Modeling - Star Schema/Snowflake modeling, Fact and Dimension Tables.

•Experience on Informatica components like transformations, reusable transformations, mappings, mapplets, worklets and workflows.

•Extensive knowledge of various kinds of Informatica Transformations such as Source Qualifier, Aggregate, Lookup (Connected & Un Connected) s, Rank, Joiner, Filter, Router, Sorter, Sequence, Union, Update Strategy, Stored Procedure, Java, Normalizer and xml Transformations.

•Experience working with different Databases like Oracle, Teradata, My Sql, DB2 and SQL Server.

•Experience in working with Flat Files, Mainframe & XML Files.

•Strong experience in writing SQL for Data Analysis.

•Experience In working with SFDC and integrating it with Informatica.

•Hands on experience with Teradata utilities like BTEQ, Fast Export, Fast Load, and Multi Load to export and load data to/from different source systems including flat files.

•Experience with Tuning Teradata and other DB queries.

•Extensively worked with Slowly Changing Dimensions (Type I, Type II).

•Good Experience with Change Data Capture for pulling Delta data.

•Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources (Relational, Flat files, XML Files & Application) to targets.

•Experience in maintenance and enhancement of existing ETL Process and improving loading process for faster efficiency.

•Experience with DWH Heavy Production Support.

•Experience in supporting business for DWH data issues using trouble tickets.

•Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.

•Created Workflows with event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.

•Extensive involvement in writing UNIX shell scripts.

•Involved in Upgrade projects for both Informatica & Database.

•Strong hold in working both Waterfall & Agile Methodology project implementation.

•Possess sound business knowledge related to various areas of wealth Management like portfolios securities performance rating etc.

EDUCATION:

•Bachelors in Computer Science and Engineering from JNTU Hyderabad-India-2011.

CERTIFICATES:

• AWS Cloud Practitioner

TECHNICAL SKILLS:

•Informatica Power Center: 8 Plus Years

•RDBMS: Oracle, Teradata, My Sql, Sql Server, DB2, Sybase

•Application: SFDC, Mainframe

•File System: Flat Files, XML

•Unix/Linux, ETL, DB Performance Tuning

•Scheduling Tools: Control – M, CA7, Auto Sys and Informatica Scheduler

•Ticketing Tools for Support: BMC remedy, Service Now

•Domain Knowledge: Travel, Telecom, Banking & Finance

PROFESSIONAL EXPERIENCE:

Sithafal Technologies : Jan 2023 – Till Date

Role : ETL Developer

Domain: Environmental, Social and Governance

Responsibilities:

•Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.

•Developed and tested all the backend programs, Informatica mappings and update processes

•Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Oracle, My Sql, DB2 & VSAM.

•Responsible for building scalable distributed data solutions using Hadoop.

•Created and used the Normalizer Transformation to normalize the flat files in the source data.

•Extensively built mappings with SCD1, SCD2 implementations as per requirement of the project to load Dimension and Fact tables.

•Experience in managing Hadoop Log files.

•Used Evaluate expression options to validate and fix the code using Debugger tool while testing Informatica code.

•Handled initial (i.e. history) and incremental loads in to target database using mapping variables.

•Used Debugger to debug mappings and created breakpoints for better analysis of mappings.

•Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.

•Worked on Control-M and CA7 job scheduling and Unix Scripting.

•Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.

•Written sql to generate various kinds of adhoc reports and doing dwh data analysis for reporting requirements.

•Experience with high volume data sets from various sources like Oracle, Text Files and Teradata Tables.

•Involved in migrating the ETL Code to different environments from Dev to UAT and then to Production with ETL Admins.

•Experience in working with Code migration, Data migration and Extraction/Transformation/ loading using Informatica Power Center and Power Exchange with Oracle, Sql Server, Teradata, XML, Flat files, and Cobol on UNIX, Windows

•Performed Unit testing and created unit test plan of the code developed and involved in System testing and Integration testing as well. Coordinated with the testers and helped in the process of integration testing.

•Heavily involved in Production support on rotational basis and supported DWH system using the ticketing tool for the issues raised by Business users.

•Experience in working with reporting team in building collection layer for reporting purpose.

Environment: Informatica Power Center 10.2/9.6.1/9.5.1, Tableau, Oracle 12 C, My Sql, DB2 BLU, Flat File, VSAM, Putty, Control-M/Informatica Scheduler, Toad, SQL developer, UNIX, Windows.

Truist-Contract :Apr 2020 – Dec 2022

Role: ETL Developer

Domain: Banking

Responsibilities:

•Developed ETL programs using Informatica to implement business requirements.

•Communicated with business customers to discuss the issues and requirements.

•Used Informatica B2B create events to pole the FTP sites for the external flat files.

•Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

•Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.

•Enterprise Resource Planning implementation specializing on SAP BW and Integration of SAP R/3 with Other applications.

•Involved in the development of PL/SQL stored procedures, functions, and packages to process business data in OLTP system.

•Designed tables required for the execution of the ETL processes using Erwin.

•Strong technical skills in Oracle, SQL, PL/SQL, MySQL.

•Optimized the SQLs and Informatica mappings which handled millions of records.

•Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques.

•Experience in working with Code migration, Data migration and Extraction/Transformation/ loading using Informatica Power Center and Power Exchange with Oracle, Sql Server, Teradata, XML, Flat files, and Cobol on UNIX, Windows

•Experience in working with reporting team in building collection layer for reporting purpose.

•Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations also implementing CDC using Informatica Power Exchange 8.x/9. x.

Environment: Informatica Power Center 10.2/9.6.1/9.5.1, Oracle, My Sql, DB2 BLU, Teradata 15/14, Flat File, VSAM, Tableau, Putty, Control-M/Informatica Scheduler, UNIX, Windows.

Tech Mahindra-Full time Jan 2013 – Apr 2015

Role: Software Engineer

Domain: MHRIL(Travel)

Key Assignments/ Initiatives:

•Administrating the production environment Gateway server, web server and Siebel server which are clustered services.

•Involved in both Production and Test deployments.

•Day to day deployments on test environments like (Prepared and Dev)

•Co-ordination with DBA’s, server support team for performance tuning, distribution of SQL server data, transaction log files.

•Worked as a Deployment Team member for release deployments of various releases on test environments and Production.

•Manually monitoring the health-check and prepared health-check reports on daily basis.

•Capable of running EIM jobs through UI or server manager command prompt.

•Strong enough in providing access related to data or Siebel screens/views to employees as per the organizational hierarchy/requirement.

•Have performed admin activities like repository import and export, SRF replacements.

•Use Siebel Tools to modify applets, views, and screens to meet client requirements.

•Support tasks like Database Extraction for Developers, and applying changes to the tables in Tools, import and export of SIF objects, workflows across environments and maintaining the version control

•Troubleshooting CTI issues.

•Involved in the Application Administration tasks such as System Preferences, assigning views to responsibilities etc; Integration Administration tasks like EAI value maps, Symbolic URL and Personalization administration.

•Written batch files to do reduce some repeated tasks in Siebel Administration

•Repository Migration from One Environment to Another using DEV2PROD

•Migration of changes to application components to the Development, Test, Training and Production environments.

Environment:Siebel server Admin, Unix Shell scripting, SQL, PL/SQL, Java

Tech Mahindra-Full time Apr 2012 – Dec 2012

Role: Software Engineer

Domain: British Telecom

Responsibilities:

•Working on development of different Web Applications using Java/J2EE required for the project support.

•Supporting the application through quality Center Tool

•Fulfilling end to end activities of development and test teams of one view component.

•Monitoring the health check of the respective environments

•Worked on automation which reduces the manual work.

•Supporting the application and backend jobs are done through Unix.

•Day to day deployments on test environments like (Preprod and Dev)

•Manually monitoring the health-check and prepared health-check reports on daily basis.

•Handling in-built deployment tools like FALCON, DTT, Workflow Activation

•Worked on HP QC Tool for tracking issues and hot fix deliverables.

•Performing enterprise startup and post startup validations

•Manual SRF replacement for deploying SRF fixes

•Removing server from load balancer and enterprise pool

•Siebel installation and configuration

•Participating in mega blocker calls and resolving technical issue

•Analyzing component/server logs and identifying technical/functional problems

•Workings on bridge clarify for Service Requests, Incident and Change requests.

•Configuration of components like changing username, password, MTS, default task, queue manager, queue name etc.

•Core analysis

•Log investigation and resolving technical issues

Environment: Siebel server Admin, Unix Shell scripting, SQL, PL/SQL, Java

Contact this candidate