SUMMARY

• About 7 years of experience in Data Integration and Data Warehousing using ETL tool Informatica Power Center 10.x/9.x/8.x/7.x/6.x.
• Having experience in all the phases of Data warehouse life cycle which mainly involves Requirement Analysis, Design, Coding, Testing, and Deployment.
• Worked extensively on Informatica power center9.x/8.x/7.x. (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Administrator console)
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Experience in creating Reusable Transformations such as Update Strategy, Lookup, Expression, Joiner, Aggregator, Sorter, Sequence Generator, Router, Filter, Rank and Normalizer and Mappings using Informatica Designer and processing the tasks using Workflow Manager to move data from multiple sources into the targets.
• Thorough and detailed knowledge on Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions, Dimensional Modeling (Star Schema and Snow Flake Schema) and other OLAP concepts.
• Extensively worked on Code Migration from Development to UAT and Production.
• Worked on Advanced Scheduling tool known as Autosys, Tidal.
• Extensively worked on Informatica Web services transformations.
• Hands on experience on Informatica Web services (WSDL/XSLT/XML).
• Complete knowledge of data warehouse methodologies (Ralph Kimball, INMON), ODS, EDW and Metadata repository.
• Developed all types of slowly changing dimensions such as Type-I, Type-II, and Type-III.
• Hands on experience in UNIX & LINUXwork environment, including transfer of files, scheduling of jobs and error handling.
• Equipped with strong Dataware Housing and Business Intelligence concepts.
• Expertise in OLAP and Reporting tools like Business objects and Cognos.
• Expert-level mastery in creating UNIX Shell Scripts and also worked on integrating data from flat files, CSV files and XML files into a common reporting and analytical Data Model.

TECHNICAL SKILLS

• ETL Tools: Informatica Power Center 9.x/8.x/7.x, Power Mart, Power Channel 6.2, Power Exchange 5. Power Analyzer Data Profiling, Power Connect, and Data cleaning, Flat file system (Fixed width, Delimiter), OLAP,IDQ
• ETL data Integration Tools: Informatica Power Center / Power Mart 6.x/7.x/8.x/9.x(Designer, Workflow Manager, Work flow Monitor, Repository Manager, Repository Server Administration Console), Power Connect for ERP and Mainframes, Power Exchange, Data stage, Master Data Management (MDM) .
• Data Modeling: Erwin 4.0, Star - Schema Modeling, FACT and Dimension Tables
• DBMS: Oracle 12c/11g/10g/9i, Microsoft Access, SQL Server 2008/2005, MS Excel, Flat Files, Teradata, Sybase
• Languages: C, C++, Java, SQL, PL/SQL, HTML, DHTML, XML, UNIX, Shell Scripting, Visual basic, ASP, JSP, XML, Macromedia Software, JCL.
• Scripting Languages: Java Script, VB Script and UNIX Shell Scripting.
• Operating Systems: HP-Unix, Linux, Windows 2008/2003/NT/X
• Design Skills: Object Oriented Analysis Design using UML.
• Others: MS Project, MS Office Suite, Toad

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

ETL Developer

Responsibilities:

• Write up the conversion ETL programs based off of the gathered Spec documents and mappings by following the best practices and industry standards.
• Responsible for Conversion validations/obtaining sign off’s from testing/UAT team/following the release strategy -deploying it to production and support post production issues/questions.
• Worked as a conversion task force lead for the various master data tables.
• Deploying our code following the agile methods, also deployment includes approach to design, develop, test, and operate the infrastructure and software components required for the system applications.
• Responsible for building inbound/outbound interfaces that are partnered with Christus .

Environment: Informatica Power Center SQL, PL/SQL, SSMS/SSAS/SSIS, Windows Server,Tidal scheduling, SQL Server Agent.

Confidential, Pittsburg, PA

Sr. ETL Informatica Developer

Responsibilities:

• Design, develop, implement and maintain of Business Intelligence (BI) solutions to support business needs.
• Collaborated with other IT groups to receive and integrate data using Informatica Power Center and analyze transitioned data using SQL queries.
• Worked with Data Architects and database administrators to design and develop database tables to integrate transitioned data.
• Met with vendors daily and discussed testing plan and number of test iterations required.
• Remapped the data extracts to the new source of transitioned data using PL/SQL and Informatica Power center and generated test files for the vendors.
• Worked in outbound and inbound projects (HEDIS).
• Provider 24*7 On call production support to troubleshoot and resolve issues.
• Work on PL/SQL scripts, views and materialized views.
• Development on TYPE1/TYPE2/TYPE3 date warehouse mappings.
• Implementation of CDC logic.
• Heavy use of tools like TIDAL for scheduling, Move it or transfer/Archival of files, Informatica Powercenter for development, SQL(Oracle) for DB related.

Environment-Informatica Power Center 9.6.1/10.1.0 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), SQL, PL/SQL, Flat Files, Oracle, Windows Server, Tidal scheduling, Moveit.

Confidential, Bloomsburg PA

Sr. ETL Informatica Developer

Responsibilities:

• Extensively worked on Informatica Designer 9.5.1/10.1 on source analyzer, target designer, transformation developer, mapplet designer and mapping designer.
• Loaded the third-party vendor health care eligibility files into internal staging tables using informatica mappings.
• Developed mappings for multiple inbound jobs (into internal ODS tables) and outbound jobs (outside vendors) extracts.
• Developed complex jobs for archival of historical data (Claim tables) from regular server to historical server.
• Worked on tidal scheduling tool, created groups/jobs in build environment and migrated the respective groups to higher environments for automation run of developed jobs through tidal operator.
• Worked on Amysis and Facets claim engine servers.
• Worked on Complex Medimpact type 22 group and member eligibility termed process file. File complexity involves multiple segments with member, group and their attribute level of information. Worked on end to end business requirement and hit the tight timelines.
• Developed Unix scripts for placing of files to eBiz servers, getting the files from SFTP, sending SFTP files etc.
• Identified the bottlenecks and did performance tuning.
• Co-ordinated with developers of Informatica analyst, data quality tools.
• Worked with business users gathered the requirements, created mappings specs coordinating with data analyst’s, developed the process and getting the UAT approvals and deploying it into production, involved the end to end implementation of the project.

Environment: -Informatica Power Center 9.6.1/10.1.0 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), SQL, PL/SQL, Flat Files, Win7, Winscp, Microsoft SQL Server Management Studio 2016, Windows Server, Unix Server, Tidal scheduling .