We provide IT Staff Augmentation Services!

Sr.informatica Developer Resume

SUMMARY

  • 7 years of experience in Information Technology including Data Warehouse development using ETL Informatica Power Center across various Domains.
  • Extensive experience in developing ETL mappings, scripts and data integration using Informatica Power Center 10.2HF 1/10.2/9.6.1 /9.5.1/9.1.1/8.6.1.
  • Extensive Experienced in Develop, maintain, and support application, business glossary, business intelligence, data integration, data modeling, and database management resources in Metadata Manager
  • Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
  • Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.
  • Experienced in data profiling and data analysis.
  • Attended data model review sessions with Data Modeler.
  • Expertise in understanding Business Model Identifying Dimensions and Facts.
  • Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) for better usability.
  • Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Expertise in implementing Change Data Capture (CDC) & Slowly Changing Dimensions - SCD Type 1 & Type 2.
  • Used B2B data exchange HIPAA accelerator received HIPAA x12 messages and converted EDI 837-Q3 health care institutional claim, EDI 837-Q2 health care dental claim and EDI-837-Q1 health care professional claim and EDI 270-A1 eligibility and coverage enquiry transactions into XML format.
  • Experience in integration of various data sources like Oracle, DB2, Sybase, My Sql, SQL Server and non-relational sources like flat files and XML into staging area.
  • Experience with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, TPT and using SQL Assistant.
  • Experience in doing Tuning of Teradata Queries using Explain plan.
  • Experience with Teradata Indexes and usage.
  • Experience in converting SSIS packages to Informatica.
  • Extensively worked with Sql and Pl/Sql.
  • Experience in doing performance Tuning of Data Base queries.
  • Experience in UNIX environment, file transfers and job scheduling.
  • Worked on Informatica Performance Tuning identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
  • Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate.
  • Experienced in ETL Informatica & Database Upgrade Testing.
  • Experience working in Agile methodology and ability to manage change effectively.
  • Experience in driving the Projects Independently with minimal guidance.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2HF 1/10.2/9.6.1 /9.5.1/9.1.1/8.6.1/8.1.1

Metadata Manager 10.2HF 1/10.2/9.6.1 : Informatica Analyst 10.2HF 1/10.2/9.6.1

Data Modeling: Dimensional Modeling, ER Modeling, Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow-Flake, Fact Tables, Dimension Tables, Normalization and De Normalization.

Databases: Teradata 16.x/15.x/14/12, Oracle 12c/11g/10g/9i, MS SQL Server 2015/2008, DB2, Sybase, My Sql, Hadoop

Others: Toad, SQL Navigator, FACETS, Shell Scripting, Sql Assistant, Sql, Java, Hive QL, Perl

Environment: Windows, Linux, Unix

Job Scheduling: Autosys, Control M, Cron Job and Maestro

PROFESSIONAL EXPERIENCE

Confidential

Sr.Informatica Developer

Responsibilities:

  • Experience in preparing the High Level Design Document and Low Level design documents for mapping.
  • Strong skills in using Informatica Power Center client tools, Metadata Manager, Informatica Analyst, Administration and Maintenance of Adding users, assigning rights to users moving objects from folder to folder using Repository Manager.
  • Developed the complex mappings using power center designer using advanced transformations SQL transformation, and update strategy transformations.
  • Developed change data capture mappings for capturing the history data.
  • Extensively used mapping variables and workflow variables to pass the mapping variables from one session to another session in a workflow.
  • Extensively Worked on Data warehousing with Data Marts, ODS, Data Cleansing, ETL tool Informatica.
  • Worked with heterogeneous data sources like Oracle, XML, Flat Files, VSAM, AS400, Teradata and Relational Databases.
  • Proficient in using workflow tasks like Session, Control, Event wait, command tasks, Decision tasks, Email tasks, pre-sessions, post-sessions by using pre-SQL and Post-SQL.
  • Extensively worked on Informatica Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Workflow Manager.
  • Experienced with dealing with 837 EDI transactions.
  • Converted EDI files from X12 to XML files.
  • Experienced with EDI transactions (Informatica B2B or Advanced Transformations).
  • Upgraded EDI mapping from data stage environment to Informatica.
  • Implemented Slowly Changing Dimensions Type-1, Type-2 approach for loading the target tables.
  • Extensively used Teradata parallel transporter for load operator to load to staging tables and update operator to load to EDW tables.
  • Experienced in Tableau reports analyzing and testing.
  • Used IDQ and Analyst tool to do basic profiling join analysis the source objects to better understand the Keys and duplicates for better modeling purposes & helped analysts to write improved mapping documents & used Address Validator (Doctor) to fix errors in addresses & output envelope to a ready format.
  • Involved in ETL Architecture and Data Modelling using ERWIN.
  • Implemented Full Informatica Push down Optimization (PDO) (source & target) for better load performance.
  • Extensively worked on Teradata tools and utilities (BTEQ, Fast load, Multi Load, Fast Export, and TPUMP).
  • Strong knowledge in creating SET and Multiset tables, Macros, stored procedure, Index, Views and Data marts.
  • Created complex SQL queries and excellent record in SQL query performance tuning.
  • Have strong experience working in Windows and UNIX environment and developing Batch and PERL Scripts.
  • Proficient in Developing, maintaining, and supporting linkage between Informatica Business Glossary and Metadata Manager Assets.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Validate completeness of data lineage between the point of data element creation (system of record) and the point where it is consumed by business users (trusted data source).
  • Monitored periodic loads of Metadata Manager Resources to confirm successful load, indexing, and linking.
  • Performed business requirements analysis for business rules and documents associated with population and extraction of metadata resources.
  • Extensively experienced in developing Business Glossary, Scorecards, Profiles and business rules.
  • Had experience in creating Data lineages and Security model in Metadata Manager.
  • Providing ongoing support for metadata implementation, testing and integration
  • Created estimates for all Metadata Manager Activities, including analysis, development, and testing, and communicate to project team.
  • Devised improvements to current procedures and develop methods for increasing efficiency, accuracy, and performance of metadata solutions.

Environment: Informatica Power Center, Informatica Metadata Manager, Informatica Analyst, Informatica Data Quality 10.2HF 1/10.2/9.6.1 , Teradata 16.x/15.x, Oracle 12c, UNIX, WinScp, Putty.

Confidential

Sr.ETL Informatica / Teradata Developer

Responsibilities:

  • Worked with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model.
  • Extracted data from different source systems - Oracle, DB2, My Sql, Flat Files and XML Files.
  • Developed ETL programs using Informatica Power center 10.2/9.6.1 to implement the business requirements.
  • Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.
  • Communicated with business customers to discuss the issues and requirements.
  • Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression, Update Strategy, Transaction Control and Sequence Generator.
  • Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables.
  • Worked with Huge data sets to load Fact Tables.
  • Implemented Change Data Capture (CDC) for handling delta loads.
  • Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment.
  • Experienced in analyzing and parsing 837P, 837I, 837D files.
  • Implementation and knowledge of HIPAA code sets ICD9 and ICD10 coding.
  • Implementation and knowledge of HIPAA standards, EDI Transactions 820.834,837.
  • Experienced in doing performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating the with tuning methods.
  • Used Informatica file watch events to pole the FTP sites for the external files.
  • Involved in Enhancing existing Production Informatica objects for change or additional requirements and pushing it back to production after successful QA testing.
  • Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load into Teradata Warehouse.
  • Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata sql.
  • Involved in Teradata upgrade process from TD 14/TD 15.
  • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Good knowledge about FACETS tool and Healthcare domain, Worked on the various modules like Subscriber/Member, Groups, Enrollment, Claims, Billing, Accounting, Provider, MTM and Utilization Management.
  • Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
  • Used debugger in identifying bugs in existing mappings by analyzing dataflow, evaluating transformations.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
  • Used Maestro & Cron Job to schedule jobs.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Worked with ETL Admin team for code migration activities and deployments.
  • Worked with QA team for better understanding of code development.
  • Implemented & followed organization level Informatica best Standards & Procedures.
  • Involved in Solving Trouble tickets raised by Business users as part of application support team.

Environment: Informatica Power Center 10.2/9.6.1, Oracle 12c/11g, DB2, Teradata 15/14, Flat Files, XML, TOAD, Sql Assistant, Maestro, Cron Job, UNIX, Perl, Facets 4.7, Windows.

Hire Now