Data Developer
Resume:
Shilpa
ETL/ Informatica Developer
Contact:614-***-****
Email:**********@*****.***
Summary:
●Experienced as a Data Warehouse consultant spent on projects for different multinational companies with extensive experience in Software Development Life Cycle (SDLC) including System Analysis, Design, Data Modelling, Dimensional Modelling, Requirements Gathering, Implementation and Testing of Enterprise Data Warehousing and OLAP Reporting Applications.
●All-round experience in requirement analysis, database design and Implementation of Data warehouses with strong understanding of Dimensional Modelling, Slowly Changing Dimensions, Fact and Dimensional table, Star & Snowflake Schema, Data staging.
●Coordinated in daily team meetings, technical code review meetings and interacted with business people for better technical solutions and proposed ETL strategy based on Agile Methodologies.
●Good experience of the ETL processes applied to different industries. Data Warehousing experience using Informatica Power Center (Workflow Manager, Workflow Monitor, Repository Manager, Source Analyser, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Data mart, ETL, OLAP, OLTP.
●Experience in Development of Informatica Mappings, corresponding Sessions and Workflows.
●Experienced in designing and developing EDI data flows using data scripts.
●Efficient in Performing data cleansing, scrubbing and validating the data before loading the data into Data warehouse.
●Strong understanding of Data Warehouse concepts and principles (Kimball/Inman), Fact tables, Dimension tables, Normalization/De normalization, Star Schema modelling and Snowflake modelling.
●Extensive knowledge in Teradata SQL assistant, Teradata viewpoint, fast Export, Fast Load, Multi Load, BTEQ scripts and TRUMP and Terada parallel Transporter.
●Analysed the existing Teradata scripts to enhance the performance of the components and updated the scripts by understanding the functionality of the scripts.
●Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
●Extensively worked with XML files as a source and target, used transformations like XML generator and XML parser to transform XML files, and used oracle XML type to store XML files.
●Extracted data from Homogeneous and Heterogeneous sources and developing the mapping needs and to push the data as per ETL Specification document into Target Tables.
●Has good hands-on knowledge in configuring various transformations like Source Qualifier, Expression, Filter, Joiner, Aggregator, Router, Unconnected and Connected Lookups, Update Strategy, Sequence Generator, Stored Procedure.
●Comfortable in implementing the CDC (Change data capture) for the slowly changing dimensions of types SCD-Type1, SCD-Type2, SCD-Type3.Used effective Start-Date, End-Date, Version, flagging to capture the change for the records.
●Created Stored Procedures for Target Preload TRUNCATE of data, Handled PRE-SQL and POST-SQL for targets. Implemented SQL Overrides at Source Qualifier and Lookups whenever needed. Created Reusable objects like Transformations (Expression, Stored Procedure, Filter, and Lookup-Unconnected), Mapplets, and Functions.
●Good in writing simple Unix Shell scripts for Moving Files from one directory to another, archiving the files. Checking for control files existence in a directory or not. Removing carriage returns before processing Flat files.
Technical Skills:
ETL : Informatica 10.0.1/9.5.1/9.1.0/8.6.1/8.5, BO Data Integrator
BI Tools : Business Objects: BO XI-R2\6.5, Crystal Reports
Databases : Oracle 10g/11g/12g, SQL Server 2005, Teradata v12/13/14, DB2
Interfaces : TOAD, SQL*Loader, MS SQL Server Management Studio.
Languages : PL/SQL, C, C++, Java, SQL, HTML, XML.
Concepts : RDBMS, Data Warehousing/ Data marts
Scheduling : Informatica Scheduler, Autosys, ESP, Control-M
PWC (Price Waterhouse Coopers),Tampa, Florida April’19 - Present
ETL(Informatica) Developer
Responsibilities:
●Worked closely with business clients to understand the requirement and created mapping based on that.
● Extensively used ETL to load data using Power Centre from source systems like SAP Tables into staging tables and load the data into the target database Oracle and Analysed the existing systems and made a Feasibility
●Extensively worked with Designer tools like Source Analyser, Target designer, Mapping designer, mapplet designer, Transformation Developer.
●Transformed the data based on business requirement using Informatica Power Center and loaded data into target, by creating sessions followed by workflows.
●Designed ETL processes and develop source-to-target data mappings, integration workflows and load processes.
●Followed and maintained source definitions, transformation rules and targets definitions using Informatica repository Manager. Used transformations like Sorter, Joiner, Lookup, Filter, Aggregator, Rank, etc...
●Troubleshooting the Informatica Mappings and validating the data based on the User Interface.
●Developed and maintained documentation to client standards / provide feedback on standards.
●Experience in using Microsoft Azure tool to maintain and track the tasks and code migration for developers.
Environments:
Informatica Power Center 9.6, Oracle 12g, MS Access, MS SQL Server, Unix, Shell Scripting, Toad for Oracle, WinSCP
Union Bank,Los Angeles, California Oct’18 -March’19
ETL(Informatica) Developer
Responsibilities:
●Worked closely with business analyst and Data Warehouse architect to understand the source data and the need of the Warehouse.
●Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data
●Involved in migration of mappings and sessions from development repository to test and production repository.
●Running the daily jobs for Raw and clean data files and loading it to the ABC tables.
●Created the Autosys jobs and scheduled those as per the requirement.
●Implementing the code in wherescape red and sending the data to the extract files.
●Extensively involved in tuning the mappings, sessions and the Source Qualifier query.
●Designed and created ETL mappings using Informatica mapping designer.
●Worked extensively on performance tuning by making changes to SQL in source qualifier.
●Creation of facts and dimensions according to the business requirements.
●Experienced in identifying and documenting data integration issues, challenges such as duplicate data, non-conformed data, and unclean data.
Environments:
Informatica Power Center 10.0.1, Wherescape 2.1.0, Autosys, Oracle 12g, MS Access, MS SQL Server 2008, Unix, Shell Scripting, Greenplum, DB2, SQL PL/SQL,XML SQL*Plus,
Nationwide Insurance, Columbus, Ohio June ‘17 to Oct’18
Informatica Developer
Responsibilities:
●Coordinated in daily team meetings, technical code review meetings and interacted with business people for better technical solutions and proposed ETL strategy based on Agile Methodologies.
●Extract ETL jobs from sources like JD Edwards SQL server XML, CSV file, Excel file.
●Validated, debugged old Mappings tested Workflows & Sessions and figured out the better technical solutions. Identified the Bottlenecks in old/new Mappings and tuned them for better Performance.
●Created Batch scripts for active batch job scheduling and supporting them.
●Extensively used informatica PowerCenter to extract data from various sources, which included Flat files,SQL server, Oracle, Ma-Access and XML.
●Developed various complex SCD Type1/Type2 Mappings to maintain the data history in different layers. Used Mapping & Sessions Variables/Parameters, Parameters files, Reusable Transformations & Mapplets to maintain the life cycle development. Designed and coded of major change requests as per new requirements.
●Worked on Team Based development to migrate the codes from Dev. to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project.
●Created Pre & Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on data. Transformed and loaded of large sets of structured, semi-structured and unstructured data coming from different sources like CSV, Flat file MS-SQL, Oracle etc.
Environments:
Informatica Power Center 10.0.1 and 9.5.1, Power Exchange, Autosys, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, Unix, Shell Scripting, Perl Scripting, Tidal, Sybase, IBM DB2, SQL PL/SQL,XML SQL*Plus, TOAD, Oracle Applications 11i, Erwin, Mainframe, Sun Solaris, Windows XP, Informatica cloud.
Devon Energy, Oklahoma city, Oklahoma June ‘15 to May ‘17
ETL Developer
Responsibilities:
●Worked closely with business analyst and Data Warehouse architect to understand the source data and the need of the Warehouse.
●Involved in profiling, cleansing, standardization and Match/Merge.
●Involved in creating IDQ detail level design plans.
●Design and development of Informatica Data quality plans.
●Worked on Profiling Report, Expression Rules, Creating and Running Scorecards on claims.
●Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
●Identifying and acquiring new data sources.
●Creating and maintaining consistent reference data and master data definitions.
●Developed reusable mapplet called as plans in IDQ and imported into power centre.
●Extensively worked with Designer tools like Source Analyser, Target designer, Mapping designer, mapplet designer, Transformation Developer.
●Created source and Target Definitions, Reusable transformations, mapplets and work lets.
●Created Mappings and extensively used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator and Sequence Generator, Web services Consumer.
●Developed Source to Staging and Staging to Dimension mappings.
●Developed Source to Staging and Staging to Fact mappings
●Used Workflow Manager to create sessions, work lets workflows.
●Extensively involved in tuning the mappings, sessions and the Source Qualifier query.
●Identified performance issues in existing sources, targets and mappings by analysing the data flow, evaluating transformations and tuned accordingly for better performance.
●Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data
●Involved in migration of mappings and sessions from development repository to test and production repository.
Environments:
Informatica Power center 9.1, Informatica Data Quality 9.6.1 Oracle 11g, PL/SQL, Dynamic SQL, UNIX Shell Scripting, SharePoint, HIPAA, IIR, Web Services (WSDL), Accenture,Austin,Texas Nov ‘14 to June‘15
Informatica Developer
Responsibilities:
●Extensively involved in tuning the mappings, sessions and the Source Qualifier query.
●Designed and created ETL mappings using Informatica mapping designer.
●Worked extensively on performance tuning by making changes to SQL in source qualifier.
●Fine-Tuned existing mappings for better performance. Documented mappings and transformations.
●Creation of facts and dimensions according to the business requirements.
●Monitoring and improving performance of daily jobs on oracle database.
●Identifying integrity constraints for tables.
●Experienced in identifying and documenting data integration issues, challenges such as duplicate data, non-conformed data, and unclean data.
●Involved in production support and done knowledge transfer to team members.
●Actively involved in Daily check in meetings to discuss on the production issues and resolved.
●Worked on Automation process of Sessions, Workflows, scheduled the Workflows, created Work lets and configured them according to business logics & requirements to load data from different Sources to Targets.
●Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
●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 and Maintenance of the Data Marts.
Environments:
Informatica Power Center 9.1, Oracle 11g, MS SQL Server 7.0 2000, Flat files, SQL, SQL*Loader, Erwin, Toad, Windows 2000, Unix Shell Scripting.
Education: MS in IT from Hood College(2014-2015),Frederick-MD
Contact this candidate