SUMMARY

• Around 9 years of IT experience as an ETL Developer in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 10.4.1/ 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools, Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 10.4.1/ 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Performance tuning of the long run jobs in SQL using Explain Plan.
• Creating and Running Ad-hoc queries to support business operations reporting.
• Monitoring workflows in workflow monitor and in the scheduler in providing the batch support and helped support team for fixing the failures.
• Provide System and Application Administration for Informatica PowerCenter and PowerExchange
• Prepared Details design level document thoroughly for production support to use as hand guide for future production runs before the code gets migrated.
• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 9.x
• Updating GIT and GITHUB repositories with the development changes.
• Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage.
• Adept knowledge and experience in mapping source to target data using IBM Data Stage 8.x
• Creating the package using Jenkins for deploying the code to the higher environments.
• All the responsibilities are carried in Agile Scrum Model and played the role of DevOps Engineer which manages the team of 6 members by handling multiple projects.
• Delivered the finalized items at the end of each sprint as per the Product Backlog.
• Created the Sub-Tasks for the User Stories created in JIRA and updated the status
• 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 Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Worked with business users and client to understand and document business requirements and provide ETL solutions.
• Worked extensively on Informatica Power Center (10.1) tools such as Designer, Repository manager, Workflow manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• 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 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

Tools: InformaticaPC 10.x/9.x/8.x,InformaticaPower Exchange,ODI, InformaticaData Quality (IDQ) 9.x andInformaticaAnalyst tool 9. x.

Languages: XML, UML, HTML, C, C++, Python, UNIX, Shell Scripting, SQL, PL/SQL, T-SQL.

Database: Oracle 19c/11g/10g/9i/8i/, SQL Server, IBM DB2, MS Access, Teradata.

Operating System: Windows 98/NT/2000/2003/XP/Vista/7, Sun Solaris 5.8/5.6, HP-UX, DOS, Red Hat Linux, SOAP, UnixAIX5.3/4.3.

Reporting & Data Modeling Tools: Cognos, Erwin Data Modeler, MS Visio, MS Visio, Star Schema Modeling, Snowflake Modeling

Other Tools: TOAD, SQL Loader, SQL Plus, Query Analyzer, Putty, AWS, MS Office (MS Access, MS Excel, MS PowerPoint, MS Word, MS Visio).

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. ETL Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• 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.
• 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.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.
• Designed XML stages for reading XML log files for capturing data stage jobs audit data.
• Done Code reviews of ETL and SQL processes. Worked on upgrading Informatica from version 9.x to 10.x.
• Convert specifications to programs and Integration Data Mapping for ETL Informatica IICS environment.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• Designed Data warehouse ETL Informatica test cases for source and target DB validation.
• Created profiles and score cards for the users using IDQ.
• Created mapping to load data into AWS S3 bucket using Informatica S3 connector also populated data into Snowflake from S3 bucket using complex SQL query.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Create UNIX shell scripts to fulfil various business functionalities.
• 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.
• Loaded diverse types (Structured, JSON, XML, flat files etc.) into the Snowflake schema, Star schema data warehouse.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management.
• Utilized Informatica IDQ 10.0 to complete the initial data profiling and matching/removing duplicate data for the process of data migration from the legacy systems to the target Oracle Database.
• Resolving the tickets based on the priority levels raised by QA team.
• Developed Parameter files for passing values to the mappings for each type of clients.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
• Develops PowerCenter Workflows and Sessions, and sets up Power Exchange connections to database and mainframe files
• Provide System and Application Administration for Informatica PowerCenter and Power Exchange
• Developed Oracle Structured Query Language SQL test scripts from test procedures and executed them Used SQL queries to retrieve data from tables and to perform back-end testing thru SQL server
• 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 PowerCenter 10.x/9.x, Informatica Power Exchange 10.1, IDQ, IICS R29, Tableau10.0, Linux, SQL, PL/SQL, TOAD, Snowflake IICS Data Warehouse, Teradata 15, AWS S3 Bucket, SQL Server 2012, ORACLE 12c, Control M, Shell Scripting, JSON, SQL Loader, Windows, UNIX.

Confidential, NC, Charlotte

ETL Informatica developer

Responsibilities:

• Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Developed the audit activity for all the IICS mappings.
• Automated/Scheduled the IICS jobs to run daily with email notifications for any failures.
• Created applications connections like connection for database, Salesforce service cloud, salesforce sales cloud salesforce financial service cloud and many portals.
• Data integration with SFDC and Microsoft Dynamics CRM using Informatica cloud (IICS).
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Understand the complex Java/Python scripts to write the mapping rules.
• Integrated Informatica Data Quality (IDQ) with Informatica PowerCenter and Created POC data quality mappings in Informatica Data Quality (IDQ) tool and imported them into Informatica power center as mappings, Mapplets.
• Created UNIX shell scripting for automation of ETL processes.
• Understand the complex PL/SQL queries, Python scripts and developed Ab initio plans/graphs to replace the existing jobs with Ab-Initio code.
• Conducted rigorous regression testing to verify the new code does not missing and existing functionality of the Java/Python code.
• Responsibilities includes end to end activities such as mapping specifications, development, testing, production support and deployment.
• Performed Historical loads while loading the source table data to Data Warehouse, by maintain data versions.
• Design, Development, Testing and Implementation of ETL processes using Informatica Cloud (IICS).
• Developed the audit activity for all the cloud mappings
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Created File watcher jobs to setup the dependency between Cloud and PowerCenter jobs
• All the QAT test cases were sent to business UAT team for the power user approvals.
• Validated the data loaded using the internal navigator tools for maintaining integrity of data.
• Designs, develops and tests applications using Informatica PowerCenter, Informatica Data Quality, and Informatica Master Data Management to meet functional specifications
• Create data mapping and workflow using Informatica PowerCenter to extract, transform and load data into the target reporting environment
• Worked on Informatica Scheduler to schedule daily, weekly, monthly and quarterly jobs.
• Followed Agile Scrum model for managing the daily responsibilities and tasks.
• Used UNIX for check in's and checks outs of workflows and config files in to the ClearCase.
• Improving the performance of the ETL by indexing and caching.
• Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
• Develop, maintain, and administer complex ETL processes using IBM Data Stage
• Build new ETL processes to make new and existing data sources readily available to the business using IBM Data Stage
• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• 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.
• Imported various heterogeneous files using Informatica PowerCenter 9.6 Source Analyzer.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production.
• Documented Data Mappings/ Transformations as per the business requirement.
• Created XML, Autosys JIL for the developed workflows.
• Migration of code from development to Test and upon validation to Pre-Production and Production environments.

Environment: Informatica PowerCenter 10.1/9.6, Informatica Power Exchange 10.4.1/9.6, Data Quality, IICS, SQL Server 2008, Shell Scripts, Teradata 14, SQL, Oracle 11g PL/SQL, UNIX, Toad, SQL Developer, HP Quality Center, Cognos 9, T-SQL, MS Access, Windows.

Confidential, Bloomfield, CT

ETL Informatica developer

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• 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.
• Developed PL/SQL programming that included writing Stored Procedures, Packages, Functions and Database Triggers.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Effectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
• Worked on Power Mart client tools that are Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer in Informatica PowerCenter (10.1/9.6).
• Developed transformation logic by writing a query in Source Qualifier to cleanse the source data (from DB2) of inconsistencies before loading the data into staging area.
• Parsed high-level design specification to simple ETL coding and mapping standards by using expression transformation.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning and code enhancements.
• Experience in writing UNIX shell scripts for pre-processing and post-processing steps.
• Raised change requests, analyzed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD.
• Working with large amounts of data independently executing data analysis, utilizing appropriate tools and techniques (Interpreting results and presenting them to both internal and external client.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• Scheduled jobs for running daily, weekly and monthly loads through control-M for each workflow in a sequence with command and event tasks.

Environment: Informatica 9.5.0, Oracle 10g, SQL server 2005, SQL, T-SQL, PL/SQL, OBIEE 10.1.3, Toad, Erwin4.x, Unix, Tortoise SVN, Flat files.

Confidential

ETL Informatica developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• 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, and 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.
• Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.
• Supported Client Reporting Production Environment and perform troubleshooting analysis to resolve issues in critical applications and batch processes.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in using Automation Scheduling tools like ESP.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Stakeholder relationship with client and onsite team on daily/weekly basis for Scrum, stand up meeting and defect calls for production support and development enhancements.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• 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.
• 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 6.1., Oracle, MS SQL SERVER, SQL, PL/SQL, SQL Loader, UNIX Shell Script.