SUMMARY

• Around 9 Years of IT experience in Data Analysis, ETL Design, Development, Programming, Testing, Performance tuning, Implementation and Troubleshooting & error handling in the field of Data warehousing and gathering Business User Requirements
• Extensively used Enterprise Data warehousing ETL methodologies for supporting data extraction, transformation and loading processing, in a corporate - wide-ETL Solution using Informatica Power Center.
• Experienced in working for clients from Healthcare, Pharmaceutical, Banking and Retail Sector.
• Proficient with Informatica Data Quality(IDQ) for cleanup and massaging at staging area.
• Experience in integration of various data sources like Flat files, EDI files, IDOC, Oracle, SQL server, SAP and MS access into staging area.
• Experience in Performance Tuning of targets, mappings and sessions.
• Understanding of Ralph Kimball Data Warehouse methodologies and knowledge on the various data design models like Star Schema and Snowflake model
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console
• Designed and written the scripts required to extract, transform, and load (ETL), clean, and move data and metadata so it can be loaded into a data warehouse, data mart, or data store.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/DataMart Design, ETL, OLAP, BI, Client/Server applications
• Working experience in UNIX environment and Preparation wrapper scripts to call ETL jobs and setting up alerts about the key load tables and space/memory issues in Systems.
• Good knowledge and experience in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Solid experience in writing SQL queries, Stored Procedures, Cursors, Indexes, Views, Sequences and Triggers.
• Experience on post-session and pre-session shell scripts for tasks like merging flat files after creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Hands on Relational Databases like Teradata, DB2, Oracle, Sybase and SQL server.
• Excellent Client handling ability with good communication and Presentation skills.
• Experienced working in versatile software development methodologies including Agile/Scrum, Iterative and Waterfall SDLC methodologies .

TECHNICAL SKILLS

ETL Technologies: Informatica Power Center 10.x/9.x, IDQ/IDE 9.x, SSIS

Operating Systems: IBM AIX 4.5/5.1/5.2, SUN Solaris 2.7/2.8/2.9, LINUX (REDHAT, Sues), Windows NT/2000 server, Windows XP/98/95, Unix

Databases: Oracle 12C/ 11g, SQL Server 2012/2014, DB2, Teradata TD14,TD 15.10 .

Languages: SQL, PL/SQL, XML and UNIX Shell Script.

Tools: Informatica Power Center 10.X/9.X, SAP, Power Exchange 5. IDQ, SSIS, Amazon redshift.

Data Modeling: Data Modeling, Dimensional Data Modeling (Star, Snowflakes Schema Modeling), Physical and Logical Data Modeling.

Reporting Tools: Business Objects XIR2/6.1, Oracle Analytics, Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Informatica/ETL Developer

Responsibilities:

• Round the clock monitoring of Jobs that are running in production and taking necessary action when there are issues.
• Implementation of Production Changes during the scheduled days and providing post-production support.
• Created SSIS Packages to pull the data from different source systems.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, Send Mail task etc.
• IR Handling for all data marts - ensuring that all assigned IRs are attended and resolved to customer satisfaction in a timely manner
• Analyzing and performance tuning of daily running jobs in production. Re-design & develop the jobs when there is a better way of getting the things done.
• Handling of adhoc reporting and feed requests from production and ensuring to provide monthly and quarterly feeds to finance and Internal audit teams.
• Checking on any long running production jobs and doing any performance tuning activities to ensure jobs are moving faster.
• Troubleshoot Tableau related issues and queries
• Relevant Tableau Desktop experience Tableau dashboards, visualizations, and performing advanced analytics to analyze data
• Relevant Tableau Server experience
• Gathering source system maintenance/downtimes during weekends and informing to business about metrics impact.
• Proficient in developing Custom/parameterized reports, different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)/SSDT)
• Ensuring on-time delivery of metrics, outbound feeds, etc.
• Analyzing problems, determining root cause, reporting on problem status, etc., for network and desktop (application hardware and software) issues.

Environment: Informatica PowerCenter 9.x/10.x, Teradata, Informatica Data Quality 9.6.1, UNIX, Blue Zone FTP, Windows 10, Power BI, Tableau, Cognos .

Confidential

Informatica IDQ/ETL Developer

Responsibilities:

• Analyze, design, develop and test business software based on the needs of business users.
• Design application and plan how different applications work together.
• Create a variety of models and flowcharts needed for an application development
• Document every aspect of the application as a reference for future maintenance and upgrades.
• Ensure that the application continues to function normal during software maintenance and Testing.
• Development of new Reports / Dashboards using Tableau and relevant data source (Big Data Platform (Cloudera), Excel, SQL Server etc.)
• Worked on building the ETL architecture and source to target mapping to load data into data warehouse.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sequence Generator transformations. Developed Rules using IDQ thin and thick clients.
• Supporting production and involved in performance tuning.
• Responsible to create Profiles and run profile applying rules and filter conditions.
• Responsible to create Scorecards, generate and to report to the business.
• Responsible to interact with the business and to gather business requirements.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Worked on Informatica Developer tools - Informatica Data Analyst, Informatica Developer tool
• Developed ETL mappings, mapplets sessions, workflows, developed rules, LDO's, PDO's, profiles, Scorecards in IDQ and automated the process to generate reports

Environment: Informatica PowerCenter 10.2, Teradata, Informatica Data Quality 9.6.1, UNIX, Windows 7, Windows 10, Power BI, SQL Server .

Confidential

Informatica Developer

Responsibilities:

• Develop solution in highly demanding environment and provide hands on guidance to team members.
• I have worked as ETL developer in MN state healthcare project.
• Worked with different Informatica transformations like Aggregator, Lookup, Joiner, Filter, Router, and Update strategy, Union, Normalise and SQL in ETL development.
• Worked with Push down optimization to improve performance.
• Developed different mappings for healthcare institutional and professional data
• Created pre-session, post session, pre-sql, post sql commands in Informatica.
• Worked with Event wait and event raise tasks, mapplets, reusable transformations.
• Worked with Parameter file for ease of use in connections across Dev/QA/Prod environments
• Implementing an Informatica based ETL solution fulfilling stringent performance requirements.
• Ability to analyze and dissect user requirements and build front-end BI applications according to specifications
• Conducted impact assessment and determine size of effort based on requirements.
• Developed Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, T-SQL.
• Created transaction data objects to come up with source to target mapping and data conversion design.
• Worked in all the design/develop artefacts and gave a detail visibility to client lead in terms of data delivery of the blueprint program

Environment: Informatica Power Center 9.6, Service Now, Toad 10, DB Visualizer, Unix, Toad Data modeler,DB2, Linux Susse, shell/Perl scripting, SQL, Control-M.

Confidential, CA

Informatica Developer

Responsibilities:

• Identified business rules for data migration and analysed the business requirements.
• Worked with pre-and post-sessions, and extracted data from Transaction system into Staging area.
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Informatica Server.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Work with vendor to maintain and implement a long term strategy for Tableau
• Used PL/SQL to write store procedures to increase performance.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Loaded data from various sources using different transformations like Source Qualifier, Joiner, Sorter, Aggregator, Union, and Update Strategy to load data into the target.
• Worked on Data Cleansing, Data Conversion Process implementation.
• Perl Scripting for backup and monitoring of databases.
• Provided daily support to clients including data research and test environment data refreshes.
• Monitored the processes to identify potential issues and apply preventative and correction actions. Designed the slowly changing dimension strategy for warehouse.
• Responsible for dealing with the problems, bug fixing and trouble shooting.
• Provided production support.
• Coordinated between Development, QA and Production migration teams.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, MS Access, PL/SQL, Teradata.