Shahista Begum

Sr ETL Informatica Developer

Summary:

Around 8 years of extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Design, Coding, Development, Testing. Maintenance and Enhancement in variety of technological platforms.

Very Good Experience in Datawarehouse, Datamarts, Business Intelligence, Project management, Integrated Testing, High Level and Low-Level Documentations and Project implementations using diverse ETL Tools.

Extensive experience working with Data Warehouses and Data Marts using Informatica Power Center 10.2/10.1, 9.6/9.1, 8.6 (Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor), Informatica Data Quality 9.6, Informatica Power Exchange 9.6 and Informatica Cloud IICS.

Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using Data Modeling tools.

Implemented large scale global Datawarehouse Integration projects with new interface from end to end process.

Experience in ETL architecting highly scalable, distributed systems using different open source tools as well as designing and optimizing large, multi-terabyte data warehouses.

Able to integrate state-of-the-art Big Data technologies into the overall architecture and lead a team of developers through the construction, testing and implementation phase.

Good experience working with Informatica Data Quality and Informatica Data validation Object for Validations.

Working experience of methodologies like Star Schema and Snowflake Schema

Experience in Building Business Objects Universes and using various Data Providers like Universes, Stored Procedures, Personal Data Files for retrieving data and creating Simple, Complex and Adhoc Reports.

Strong logical, analytical and communication skills with Solid business acumen.

Ability to effectively gather and refine report requirements from Users and Management

Strong Team Management skills and excellent team player.

Handled & Lead Development Teams of sizes 4 to 6.

Experience in a wide range of Business Domains – Hospital, Healthcare, Financials, Banking and Insurance.

Technical Skills:

Job Function: Requirement Gathering Process, Documentation, Design, Analyzing, Developement, Testing, UAT meetings, On call support, Project managmenet, Lead, Solution analyst.

Operating System: Solaris, Linux, HP UX, Confidential AIX, Windows 7/Vista/XP/ 2003/2000/95

Databases: Oracle 7/9i/10g/11g, Sql Server 2004/2008/2016, Azure Sql Data warehouse, Teradata v15

ETL: Informatica Power Center 8.6,9.0,9.1,9.5,9.6,10.0,10.1,10.2 Informatica Cloud IICS, IDQ.

Applications: MS Word, MS Excel, MS Access, Visio

Unix Tools: VI Editor, F-Secure SSH Client, SFTP, NDM

Reporting Tools: Business Objects and Cognos

Data Modeling tools: ER Studio, ERWIN 7, Informatica Data profiler

Database Tools: Toad, Sql Developer, Teradata SQL Assistant, SQL Server Management Studio

Version Control: TFS, Git,CVS, SVN

Professional Experience:

Tufts Health Plan, Boston MA Feb 2018 – Present

Sr Informatica Consultant

Responsibilities:

Requirement gathering from the Business Unit and end users of the proposed product

Design and creation of detailed Technical Mapping document with information on implementation of business logic

Designing and building automated business processes using Infor Process Automation (IPA) framework

Performs duties including IPA administration and technical configuration management of core Infor Lawson and third-party products.

Troubleshoot Infor Lawson problems and work within Infor/Lawson and ERP team standards and guidelines

Use ERWIN to design Physical and Logical Data Modeling

Design of ETL mappings for the CDC (change data capture).

Working on various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.

Use Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.

Working on slowly changing dimension Type1, Type2.

Performance tuning of the process at the mapping level, session level, source level, and the target level.

Experience working with Informatica Power exchange integration with IICS to read data from Condense Files and load into Azure Sql Datawarehouse environment.

Working with the project team to formulate and implement a flexible system design that meets functional requirements.

Working with various tasks like Session, E-Mail, Workflows and Command.

Working with the Informatica Scheduler for scheduling the delta loads and master loads.

Working extensively with aggregate functions like Min, Max, First, Last, and Count in the Aggregator Transformation.

Experience working with Custom Built Query to load dimensions and Facts in IICS.

Experience working with IICS monitoring, administrator concepts.

Extensively use SQL Override, Sorter, and Filter in the Source Qualifier Transformation.

Extensively use Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.

Working with various re-usable tasks, workflows, Mapplets, and re-usable transformations.

Employee various Lookup Caches like Static, Dynamic, Persistent, and Shared Caches.

Use session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails.

Responsible for the Promotion of Mappings, Workflows and other Informatica objects like sources, targets, and transformation between environments like DEV, INT, UAT and PRD.

Extensively used Informatica Scheduler to test the scheduling in the Development Environment.

Working with the third party for Automation of job processing using Autosys scheduler, establishing automatic email notifications to the concerned persons by creating email tasks in workflow manager.

Working extensively with Versioning of objects in Informatica with Check in and Check out options.

Working extensively with the business intelligence team to incorporate any changes that they need in the delivered files.

Environment: Informatica Power Center 10.2/ 9.6.1, IDQ 9.6, Informatica Cloud IICS, Tableau 9.3, Oracle 11g/10g, PL/SQL, Power Exchange, Sql Server 2016, Windows Batch Scripting

Sutter Health, Sacramento CA Nov 2014 - Jan 2018

Sr Informatica Developer

Responsibilities:

Involved in redesign of existing Mainframe jobs in system, which are not meeting the exact business functionality output.

Working as only ETL developer to gather all requirements.

Supporting production team to assist in Trouble shooting the failures and performing Performance tuning on ETL.

Create Sessions and Workflows to load data from the Different Source Systems into Database which in turn feeds the downstream applications using tool Informatica Power center.

Building ETL Informatica applications for receiving and processing data to build data warehouse/data mart environment for reporting and analytical purpose using tools like Informatica Power center, Sql and Scripting.

Interacts with business users to understand the requirements.

Created technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, turn over documents etc.

Involved in ETL architecture to decide the Staging platform, repository, DB to be used.

Used complex Informatica mappings to extract data from the different database source system by using Joiner Transformation heavily.

Converted complex Mainframe jobs into the ETL.

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

Converted complex Transformation requirements to Informatica Transformations to transform the Source data to match the target data.

Implemented various performance tuning activities related to Informatica, Databases and UNIX for complex loads.

Resolved several ETL performance issues there by cutting the run time from several hours to minutes to UNIX scripting jobs and Informatica jobs.

Designed and developed complex mappings to load the Historical, Daily, Weekly and Monthly data from different source systems.

Worked and responsible for running the AUTOSYS Jobs for the scripting jobs.

Design document for mapping, which include details of field-to-field mapping between sources and target, Business (Transformation) Rules, Parameters, Processing flow and details of sessions, pre-dependencies, post-dependencies, and exception error processing methodology, Quality Gate documents.

Worked closely on the major defects in MODEL OFFICE & PRODUCTION Environment.

Used slowly changing dimensions.

Monitored Data Quality, Informatica Data Quality (IDQ) routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.

Involved in reading data from XML/XSD, Flat files, COBOL/VSAM files and Web services.

Environment: Informatica Power Center 9.1.1, Informatica Power Exchange 9.1.0, IDQ 8.6, DB2, Oracle 11g/10g, UNIX Shell scripting, Linux, COGNOS, Autosys, Informatica Native Scheduler, File Zilla, Editplus3, Beyond Compare, DB Visualizer, RAPID SQL 8.6.1.

Molina Health care, Troy, MI Aug 2013 - Oct 2014

Informatica Developer

Responsibilities:

Analyzed the existing systems and made Feasibility Study.

Wrote and reviewed documents like User Data Sheet (UDS), Functional Specifications (FS), and ETL Specifications.

Established standard code migration process.

Extracted data from a wide variety of Sources like Flat files, XML files, Relational Databases (Oracle, SQL Server).

Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Stored procedure, and Sequence generator transformations.

Developed transformation logic to cleanse the source data for inconsistencies in source to staging area mappings.

Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.

Developed slowly changing dimension mappings (Type 1 & Type 2).

Defined Target Load Order Plan for loading data into Target Tables.

Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.

Created UNIX shell scripts to handle pre and post session tasks, and to ftp files on to Informatica server.

Created and tested shell scripts to automate Job scheduling by using commands like pmcmd.

Involved in different phases of testing like Unit, Functional, Integration and System testing.

Creation of Review documents for specification document and test cases.

Performance tuning of targets, sources, mappings and sessions.

Troubleshoot loading failure cases, including database problems.

Code migration from development to QA and production environments.

Knowledge working with web services transformations in Informatica.

Knowledge working with SOAP, WSDL files.

Resolving production issues.

Developed and tested stored procedures, functions and packages in PL/SQL.

Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer and PL/SQL Developer.

Environment: Informatica Power Center v9.1.0, Windows-XP (Client), Oracle 11g, SQL Server 2008 R2, Informatica servers on Unix, SQL Developer, DB2, PL/SQL Developer.

Ameriprise India Ltd, Bangalore, India March 2012 - July 2013

Informatica Developer

Responsibilities:

Worked as ETL developer to gather all requirements.

Interacts with business users to understand the requirements.

Created technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, Turn over documents etc.

Involved in ETL architecture meetings and any new tool implementations.

Used complex Informatica mappings to extract data from the source system to the Staging DB.

Converted complex Oracle PL/SQL Packages to Informatica Mapping/Mapplets.

Converted complex Transformation requirements to Informatica Transformations to transform the Source data to match the target data.

Designed and build the wrapper script to call the Informatica workflow and session to migrate the data from one end to other end.

Worked on the Macro`s for building parameters, generating the source and inserting the Metadata.

Implemented various performance tuning activities related to Informatica, Databases and UNIX for complex loads. Resolved several ETL performance issues there by cutting the run time from several hours to minutes.

Designed and developed complex mappings to load the Historical and Weekly data from different source systems.

Worked and responsible for running the Control M Jobs.

Design document for mapping, which include details of field-to-field mapping between sources and target, Business (Transformation) Rules, Parameters, Processing flow and details of sessions, pre-dependencies, post-dependencies, and exception error processing methodology.

Worked closely on the major defects in QA and UAT Environment.

Created Data Flow Diagrams using Microsoft Visio to depict the flow of the Mappings.

Used slowly changing dimensions.

Coordinate with project management team and ensure accuracy on all deliverables and prepare summary reports.

Involved in reading data from XML/XSD, Flat files, COBOL/VSAM files.

Environment: Informatica Power Center 8.6, IDQ, DB2, Oracle, UNIX Shell scripting, Linux, OBIEE, Control M, Teradata, DB Visualizer, Perl Scripting, XML Files, COBOL Files.

Education:

Bachelor’s in computers science from Osmania University.

Contact this candidate