Candidates About

 

Chandana

ETL/Informatica Developer

Professional Summary:

·         8+ Years of IT experience in Data warehouse/Data Mart design experience with extensive knowledge in SDLC: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 9.6.1/9.5.1/8.1.1/7.x and maintenance of Data Warehouses in Teradata, Metadata Oracle, Netezza, SQL and PL/SQL programming.

·         Experience in working with Designer , Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities.

·         Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica Power Mart/Power Center with flat files, Oracle, SQL Server, and Teradata.

·         Experience working on Data quality tools Informatica IDQ 9.1.

·         Experience working in multi-terabytes data warehouse using Databases like Oracle 11g/10g/9i, MS Access 2000/2002, XML, IBM UDB DB2 8.2, SQL Server 2008, MS Excel and Flat files.

·         Experience Relational Modeling and Dimensional Data Modeling using Star Snow Flake schema, De normalization, Normalization, and Aggregations.

·         Very strong in SQL and PL/SQL, extensive hands on experience in creation of database tables, triggers, sequences , functions, procedures, packages, and SQL performance-tuning.

·         Proficiency in data warehousing techniques like data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment, change data capture.

·         Have Good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions SCD1, SCD2 and SCD3.

·         Experience in testing coordination, writing test cases and executing test scripts and logged defects in Quality Center QC.

·         Working closely with ETL developers and other leads during development and support of BI application.

·         Experience with Data Extraction, Transformation, and Loading ETL from disparate Data sources, Multiple Relational Databases like Oracle, DB2-UDB and Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model using Erwin.

·         Creation of tables, packages, mappings, batch jobs, roles and users in Informatica MDM Hub.

·         Created personalized version of reports as well as statements for customers using the data from Informatica metadata and then generated Business Objects reports using slice and dice capabilities.

·         Worked extensively in various kinds of queries such as Sub-Queries, Correlated Sub-Queries, and Union Queries for Query tuning.

·         Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.

·         Having hands on experience in Informatica Power Exchange and Informatica IDQ. 

·         Hands on experience using query tools like TOAD, PLSQL developer, Teradata SQL Assistant and Query man.

·         Developed UNIX scripts for dynamic generation of Files & for FTP/SFTP transmission.

·         Developed Complex mappings from various transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Normalizer, Joiner, Union, Update Strategy.

 

 

Technical Skills:

                               

Operating System	UNIX, Windows, MS-DOS
Language/Tools	SQL, PL/SQL, C, C++
Scheduling Tools	Autosys, Control-M, Informatica Scheduler,
ETL Tools	Informatica Power Center 10.x/9.x/8.x, ETL Informatica Cloud, SSIS
Database	MS SQL Server, Oracle 8i/9i/10g, RDBMS DB2, Netezza, Teradata, PostgreSQL
Scripting	Shell Scripting, Python
Data Modeling Tools	Microsoft Visio, ERWIN 9.3/7.5
Data Modeling ER	(OLTP) and Dimensional (Star, Snowflake Schema)
Data Profiling Tools	Informatica IDQ 10.0, 9.5.1, 8.6.1
Excel Tools & Utilities	TOAD, SQL Developer, SQL*Loader, Putty
Cloud Computing	Amazon Web Services (AWS), S3, RDS, Redshift, SNS
Other Tools	Notepad++, Toad, SQL Navigator, Teradata SQL Assistant, Rally, AWS Cli
Defect Tracking Tools	ALM, Quality Center
Reporting Tools	Tableau 9

                               

Professional Experience:

 

Client & Location: TIFFANY & Co., Parsippany, NJ

Domain: Retail            

Duration: July’17 – Till Date

Role: Sr. Informatica Developer

 

Responsibilities:

·         Interacting with the end users to get the business Requirements, reporting needs and created Business Requirement Document.

·         Parsed high-level design specification to simple ETL coding and mapping standards.

·         Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

·         Created mapping documents to outline data flow from sources to targets.

·         Extracted the data from the flat files, DB2, SQL server and other RDBMS databases into staging area and populated onto Data warehouse. Worked on Flat Files and XML, DB2, Oracle as sources.

·         Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

·         Used Debugger to test the mappings and fixed the bugs.

·         Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.

·         Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

·         Generated ABAP programs to load data into Oracle from SAP source systems.

·         Customize ABAP programs according to business requirements to load data with respect to SAP source systems

·         Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

·         Developed mapping parameters and variables to support SQL override.

·         Worked on performance tuning by creating views in Oracle and implemented transformation logics in database using views.

·         Developed mappings to load into staging tables and then to Dimensions and Facts.

·         Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

·         Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

·         Modified existing mappings for enhancements of new business requirements.

·         Involved in Performance tuning at source, target, mappings, sessions, and system levels.

·         Prepared migration document to move the mappings from development to testing and then to production repositories.

·         End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads.

·         Created various rules in IDQ to satisfy the Completeness, Conformity, Integrity, Timeliness 

·         Cleansed, standardized, labeled and fix the data gaps in IDQ where it checks with reference tables to fix major business issues 

·         Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports. 

·         Exposed IDQ mapping/ mapplets as web service. 

·         Worked on enhancements for stored procedure and IDQ web services. 

·         Worked on Informatica Advanced concepts & also Implementation of Informatica PushDown Optimization technology.

·         Performed Source System Data analysis as per the Business Requirement. Distributed data residing in heterogeneous data sources is consolidated onto target Enterprise Data Warehouse database.

·         Designed ETL Flow diagram in Visio to arrive at the schedule for TWS Jobs

·         Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.

·         Tested all the modules and transported data to target Warehouse tables, scheduled, ran extraction and load process and monitor sessions and batches by using Informatica Workflow Manager and log files.

·         Precise Documentation was done for all mappings and workflows.

·         Responsible for ETL process under development, test and production environments.

·         Written test Plans, test Cases, Test scripts, test scenarios for the Quality releases in the SOA  and Maintenance release

·         Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and USER testing. Also provided production support by monitoring the processes running daily.

 

Environment: Informatica Power Center 9.6.1, Tidal, Oracle11g, SAP, Toad, DB2, WinSCP, WinSQL, ERWIN, UNIX and TWS.

Client & Location: The Standard Insurance, Portland, OR

Domain: Financial      

Duration: May’16 – June’17

Role: Informatica Developer/Admin

 

Responsibilities:

·         Provided technical leadership and developed new business opportunities.

·         Supported day to day activities of the Data Warehouse.

·         Analyzed the business requirements and functional specifications.

·         Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.

·         Used Informatica Power Center 9.1/8.6 for extraction, transformation and load (ETL) of data in the data warehouse.

·         Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.

·         Developed complex mappings in Informatica to load the data from various sources.

·         Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

·         Parameterized the mappings and increased the re-usability.

·         Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.

·         Created procedures to truncate data in the target before the session run.

·         Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.

·         Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.

·          Have Experience on Teradata Utility scripts like BTEQ, FastLoad, MultiLoad and FastExport to load data from various source systems to Teradata. 

·         Working knowledge on Oracle 11g, SQL Server, Teradata, Netezza, DB2, MY SQL and UNIX shell scripting

·         Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

·         Involved in Unit testing, System testing to check whether the data loads into target are accurate. 

·         Experience in building, enhancing and managing Universes, creating WebI, DeskI, Complex, Adhoc Reports, Canned Reports, and Charts using Business objects.

·         Experience in complex data analysis in Designer, used data from multiple data providers, performed extensive data analysis with complex queries, drill up, drill down, slice and dice. 

·         Strong hands-on experience in creating/enhancing Universes using BO Designer and in creating and maintaining reports using Business Intelligence ,Business objects  , Crystal reports, Web Intelligence, and Desktop Intelligence Written documentation to describe program development, logic, coding, testing, changes and corrections.

·         Created Schemas (Universes), Imported Tables and Loaded data to tables and also copied standard content from SAP to local repository using SAP HANA.

·         Used Hana Studio to Create Attribute Views, Analytical views and calculated views. 

·         Created Test cases for the mappings developed and then created integration Testing Document.

·         Followed Informatica recommendations, methodologies and best practices.

·         Fine-tuned Informatica transformations and workflows for better performance.

·         Involved in the performance tuning of Informatica mappings by using Informatica Push Down optimization (PDO).

·         Using SSRS, Deployed and generated reports of each quarter onto the Report Server to access it through browser.

·         Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS. 

·         Formatted the SSRS reports using the Global variables, expressions and Functions. 

·         Created Jobs Performance reports that queries system tables to track the duration of each job and weekly-average duration using SSRS. 

·         Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, and SQL parameters. 

·         Installed and configured Informatica Power Center 9.1 and 8.6

·         Migrated Informatica code and managed security and permissions.

·         Designed, created and modified SQL database objects.

·         Developed data models from technical and functional specifications.

·         Excellent knowledge in data analysis, data cleansing and data validation.

·         Represented Informatica and SQL server on Enterprise architecture board.

·         Developed SSIS packages to load data into warehouse and benchmark the performance.

·         Supported multiple lines of business and IT initiatives.

·         Used Informatica Metadata Manager to show data lineage.

·         Collaborated with remote offshore team, creating the requirement documents, verifying coding standards and conducting code reviews.

 

Environment: Informatica Power Center 9.1/8.6, Power Exchange, SAP HANA, DB2,Tivoli, SQL server 2005 / 2008, linux.

 

Client & Location: Emids, Nashville, TN  

Domain: Healthcare 

Duration: Oct’14 - April’16.

Role: Informatica Developer

Responsibilities:

·         Created Informatica mappings using various transformations like XML, Source Qualifier, Expression, look up, stored procedure, Aggregate, Update Strategy, Joiner, normalizer, Union, Filter and Router in Informatica designer.

·         Extensively worked with Teradata database using BTEQ scripts.

·         Involve in all phase of SDLC ,i.e. design, code, test and deploy ETL components of data warehouse and integrated Data Mart .

·         Created subscriptions for source to target mappings and replication methods using IBM CDC tool.

·         Used NZSQL scripts, NZLOAD commands to load data.

·         Experience in Data Stage Upgrade and Migration projects - from planning to execution.

·         Analysis of heterogeneous data from various systems like pm and Salesforce.com and validating it in ODS (operational Data store).

·         Worked with Informatica IDQ Data Analyst, Developer with various data profiling techniques to cleanse, match/remove duplicate data.

·          Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ.

·         Designed and developed IDQ solutions for data profiling. Implemented Address Doctor as Address Validator transformation for data profiling in IDQ. 

·         Worked extensively with Netezza scripts to load the data from flat files to Netezza database.

·         Created mappings using pushdown optimization to achieve good performance in loading data into Oracle and Teradata.

·         Developed various SQL queries using joins, sub-queries & analytic functions to pull the data from various relational DBs i.e. Oracle, Teradata & SQL Server. 

·         Created Web services mappings for consumer and Provider, used Webservices consumer transformation, XML parser to parse the incoming data.

·         Created and edited custom objects and custom fields in Salesforce and checked the field level Securities.

·         Worked in the Informatica cloud in order to replicate the data from the Salesforce. 

·         <span style="colo