SUMMARY:

• Over 13 years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• Experience in working with various versions of Informatica Power Center 10.2/9.5/8.6/7.1/6.2 Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2.
• Expert in troubleshooting/debugging at different stages like database, workflows, mapping.
• Intense Knowledge in designing Fact & Dimension Tables, Physical & Logical data models.
• Involved in writing Unit test cases for complex scenarios.
• Dimensional Data Modelling experience on Data modelling, Erwin 7.1/4.5/4.0/3.5.5/3.5.2, Ralph Kimball Approach, Data marts, OLAP .
• Good knowledge of Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling using Erwin and OLAP .
• Experience in creating UNIX shell scripts and Perl scripts.
• Working experience using Tableau products including Tableau Desktop, Tableau Server.
• Experience in Tableau Reporting, creating Dashboards using Tableau Desktop

TECHNICAL SKILLS:

• Data warehousing: Informatica Power Center 10.x/9.6/9.5.1 HF 1/8.6/8.5/8.1/7.1/6.2/5.1, Pentaho ETL tool, Metadata Reporter Data Profiling, IDQ, Data cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling, Erwin 4.0
• BI Tools: Tableau 2018.3/10.4/10.3/102/10.1/9.0/8.2/8.1, Business Objects XIR 2/6.0/5.1/5.0
• Databases: SQL Server 2005/2000/7.0/6.5, Oracle 10g/9i/8i/8/7.3, Sybase, My SQL, MS - Access, DB2 8.0/7.0, Teradata
• Languages: C, C++, XML, SQL, PL/SQL, UNIX Shell Scripting
• HPUX11/10/9, Confidential: AIX4.0/3.1, Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows 10/ 7/XP Professional/2000/NT/98/95
• Other Tools: MS Visual Source Safe, PVCS, Autopsies, Mercury Quality center, Star Team, JIRA, Confluence
• DB Tools: SQL Developer, SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, SQL Tool

WORK EXPERIENCE:

Confidential, Mason, OH

Sr. ETL Informatica Developer

Responsibilities:

• Involved in Provider Care Management Solutions application business requirements, business process development and production deployment including documentation
• Analysing data flow and identify source systems and its relationships to process and design data load based on star schema models to meet the business requirements
• Involved in data refresh of Commercial, Medicare and Medicaid data files for monthly, quarterly, baseline scorecard metric to show in PCMS application
• Involved in creating design document and data flow diagrams to migrate data from source systems to staging tables and from staging tables to target.
• Developed Informatica Mappings and Mapplets to load data using various Power Center transformations
• Involved in creating test cases and coordinating with business user and getting UAT approval to migrate the code
• Involved in Production Release activities of Informatica Objects from Dev to QA and QA to Prod Environments
• Involved in production support and on call support activities and address business users concerns on Jira board
• Involved in regular scrum meetings and follow the agile methodologies
• Involved in performance enhancements and batch load process to reduce the run time
• Created Ad-hoc reports and closely working with business users
• Created complex SQL queries with multiple table joins to retrieve data from database

Environment: : Informatica 10.2, Oracle 11g, DB2, Teradata, PIMS, MRDM, Medicaid, Medicare Flat files.

Confidential, Madison, WI

Sr. ETL Informatica Developer

Responsibilities:

• Involved in Business Requirements, review meetings and defining business process, deliver project plan including documentation
• Analysing existing transactional database schemas and designed star schema models to support the users reporting needs and requirements.
• Involved in data migration from legacy systems to staging tables and from staging tables to Warehouse
• Developed Informatica Mappings and Mapplets to load data using various Power Center transformations
• Worked with Relational files, Flat files to populate to relational data bases and create staging environment to target warehouse
• Involved in Release management of Informatica Objects from Dev to QA and QA to Prod Environments
• Involved in design of data warehouse in star schema with fact and dimension tables
• Involved in testing applications and load the data to the target Warehouse
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks
• Involved in regular scrum meetings and interacted with business on issues, concerns and clarification
• Created Ad-hoc reports and closely working with business users
• Created complex SQL queries with multiple table joins to retrieve data from database

Environment: : Informatica 10.2, Oracle 11g, DB2, SQL Server, Flat files, SharePoint, People Soft NVision data, Tableau 2018.3.

Confidential, Indianapolis, IN

Sr. ETL Informatica Developer

Responsibilities:

• Involved in creating different kinds of analytics in risk-based monitoring system for on boarding studies based on existing clinical trials
• Involved in requirement discussions with customer and developing the dashboards using tableau desktop and publish in the server
• Analysis, design, and implementation of numerous Informatica applications and data
• Extensive development of Informatica interfaces by using transformations including connected and unconnected lookup, expression, router, joiner, filter, aggregator, and update strategy
• Development of mapplets as reusable code when appropriate and update of worklets and workflows
• Created Unix Shell Scripts to run Informatica jobs and to implement batch processing
• Participation in meetings with business users to identify, document, and implement their business requirements, Documentation and maintenance of all procedure and work instruction documents related to, support
• Migration of changes, enhancements, upgrades, etc. through the various environments
• Preparation of ongoing status reports to communicate to technical and business managers the status of work undertaken
• Involved in performance tuning by using complex custom SQL queries
• Connected Tableau server to publish dashboard to a central location for .Net application while publishing the dashboards, Involved in scheduling and incremental refresh of the dashboards
• Created different types of calculated fields to meet the customer requirements
• Experienced working with various kinds of data sources such as Flat Files, Oracle, and processing large datasets
• Implemented various kinds of dashboards for treatment compliance, stratification factors, missing scales and treatment vs. randomization analytics.
• Used multi table joint and also blend the data from different data sources based on the common dimension
• Created user filters for the data security
• Involved in creating test scripts and update data scenarios based on the business requirements
• Involved in formal and informal testing using HP Application Life Cycle Management Systems

Environment: : Informatica 9.6, Oracle 11g, HP QC/ALM, Service Now, TFS (Team Foundation Server), Microsoft Visual Studio, Tableau 10.4/10.3.

Confidential, CA

Sr. ETL Informatica Developer

Responsibilities:

• Used the Informatica Designer to create complex mappings using various transformations like Expression, Filter, Lookup, Joiner, Aggregator, Update strategy transformations etc.
• Used Informatica Repository manager to migrate objects from individual developer folders to the integrated project folder to the Dev/UAT environment
• Backed up and restored repositories using the Informatica Repository Manager
• Involved in Extensive Performance and Tuning of Mappings to reduce processing time, increase performance
• Extracted financial data from various sources using Informatica, designed, developed, and tested mappings for getting data in and out of the warehouse
• Created High Level Design documents, detail design documents and presentations as a part of the Technical Design Architecture.
• Involved in gathering business requirements from users and creating technical design specs, Informatica map flows and schedule documents for each business unit
• Extensively involved in deploying a comprehensive data warehouse and enterprise reporting system for users around the world with a 24/7-production support
• Involved in creating unit and integrated test-packs for different test scenarios along with business users.
• Involved in performance tuning by using complex SQL extracts
• Experience in Salesforce (SFDC) data integration with Informatica cloud
• Implemented various kinds of dashboards for charge backs and fraud transactions.
• Created user filters for the data security
• Experience in Hadoop Hive SQL and big data technologies
• Perform data ingestion into a Hadoop cluster, data processing on the cluster and extraction of data from the Hadoop cluster by using Informatica BDM

Environment: : Informatica 9.5.1 HF1, Oracle 11g, SQL Server, DB2, My SQL, Hadoop, Hive SQL, SFDC Sales/Marketing Cloud, Tableau 8

Confidential, Pleasanton, CA

Sr. ETL Informatica Lead Developer

Responsibilities:

• Participation in Business Requirements, review meetings and defining business process, deliver project plan including documentation
• Extracted data from different sources like DB2, Oracle and Flat files and loaded into target database
• Involved in development of Informatica Mappings, Mapplets and Workflows for complex business process
• Created various transformations like Expressions, Lookups, Filters, Sequence Generator, Joiner, Aggregator etc
• Transaction Control were used to handle situations depending upon the requirement.
• Created Parameter file for session parameters and called in the sessions.
• Created Partitions to concurrently load the data into targets
• Performed Unit Testing and verified the data.
• Tuned mappings and sessions for better performance of the data loads
• Performed Error Handling on Sessions.
• Written UNIX shell Scripts, PMCMD commands for FTP of files from remote server
• Performed Informatica Code Migration from development to testing and testing to production systems.
• Implemented Slowly Changing dimension (SCD) methodology for accessing the full historical data
• Communicate with offshore team to sync with the business logic and share the knowledge
• Involved in all phases of Software development life cycle