SUMMARY:

• 8+ years of IT experience in the designing and implementing of Data Warehousing and Data Integration including Requirement Gathering, Data Analysis, Design, Development, Testing and Production
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Worked extensively on ETL process using Informatica PowerCenter 9.x
• Extensively used ETL processes to load data from various source systems such as Oracle, Teradata and Flat Files, XML files into target system by applying business logic on transformation mapping for inserting and updating records when loaded.
• Experience in RDBMS databases systems like Oracle 10g/9i, Oracle 12c, SQL Server and My SQL
• Experience with dimensional modeling using star schema and snowflake models
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Troubleshoot production data issues and failures, manage critical incidents and bridge calls, automate repetitive tasks, problem analysis, maintain knowledge base and documentation, implement process improvement methods.
• Proficient in using testing tools such as HP QC/ALM, RALLY, QTP/UFT, Load runner, SOAPUI and JIRA.
• Hands on Experience of testing both SOAP and REST based Web Services .
• Knowledge of Informatica administration in windows and Linux environment.
• Involved in the development of Informatica mappings and Mapplets and also tuned them for optimum performance.
• Experience in Waterfall and Agile Methodology.
• Have good communication, analytical, interpersonal and presentation skills.

SKILL:

Data Warehousing: Informatica Power Center 10.1, 9.x, T ransformation Developer, Mapplets Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Warehouse Designer, and Informatica Server), IDQ

Database: Oracle 12C/11gMS SQL Server 2016/2014/2012/2008, DB2

Languages: SQL, PL/SQL, C, XML, UNIX Shell Scripting

Scheduling Tools: TWS (Tivoli Workload Scheduler), Control - M

Applications: MS Office, MS Project, Toad 10.6/9.2, Oracle SQL Developer

Processes: Agile Process, REF (Release Entry Framework)

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

ETL/ Informatica Developer

Responsibilities:

• Worked with the Data Modeler, Data Architect, and Database Developers to implement data model designs in SQL and Azure PaaS SQL , handling reverse engineering of the existing data flow, transformation logic from SSIS, SSAS and Excel.
• Designing, developing and maintaining new data ingestion processes.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse
• Used debugger to debug the mapping and correct them.
• Part of team for debugging and performance tuning of targets, sources, mappings and sessions.
• Code walks through with team members.
• Worked with Business Analysts and end users to correlate Business Logic and Specifications for ETL.
• Actively participated in gathering the requirement documents, analyzing, designing and development.
• Created mapping documents to outline data flow from sources to targets.
• Extensively worked with Informatica Power Center.
• Tuned SQL queries for better performance.
• Desire to learn new skills, technologies, and adapt to new information demands.

Environment: Informatica PowerCenter10.01, Oracle SQL Developer,SQL SERVER,,VSTS,SharePoint, Jasper soft.

Confidential, Charlotte, NC

ETL/ Informatica Developer

Responsibilities:

• Involved in creating technical design documents, source to target mapping documents and test case documents to reflect ETL process.
• Gathered requirements and created functional and technical design documents study, business rules, data mapping and workflows.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Coordinate weekly QA and production release activities.
• Imported the mappings developed in data quality ( IDQ) to Informatica designer.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica.
• Extensive experience on testing SOA, Web Services and integration with components using SOAP UI.
• Used heterogeneous files from Oracle, Flat files as source and imported stored procedures from oracle for transformations.
• Used Dimensional Modelling Techniques to create Dimensions, Cubes and Fact tables.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make Event based scheduling.
• Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 10.1, Informatica Power Exchange, Informatica Data Quality, Oracle 12c, Flat files, Toad, Business Objects, Gnosis, Putty, Unix, SOAP REST webservices, HP QC/ALM

Confidential, Los Angeles, CA

ETL/ Informatica Developer

Responsibilities:

• Extensively used Informatica Power center, Power Exchange for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Created JIRA projects, templates, workflows, screens, fields and other administrative activities
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router in Mappings.
• Designed basic UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Scheduled Sessions and Batches on the Informatica Server using Informatica workflow Manager.
• Migrate Informatica objects and Database objects to Integration Environment and schedule using the Control-M
• Monitoring the ETL jobs and fixing the Bugs
• Involved in doing Unit Testing, Integration Testing and System Testing.
• Identified and created various classes and objects for report development.

Environment: Informatica Power Center 9.6, Oracle 10g/9i, XML, Flat files, SQL, PL/SQL, Control-M, Windows, UNIX, Business Intelligence, JIRA

Confidential

ETL / Informatica Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplets Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup andUpdate Transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplets designer in Informatica Power Center 6.1.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica PowerCenter 9.x, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.