SUMMARY

• 8+ years of experience in Information Technology with a strong background in Database development.
• Having strong abilities and a comprehensive understanding of the requirements and solutions to various issues in software development life cycle implementation (SDLC).
• Worked in different phases of the projects involving Requirements Gathering and Analysis, Design, Development, Testing, Deployment and Support.
• Good experience in designing, Implementation of Data warehousing and Business Intelligence solutions using ETL tools like Informatica Power Center, Informatica Developer, Informatica Power Exchange, Informatica Data transformation studio, Informatica Intelligent Cloud Services (IICS).
• Expertise in Informatica Data Transformation, Informatica Power Center, and Informatica B2B Data Exchange (DX).
• Worked on Streamer, Parser, Mapper, Serializer and intake of several input formats Healthcare Industry layouts.
• Extensively worked on Informatica B2B Data Exchange from Partner setup, Profile setup, Endpoint creation, Scheduler, Event attributes creation, Event status creation, etc.
• Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un - connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, Unstructured data transformation, SQL transformation and more.
• Experience working with cloud-based database solutions like AWS Redshift and Snowflake.
• Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Experience in developing Transformations, Mapplets and Mappings in Informatica Designer and creating tasks using Workflow Manager to move data from multiple sources to target.
• Extensively used mapping variables and workflow variables to pass the mapping variables from one session to another session in a workflow.
• Experience working with Informatica data transformation studio to analyze and parse files with HL7 format, understand different modules of EDI interfaces for source data, working with 834’s.
• Good Knowledge on Database architecture of OLTP and OLAP applications, Data Analysis.
• Worked with wide variety of sources like Relational Databases, Flat Files, XML files, Mainframes, Unstructured data files and Scheduling tools like CA7, Control-M and Informatica Scheduler.
• Experience working with various Informatica concepts like partitioning, Performance tuning, identifying bottlenecks, deployment groups, Informatica scheduler and more.
• Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes), UNIX Shell scripting and Windows Batch scripting.
• Expertise in doing Unit Testing, Integration Testing and Data Validation for Developed Informatica Mappings.
• Experience working in Production Support, Support for Emergency fix and migrating fix from lower environment to higher environment as per the policies.
• Very good exposure to Oracle 11g/10g/9i, MS SQL Server 2012/2008/2005 , Teradata, IBM DB2.
• Excellent Verbal and Written Communication Skills. Has proven to be highly TEMPeffective in interfacing across business and technical groups.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1/ 9.6.1/9.5.1/9.1/8.6. x/8.1.x, Informatica Power Exchange 9.5.1, Informatica developer 9.6.1, B2b DX, Informatica iCloud

Cloud Tools: Informatica Intelligent Cloud services (IICS)

Data Modeling: Star Schema, Snowflake Schema, Erwin 4.0, Dimension Data Modeling.

Databases: Oracle11g/10g/9i, SQL Server 2012/2008/2005 .

Scheduling Tools: CA7 Scheduler, TWS(Tivoli), Informatica Scheduler

Reporting Tools: Crystal Reports, MicroStrategy, and Hyperion Essbase.

Programming: SQL, PL/SQL, Transact SQL, HTML, XML, Java, Shell, Perl, Batch

Operating Systems: Windows 7/XP/NT/2000, DOS, UNIX and LINUX

Other Tools: SQL*Plus, Toad, SQL Developer, Putty, SSIS, WINSCP, MS-Office.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. ETL Informatica Developer

Environment: Informatica PowerCenter 10.1.0, Informatica Developer 10.1.0, B2b DX Data Exchange, Data Processer, Parser, Serializer, Mapper, Transformer, Microsoft SQL Server Management Studio 12.0, HIPAA X12 file, XML files, fixed width & delimited flat files.

Responsibilities:

• Performing software development life cycle (SDLC) project activities Understanding and analyzing functional and technical specification documents.
• Working in Agile Environment and participating in daily and weekly meeting to discuss new requirements, design, testing, performance, and providing updates etc.
• Worked on informatica B2B data transformation for parsing the files using the parsers and HIPPA libraries.
• Building ETL Informatica Application for sending Healthcare EDI files i.e., 834, 835, etc. Building ETL Informatica mapping for receiving and processing Healthcare files i.e.,837 Professional, 837 Institutional, 837 Dental claims
• Developing complex Informatica mappings and workflows to process the data using different transformations like UDT (Unstructured Data Transformation), connected and unconnected lookup, expression, aggregator, joiner, filter, normalizer, rank and router transformations and new programs are written as per the requirement and modification of existing code according to change requirement.
• Created projects chaining the parsers, mapper, and serializer to convert any input file format to any other format.
• Design, development, testing and implementation of ETL process using Informatica Cloud.
• Extensively used relational sources, flat files, xml sources.
• Developed common Mapplets that can be used across the project.
• Developing Data Transformation (DT) Services for creating and validating EDI files (834, 837 etc.). In Informatica mapping, calling DT Service through UDT for creating and validating EDI files.
• Setting up Partner, Account, Profile and Endpoint in Informatica B2B Data Exchange. And processing files through Informatica B2B Data Exchange for onboarding clients.
• Imported the Power Center workflows to B2B data exchange console to invoke the power center workflows.
• Production deployment of ETL Informatica objects i.e., Workflows, Sessions, Mappings, DT Services, B2B DX Profiles and Windows Scripts.
• Documentation of ETL process for support and troubleshooting. Resolving and fixing the production issues.
• Scheduled workflows sequentially and parallelly.
• Extensively used deployment groups for migrating the ETL jobs from lower environment to higher environment.
• Identified the issues with the existing reports and provided the necessary solutions to fix the issues.
• Modifying the existing ETL codes as per the new requirements.

Confidential, Grand Rapids, MI

Sr. ETL Informatica Developer

Environment: Informatica PowerCenter 9.6.1, Informatica Intelligent Cloud Services (IICS), Oracle 11g, SQL Server 2012, SQL Server Integration Services (SSIS), fixed width & delimited flat files, XML files, HL-7 file, Unix Shell Scripting, Perl Scripting

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data mart for an application portal which is primary source for ETL feed in dis project.
• Involved in creating Logical and Physical Data Models and creating models by defining integrity between tables.
• Working closely with BA’s to draft the requirement from source to target as per the business requirements and creating standard documents for design, review and development.
• Created IICS connections using various cloud connectors in IICS administrator. Installed and configured Windows Secure Agent register with IICS org
• Extensively used performance tuning techniques while loading data into Azure Synapse using IICS.
• Created mappings involving concept of full/incremental loads, type 1 and type 2 loads.
• Developed interfaces to report the data to/from DWH which involved development for constraint-based loading, dimension and fact loads.
• Worked on Parsing and marking unstructured files with HL-7 format and reading the data through Informatica power center with TEMPeffectively using unstructured data transformation.
• Informatica B2B to read different modules of EDI system. Convert files from EDI into XML file format.
• Extensively involved in understanding HIPAA validations, EDI systems, facets systems.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files
• Created Mapplets/Worklets and used them in different Mappings/Workflows. Created command tasks to automate scripting, Decision task, File Watcher in the workflows.
• Developed Perl script to call the workflows in all the environments rather TEMPthan manually triggering the job.
• Experience working with putty terminal to Create, Edit, Move parameter files/source files/lookup files and target.
• Experience working on identifying bottleneck, performance tuning for better customer delivery.
• Data analysis/Code validation in production environment to ensure any future failures/anomalies.
• Worked on data visualization and understanding the underlying analytical data warehouse for various client projects.
• Worked on building SQL queries to validate and handle data requests of increasing complexity for business users.
• Creating Deployment group for Informatica code migration to higher environments.
• Created Schema objects like Indexes, Views, Sequences, Stored Procedures and Constraints
• Daily production supports for the scheduled job and provide the resolution related to failed job.
• Worked on batch processing and file transfer protocols using scripting techniques.
• Analyzed the enhancements coming from the individual Client for application and implemented the same.
• Involved in complex development with agile timelines for business delivery.
• Automating Informatica Jobs in Production using TWS. Resolving any defects, issues by tracking it in JIRA.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Confidential, Detroit, MI

ETL Informatica developer

Environment: Informatica Power Center 9.1/8.6.x, Power Exchange, PL/SQL, Oracle 10g/9i, SQL Server 2008/2005, Windows Server 2003, UNIX, Tivoli Scheduler, Toad

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering and designing of the data warehouse.
• Involved in creating Logical and Physical Data Models and creating Star Schema models.
• Assisted in designing Star Schema to design dimension and fact tables.
• Involved in developing star schema model for target database using ERWIN Data modeling.
• Worked on Informatica PowerCenter - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Complex mappings using Unconnected and connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files
• Created Mapplet and used them in different Mappings. Created events and tasks in the workflow manager.
• Developed Informatica mappings and tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views and Sequences. Created Stored Procedures, Functions using Oracle.
• Daily production supports for the scheduled job and provide the resolution related to failed job and fixed them.
• Worked on batch processing and file transfer protocols.
• Worked on performance tuning of the workflow which are taking time.
• Analyzed the enhancements coming from the individual Client for application and implemented the same.
• Creation of technical documents.
• Developed mappings for policy, claims dimension tables.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.

Confidential

ETL Informatica developer

Environment: Informatica Power Center 8.x, PL/SQL, Oracle 9i, SQL Server 2008/2005, UNIX, Control-M, Toad, Putty

Responsibilities:

• Study and analyze mapping document, the required source tables, data types, required transformations based on Business requirements and technical specifications.
• Using Informatica Power Center, extracting data from SQL Server, Oracle, XML files and Flat Files.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Used SQL overrides in Source Qualifier and Lookups to improve mapping performance.
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Created Materialized views for summary tables for better query performance.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Providing extensive changes as a part of User acceptance testing and deployment of mappings at client place.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.