Etl/informatica Developer Resume
Lafayette, LA
SUMMARY
- 5 years of experience in Information Technology wif a strong background in Database development and Data warehousing (OLAP) and ETL process using Informatica Power Center 9.x/8.x, Power Exchange, Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
- Experience in integration of various data sources wif Multiple Relational Databases like DB2, Oracle, SQL Server and Worked on integrating data from XML files, flat files like fixed width and delimited.
- Involved in teh data analysis for source and target systems.
- Experience in Data Virtualization using CISCO(Composite) Information Server on development tasks.
- Experience in Data mining, Data Masking, Test Data Management.
- Implemented Performance tuning techniques at application, database and system levels.
- Experience in working wif Teradata as source and target for Informatica power center.
- Experience in Autosys and UNIX shell programming to execute Informatica jobs.
- Understanding of Relational (ROLAP), Multidimensional (MOLAP) modeling, data warehousing concepts, star and snowflake schema, database design methodologies and Meta data management.
- Experience wif preparing functional Specifications, Low Level and High Level Design specification and Source to target mapping documents for teh ETL programs/business processes.
- Experience in working wif Oracle Stored Programs, Packages, Cursors, Triggers, Database Link, Snapshot, roles, Privileges, Tables, Constraints, Views, Indexes, Sequence, and Synonyms Dynamic SQL and SQL*Loader in distributed environment.
- Used RDMA to interconnect for high throughput, low latency and low CPU utilization.
- Experience in SQL tuning using Hints, Materialized Views.
- Experience in understanding Fact Tables, Dimension Tables, Summary Tables.
- Exposure to development, testing, debugging, implementation, user training & production support.
TECHNICAL SKILLS
ETL: Informatica Power Center 10.1/9.6.1/9.5/9.1/8.6 , Informatica Cloud, Informatica Power Exchange 5.1/4.7/1.7, Power Analyzer 3.5, Informatica Power Connect and Master Data Management (MDM), Data Quality Tool (IDQ), Informatica Data Services(IDS) 9.6.1, DataStage
Reporting Tools: Business Objects XI 3.1/r2,r1/6.x/5.x, Web Intelligence, Crystal Reports8.X/10.X
Database Modeling: Erwin 4.0, Rational rose
Databases: Oracle11g/10g/9i/8i/7.x, DB2, Teradata v13/v12/v2r5, SQL Server 2012/2008/2005
Languages: SQL, COBOL, PL/SQL, JAVA, C
DB Tools: SQL* plus, SQL* Loader, SQL*Forms, TOAD
Web Tools: HTML, XML, JavaScript, Servlets, EJB
OS: MS - WINDOWS NT/2000/2003, UNIX, Linux
PROFESSIONAL EXPERIENCE
Confidential, Lafayette, LA
ETL/Informatica developer
Responsibilities:
- Analyze Business requirements and work closely wif various Confidential IT application teams and Confidential business teams to develop ETL Process.
- Participate in all phases of ETL/Informatica development including requirements analysis, Design, coding, testing and documentation.
- Involved in Data Migration procedure and mapped data from legacy systems to new existing systems for providing a design for Data Extraction and Data Loading.
- Involved in development of TIBCO Spotfire dashboards and reports wif data from large datasets wif teh halp of data virtualization making use of Cisco Information Sever (CIS) tool.
- Worked on Informatica IDQ Tool for Data Profiling.
- Used teh ETL Data Stage director to schedule and running teh jobs, testing and debugging its components and monitoring performance statistics.
- Worked on Source as DB2 and Target as Mainframe files.
- Worked on Database connections, SQL joins, Cardinalities, Loops, Aliases, Views, Aggregate conditions, Parsing of objects and Hierarchies.
- Engage in Data modeling, Data migration and design decisions as necessary.
- Performed reverse-engineering from Informatica code, metadata to understand teh existing process, data and relationships.
- Develop, Unit test and optimize ETL mappings and workflows per provided functional specification for Data extraction, Transformation and loading.
- Assist in user acceptance testing and any other functional testing as needed by teh project. .
- Configured development and QA environments to meet Data Privacy, Data Masking and Data Sub-setting requirements using IBM Infosphere Optim Test Data Management (TDM) services.
- Assist in performance tuning of ETL jobs to decrease long running job duration.
- Developed complex mappings quickly in Informatica wif rapid change of requirements during testing.
- Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions)..
Environment: Informatica Power Center 9.6, Oracle 11g, MS SQL Server 2016, SQL, Informatica Power exchange 9.6.1, Informatica IDQ, Teradata SQL Assistant, Putty.
Confidential, West Chester, PA
Informatica Developer
Responsibilities:
- Collaborated wif Business analysts for requirements gathering, business analysis and designing of teh Enterprise Data warehouse.
- Wrote custom support modules for upgrade implementation using SQL and UNIX Shell Scripts.
- Involved in Cisco Information Server (CIS) initial setup, installation and admin related tasks to implement Logical layer.
- Cleanse and scrub teh data in uniform data type and format applyingMaster Data ManagementInformatica andIDQtools and load to STAGE and HUB tables and tan to teh EDW and finally to dimension and rollup/aggregate teh data by teh business grains into teh Fact tables.
- Worked on Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Reconciliation, Data Integration and Metadata Management services and Configuration Management.
- Worked wif different transformation in Informatica power center develop mappings.
- Experience working wif sales force as source and loading sales force data to ODS tables.
- Worked on Performance Tuning of Informatica jobs and trouble shot teh bottleneck.
- Executed, scheduled workflows using Informatica and Taking care of code movement to higher environments.
- Worked wif Informatica Tasks like Event Wait, Command tasks to schedule teh Informatica jobs.
- Experience working wif Sales force as source to Informatica to load ODS tables.
- Analyzed teh data from Teradata tables used as Source.
- Extensively usedTeradata Utilities likeFast-Load, MultiLoad.
- Responsible for developed Informatica code in all environments DEV, UAT and PROD.
Environment: Informatica Power Center 9.1, Oracle 11g, MS SQL Server 2014, SQL, PL/SQL, T-SQL, SQL*Plus, Oracle SQL developer, Unix.
Confidential, Westfield Center, Ohio
Informatica Developer
Responsibilities:
- Collaborated wif Business analysts for requirements gathering, business analysis and designing of teh Enterprise Data warehouse.
- Involved in requirement analysis, ETL design and development for extracting data from teh heterogeneous source systems like MS SQL Server, Oracle, flat files and loading into Staging and Star Schema.
- Worked on EDW to build Fact and Dimension tables.
- Worked on debugging code to find bottle necks for performance tuning.
- Worked mainly on Performance tuning to optimize Informatica job duration.
- Worked on CDC to capture records for update, delete and insert into target tables.
- Involved in unit testing, user acceptance testing to check whether data is loading into target which was extracted from different source systems.
- Worked on Test data management TDM environment set up.
- Test Data Management (Data Generation, Data Sub-Setting Data Masking,Data Archiving and Data Refresh)
- Worked wif UNIX shell scripts extensively for job execution and automation.
- Scheduled workflows using DAC (Data Warehouse Administration console).
- Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate teh data.
- Worked on Autosys scheduling tool to schedule daily and monthly jobs.
- Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
- Involved in Unit testing, User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
Environment: Informatica Power Center 9.5.1, Oracle 11g, MS SQL Server 2014, SQL, PL/SQL, T-SQL, SQL*Plus, IDQ, Oracle SQL developer.
Confidential, Canton, OH
Informatica Developer
Responsibilities:
- Collaborated wif Business analysts for requirements gathering, business analysis and designing of teh Enterprise Data warehouse.
- Involved in requirement analysis, ETL design and development for extracting data from teh heterogeneous source systems like MS SQL Server, Oracle, flat files and loading into Staging and Star Schema.
- Worked wif Informatica IDQ tool to create rules and validate teh data.
- Extensively used Informatica IDQ tool to cleanse teh data and Creating score cards on existing rules.
- Understanding of metadata generated by data warehouses and using specific projects.
- Worked on Informatica Metadata to halp ETL design specifications.
- Validated data in staging tables coming from disparate sources through Informatica mapping.
- Worked on PL SQL scripts to validate source and target data once loading completed.
- Created PL SQL Scripts to test teh data in staging tables and final tables.
- Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
- Involved in unit testing, user acceptance testing to check whether data is loading into target which was extracted from different source systems.
- Worked in EDW team to build Fact and Dimensional tables.
- Worked on SQL queries in source side to optimize teh performance of query like creating hints, indexes.
- Experience writing pmcmd command and UNIX wrapper scripts to automate Informatica.
- Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate teh data.
- Tuning teh Mappings for Optimum Performance, Dependencies and Batch Design.
- Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
- Involved in Unit testing, User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
Environment: Informatica Power Center 9.1, Oracle 11g, Informatica Master Data Management, MS SQL Server 2012, SQL, PL/SQL, T-SQL, SQL*Plus, IDQ, XML, Autosys, Oracle SQL developer.
Confidential
Informatica Developer
Responsibilities:
- Involved in requirement analysis, ETL design and development for extracting data from teh heterogeneous source systems like DB2, UDB, MS SQL Server, Oracle, flat files, XML files and loading into Staging and Teradata Data Ware House.
- Involved in massive data cleansing prior to data staging.
- Maintained warehouse metadata, naming standards and warehouse standards for future application development.
- Used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
- Configured workflows wif EmailTask, which would send mail wif session, log for Failure of a sessions and for Target Failed Rows.
- Used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
- Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
- Working wif Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export.
- Used Teradata system Priority Schedule in controlling teh load of teh system.
- Teradata PMON is used to monitor teh system performance when it is in load.
- Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
- Build tables, views, UPI, NUPI, USI and NUSI.
- Designed and developed teh logic for handling slowly changing dimension table’s load by flagging teh record using update strategy for populating teh desired.
- Involved in Unit testing, User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
Environment: Informatica Power Center 8.6.1, Oracle 10g, Teradata V12.0R2, BTEQ, Fast Load, Multiload, Fast Export, MS SQL Server 2008, SQL, PL/SQL, T-SQL, SQL*Plus, TOAD, Erwin, Unix.