SUMMARY:

• 7+ years of experience in various phases of projects in Developing, Enhancing and Maintaining applications in industry verticals like Retail, Insurance, Banking, pharmaceutical, Insurance and Health Care domain using Informatica Power Center.
• 7+ years of experience in using Informatica Power Center (10X/9X/8X).
• One year of experience in IICS Intelligent Informatica Cloud Services (IICS).
• Migration of Informatica Jobs from Dev, QA to Prod environments using Repository Manager.
• Involved in INFA Admin repository upgrade Activities and INFA Admin Support Activities.
• Proficiency in developing SQL with various relational databases like Netezza, Oracle, Teradata, Toad and SQL Server.
• Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Experience in all the phases of Data warehouse life cycle involving requirements gathering/analysis, design, development, validation & testing of Data warehouses using ETL, Data Modelling & Reporting tools .
• Good working knowledge in querying Salesforce.com database using SOQL & SOSL queries using Force.com Explorer & Workbench.
• Used Informatica Power Connect for SAP to pull data from SAP R/3 .
• Exposure and experience in different methodologies like Agile and Waterfall.
• Used to work with in Sprints and deliver the efficient code.
• Performed Informatica upgrade from Versions 8X to 9.X.
• Creation and maintenance of Informatica users and privileges
• Experience in Dimensional Data Modelling Star Schema, Snow - Flake Schema, Fact and Dimensional Tables.
• Expert on Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Expedite in writing UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Developed UNIX scripts for dynamic generation of Files & for FTP/SFTP transmission.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Proficient in Test execution and Bug tracking.
• Hands on experience to conduct scrum meetings and sprint planning by using tools like JIRA, Confluence & HP-ALM to track the progress of projects.
• Have Good experience using scheduler tools like Tidal , Control-M and Autosys.
• Ability to meet deadlines and handle multiple tasks , work under both Agile and Waterfall methodologies.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Excellent leadership skills to work in team, analytical skills, logical reasoning, interpersonal skills and attitude to lead. Excellent communications skills, fast & enthusiastic learner, excellent work ethics and a good team player.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10X/9X/8XAgnityAMP, Informatica Intelligent Cloud Service (IICS)

Hive HUE 2.6.1: 2

Database Tools: Toad, Oracle 11g/10g/9i, Microsoft SQL-Server 2000/2005/2008 , IBM-Netezza (Aginity Work bench), DB2, Teradata, SQL * Loader, SQL * Plus.

Control: M, Autosys and Tidal.

Internet Technologies and Microsoft tools: HTML, XML, MS office tools (Outlook, Word, Excel, Visio, Power point, Publisher)

Version Control Tools: TFS, VSTS, XL Deploy and Git Hub.

Programming Languages: PL/SQL, Unix, Shell Scripting.

File Transfer Tools: FTP, Putty and FileZilla

OS and Other Tools: Windows All versions, Skype, JIRA, Confluence.

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

ETL/Informatica Developer

Responsibilities:

• Worked on couple of Projects rMail ( Regulatory Mailing) & Informatica Upgrade project from versions 9.6 to 10.2.
• Interacted with business users for requirement analysis of new development applications and to define business and functional specifications.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Developed mappings using Informatica Power C enter to Extract, Transform and load data & performed Type1 and Type2 mappings.
• Development efforts includes Moving data from DST source system ( Power Select ) to rMail tables in Oracle database.
• Involved in writing shell scripts for file transfers & file attachments and several other database scripts to be executed from UNIX.
• Developed, executed, documented Unit test plans, Integration test plans and validating the results with Business Analyst.
• Used Bit Bucket to maintain the built code and GIT HUB to clone the code to local.
• Performed migration of ETL Code from Development repository to integration testing repository and also responsible for preparing & releasing ETL builds using XLDeploy tool.
• Involved in System Integration Testing, User Acceptance Testing and implementation of code to production.
• Analyzed and created the Assessment reports for Informatica Upgrade project from v9.6 to 10.2.
• Worked with offshore team and Admin team while performing upgrade project and provided extensive support for the issues caused while deploying.
• Ensuring data availability for Business Operational Reporting purpose.
• Ensure proper technical documentation and manuals are in place for all supported applications.

Environment: Informatica Power Center 10.1.1/9.6.1 ), Toad, Oracle SQL Developer, SQL Server Management Studio (SSMS), JIRA, Service Now, GIT HUB, XLDeploy.

Confidential, Tampa, FL

ETL/Informatica Developer

Responsibilities:

• Design and develop quality integration workflows between multiple applications utilizing Informatica tools.
• Analyzed the business requirements and functional specifications.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created mappings, mapping configuration tasks and task flows with Intelligent Informatica Cloud (IICS) and Infomatica Power Center (10.1.1 & 9.6.1)
• Provide production support and solve complex integrations issues.
• Worked in Production Support Environment as well as QA /TEST environments using Quality Center tool for projects, work orders, maintenance requests, bug fixes, enhancements, data changes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Used TFS, VSTS and GIT for version control.
• Work closely with the teams to ensure architectural integrity related to integrations activities.
• Collaborate with business stakeholders for UAT and Quality Assurance for unit/technical testing.
• Provide leadership and technical guidance within the integrations and specifically Informatica landscape.
• Work alongside team members to architect, design and develop quality deliverables.
• Built mappings using Informatica Data Quality and export them as Mapplet to Informatica Power Center to read JSON format files.
• Created various workflows to read .JSON files and loaded into staging tables and then to respective Dimension and Fact tables.
• Created QA and PROD change requests using Service Now too to move the code to QA and PROD respectively.
• Drive results and leverage past experiences to improve the environment and related processes.
• Foster a spirit of teamwork, coach and mentor junior staff.
• Communicate regularly with other managers, the director, line of business leads and other designated contacts within the organization.
• Report on the status of development, quality, operations, and system performance to management.
• Troubleshooting, diagnostics & performance tuning in database cost-based optimizer mode.
• Enhanced the performance of the procedures by creating suitable global and local indexes.

Environment: Informatica Power Center 10.1.1/9.6.1 , Intelligent Informatica Cloud Services (IICS), Toad, Oracle SQL Developer, SQL Server Management Studio (SSMS), JIRA, Service Now, Visual Studio Team Services (VSTS), GIT HUB.

Confidential, St. Petersburg, FL

ETL/Informatica Developer

Responsibilities:

• We use Informatica 9.6.1 to load the data from Legacy tables to Netezza tables.
• All the tasks had been assigned in the form of tickets and used JIRA to track them.
• Our primary source is vault which need to be pulled from HIVE and load into our landing area.
• Delivered all the assigned tasks on time, Work had been divided into sprints which is for two weeks.
• Attended all the business requirement meeting along with my lead and played a crucial role in building the requirements.
• Worked intensively with our team and build easily accessible code without missing the standards of the client.
• Prepared 301 business documents which consist of all the data flow form source to target.
• Built Data Integration Components using Informatica power center following locally DI Framework and recipes (i.e ETL Cookbook) like Netezza, Oracle, sql server on Unix/Linux and Windows operating systems.
• Extracted data from our cloud sources (Hive HUE). HDFS system would dump the files into our cloud known as kafka que which is called as Hive Prod HUE.
• Used Hue version- 2.6.1-2 Web interface to query the data.
• Used Aginitiy AMP to generate Natural keys by the combination of multiple foreign keys.
• Wrote complex SQL overrides to join heterogenous databases.
• Worked on Writing and tuning complex SQL queries and shell scripts.
• Was involved in ETL production support once in every 3 weeks and used to work on issues which had been assigned.
• Perform Unit testing for the code built.
• Closely worked with Quality Analyst to make sure the code meets the required standards and the data is valid.
• Used Autosys to schedule the jobs by creating JIL scripts.
• Actively participated in code migration with DBA and admins.
• Maintain all documents current and available in the SharePoint.

Environment: Informatica 9.6.1, HUE-2.6.1-2, Aginity AMP, Hive, Oracle, Netezza, Autosys, JIRA

Confidential, Phoenix, AZ

ETL/Informatica Developer

Responsibilities:

• Informatica 9.5 been used to load the data from Oracle to Netezza tables.
• Used Jira and confluence as project tacking tool, where we used to have all the tasks built and updated.
• Confluence has used to upload all the documents and decision tasks in confluence.
• Played a main role in creating all the templates to create different status pages add our tasks and track them in Jira.
• As this project falls under Waterfall methodology, still we used to have daily scrum meetings and I took lead to conduct this daily standup meeting.
• As this project, has very small dead line and has a high priority because the contract is going to be end by Dec-2016 with E-bay, worked hard as a team by not letting the work goes into risk.
• Prepared all the designing documents consist of Data flow from Source to Target by mapping all the columns, which are required for reporting purpose.
• Handled the complex mappings by modifying some of the core tables which consist of Confidential customer data and also the sales tables that are involved in Batch load.
• Created different (Detailed and High level) Data Model diagrams to explain the flow of the data by using Data Modular tool called ERwin.
• Extensively worked understanding the Business requirements and designed the logic to populate the data as expected.
• Created DDL and DML scripts that have structure of new tables, and modifications of existing tables.
• Built Mappings, work lets and workflows to load the data into staging area, and then into DW tables.
• Used Push Down Optimization to increase the Performance.
• Created Tidal jobs for automation of work Flows.
• Took Responsibility of creating the implementation plan document and worked closely with the admin’s during go live.
• Provided One-month warranty support, which is a regular process in Confidential .

Environment: Informatica 9.1/9.5, SQL Server, Oracle, Netezza, Tidal and JIRA.

Confidential, Warren, NJ

ETL/Informatica Developer

Responsibilities:

• ETL / Data Warehouse experience, preferably with SQL Server/TSQL.
• Excellent knowledge on Informatica Power Center development.
• Created various shell scripts using UNIX.
• Worked on Kimball Methodology, Star Schemas and slowly changing dimensions.
• Worked in a multi-tasking team environment supporting multiple in-flight development projects at the same time.
• Proficient in SDLC methodologies.
• Extracted data high volume of data sets from SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Warehouse.
• Involved in querying Salesforce tables using SOQL queries using Force.com Explorer.
• Have good knowledge SOQL and Sales force governor limits.
• Worked on SQL Server including DDL, TSQL, Stored Procedures, etc. in large-scale relational databases.
• Excellent project management abilities, worked within a large project plan and able to manage own tasks and time.
• Worked on SQL server, Oracle, Sybase databases.
• Used UNIX scripts for scheduling and executing Informatica workflows.
• Worked on scheduler tools like Autosys and Control-M.
• Designed Work Flows that uses multiple sessions and command line objects (which are used to run the UNIX scripts).
• Created UNIX scripts for FTP and SFTP files to different servers.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Designed the ETL specification documents to gather existing workflows information from different ETL teams and shared with Integration and production maintenance team.
• Designed the ETL runs performance tracking sheet in different phases of the project and shared with Production team.
• Interacted with developers and product owners regularly.
• Involved in Functional, Positive and Negative testing of the product.
• Documented and reported defects within established process and tracking systems using ALM.
• Prepared the validation report queries, executed after every ETL runs, and shared the resultant values with Business users in different phases of the project.

Environment: Informatica 9.6.1, SQL Server 2008, Oracle, Teradata, Salesforce, Autosys, Shell Scripting, FTP/SFTP.

Confidential, Bentonville, AR

ETL/Informatica Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Created ETL mappings and mapplets to extract data fromERPs like SAP, ENTERPRISE 1 (Oracle) and load into EDW (Oracle 10g).
• Fixing all the workflows failure in unit testing and system testing.
• Performed Informatica upgrade from V9.1 to 9.5.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Documented the LDAP configuration process and worked closely with Informatica Technical support on some of the issues.
• Identified Multiple Dimensions and Fact tables. Used advance data modeling concepts of Degenerated dimension, sub-dimension, Fact less fact table, Aggregate fact tables in Multidimensional model.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Scheduling all the ETL workflows for the parallel run comparison.
• Scheduled batch jobs using Control-M to run the workflows.
• Involved in preparing the migration list inventory.
• Involved in requirement gathering for redesign candidates.
• Used FTP services to retrieve Flat Files from the external sources and RDBMS sources Teradata and Oracle.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Worked along with the Informatica professional to resolved Informatica upgrade issue.
• Worked with BA in the QA phase of testing.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, PL/SQL, SAP R/3, Control-M, SQL, Teradata, SQL* LOADER, TOAD, Shell Scripting, UNIX, FTP/SFTP.

Confidential, Woodlands, CA

ETL / Informatica Developer

Responsibilities:

• Involved in gathering requirements from end users and involved in modifying data according to the requirement.
• Worked with the end users to identify, create, and deliver reports according to requirements.
• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Created ETL Mappings, Sessions and Workflows using various transformations like Update Transformation, Lookups, Filters, Routers and XML etc.
• Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Actively involved in creating Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception handling using TOAD, SQL*PLUS and PL/SQL.
• Created Fast Load, Multi Load, and T Pump and BTEQ scripts to load data into Teradata.
• Created Data models for data warehouse development.
• Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.
• Worked with UNIX scripts for automation of ETL Jobs using Control-M Scheduler and Involved in migration/conversion of ETL processes from development to production environment.
• Working experience using Push Down Optimization.
• Did performance tune of Informatica components for daily and monthly incremental loading.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Informatica Power Center 9.1, IDQ, Oracle11gR2, DB2, SQL, PL/SQL, TERA DATA, UNIX shell scripting, Control-M and, TOAD 10.5.