PROFILE:

Informatica Certified Specialist with 11+ Years of Total IT Experience in ETL Development

SUMMARY:

• 11 + years of IT Industry experience.
• Successful implementation of Projects using Informatica 7.X, Informatica 8.6, Informatica 9.1, Informatica 9.6.1& Informatica 10.1.1.
• Detailed analysis of requirements and efficient management of Databases on Oracle 9i/10g/11g/12g, MS Sql Server and Netezza.
• Integrated data between various data sources & targets like Oracle, MS SQL Server, Flat Files, XML, AWS MySQL, SFDC, HDFS, Netezza, Progress DB, AWS S3, Elasticsearch, AS - 400 DB2, SOAP Web Services, Un-structed data files (pdfs).
• Proficient on UNIX, including file handling & Shell scripting, database PL/SQL scripting
• Strong in all phases of the Software Development Life Cycle and have worked in large scale projects with incremental deliverables.
• Experienced in implementing complex business rules by creating Informatica transformations using Source Qualifier, Lookup (Connected, Un-connected, active, passive), Joiner, SQL, HTTP, Java, UDT, Union, Sorter, Aggregator, Rank, Normalizer, Filter, Expression, Router & Update Strategy.
• Employed performance tuning in Power Center at the Target, Source, Mapping, Session and System Levels, by utilizing indexes, shared and persistent lookup caching, changing session DTM and block buffer memory, session partitioning & Pushdown optimization.
• Performed administration activities such as migrating workflows/sessions/mappings from lower to higher environments, created and managed folder, connection and group access.
• Successfully implemented ETL integrations with cloud technologies like AWS S3, Salesforce.
• Designed mappings and data synchronization tasks using the Informatica Cloud Services.
• Experienced in data quality tools like Informatica Developer (IDQ).
• Skilled in Informatica PowerExchange for reading data from Mainframe AS 400 DB2, and for capturing change data.
• Created re-usable PowerCenter components such as mapplets for re-usability in multiple processes.
• Adept at the role of a data miner.
• Expert in performance tuning ETLs and database queries, to ensure their compliance with SLAs.
• Ability to independently perform complex troubleshooting, root-cause analysis and solutions development .
• Strong in relational and NoSQL database concepts.
• Familiar with handling tools such as TOAD, FileZilla FTP, Putty, Visual Studio 2005/2008, Secure CRT, WinSCP and MS-Office 365 suite of tools.
• Experienced in working with scheduling tool (Control M jobs).
• Utilized Tableau to slice and dice the data for end users.
• Ability to meet deadlines while handling multiple tasks, with decisive and strong leadership skills, yet being flexible in work schedules.
• Good Analytical and problem-solving skills with excellent communication skills.
• Effective in working both independently and collaboratively in teams.

SKILLS:

Primary Skills: Informatica Powercenter ETL, DW/BI, Developer IDQ, PowerExchange, Data Transformation Studio, Repository Manager, Oracle 12g, Data modelling, Data mining, Informatica Metadata querying, Informatica Cloud Services.

Secondary Skills: Unix commands and scripting, Netezza ELT scripting, AWS technologies, BMC Control M, Tableau

TECHNICAL SKILLS:

Core Technologies: Informatica 10.1.1, IDQ, PWX CDC, Informatica Cloud, DTS

RDBMS: Oracle 12g, Sql Server 2005 and 2008, Netezza, DB2

MSOffice 365, MS: Visio 2003/2007

Development Framework: Waterfall, Agile

Schedulers: Informatica scheduler, BMC Control M

Operating Systems: Windows 10, Windows 7, Windows Vista, XP, RHEL

Database Technologies: SQL Scripting and SQL performance tuning, PL/SQL scripting

Versioning Tools: Tortoise SVN

Reporting Tools: Business Objects XI R2, Tableau

Cloud Technologies: Salesforce, AWS S3, Confidential MySql

Third Party S/W: TOAD, Putty, Filezilla FTP, WinSCP, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Onsite Informatica Developer &Technology Lead

Responsibilities:

• Onsite technology lead, responsible for leading and driving a five-member support team who maintains, monitors and provides 24x7 support to the 80+ business critical ETL applications for Confidential
• Responsible for gathering new project requirements and sharing high level design details with the India development team.
• Migrated Informatica jobs, connection strings between different environments during deployment activities.
• Implemented ETL solutions for integrating with cloud technologies like Salesforce via API, AWS S3 via CLI, Confidential Aurora MySql DB via ODBC.
• Involvement in Joint Application Development (JAD), incorporating ETL solutions during war room sessions with business.
• Developed mappings using the Informatica Cloud Services, for synchronizing Customer data with the SFDC account object.
• Initiated and spearheaded creation of data flow diagrams for documenting complex ETL and ELT process flows, with help of MS Visio and Lucid charts. The diagrams helped ease understanding of data flow processes.
• Accountable for providing POC of new open-sourced data integration tools such as “Pentaho”; and to examine their viability as a low-cost alternative to Informatica.
• Adept at querying the Informatica repository database, to obtain metadata about the ETLs, for various analytical and data mining purposes.
• Experienced in creating PL/SQL stored procedures for computing the PM compliance metrics for the Fleet Dashboard Toolkit application.
• Accountable for the detection and analysis of ETL and Netezza process bottlenecks, and implement ways to improve performance. Such exercises have resulted in the conversion of certain long-running database stored procedures into set based ETL processes, yielding improved data availability time for business.
• Ownership of many ETL applications such as OCS (onboard computing system), Fastlane (Disposal operations), wm.com (Ecommerce application), Finance Cubes (Essbase), salesforce (Sales application) & providing detailed analysis and implementing plausible solutions for production issues.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote servers.

Environment: Informatica PowerCenter 9.1, 9.6.1& 10.1.1, Informatica Data Quality, TOAD, Oracle 10g/11g/12g, Linux server, Netezza, Pentaho, AWS

Confidential, Houston, TX

Senior Informatica ETL Developer/Lead

Responsibilities:

• Led the ETL team to devise ETL processes to consume the disposal files in binary blob format from the Fastlane Oracle DB, convert it to a pdf file, and then utilize Confidential CLI to upload the pdf files from the ETL server to an AWS S3 bucket.
• Co-ordinated with the java team to capture the java code for converting the Oracle blob data to a pdf file, by using the Informatica Java transformation.

Environment: Informatica PowerCenter 10.1.1, AWS S3 CLI, BMC Control M

Confidential, Houston, TX

Informatica ETL Developer/Lead

Responsibilities:

• Led the design and development of creating the ETL batch processes for transferring the payment transactions, methods and pay instructions from the Cyber-source vendor to WM’s Canada Ecommerce AWS MySql database.
• Standardized the data using IDQ Standardizer transformation to standardize reference data, before pushing it to the AWS cloud database.
• Designed ETL and ELT processes for ingesting the AWS Aurora MySQL payments data to the on-premise CCDB Netezza data warehouse, for usage in MicroStrategy reports.

Environment: Informatica PowerCenter 9.6.1, AWS Aurora MySQL, RHEL, BMC Control M

Confidential, Houston, TX

Lead Informatica ETL & Netezza Developer

Responsibilities:

• Designed and developed ETL, ELT (Netezza) code and tables/views for consolidating Peoplesoft HR, PMT and Talent (Taleo) data for the SDO report.
• Utilized Tableau to show the prototype data to the end users from the SDO table.
• Co-ordinated with the end users to gather the requirements and used PowerCenter and Netezza DB to integrate the data between the various source systems, and to create techno-functional documents.
• Scheduled the developed Informatica workflows and Netezza jobs via the Ctrl M Scheduler.

Environment: Informatica PowerCenter 10.1.1, IBM Netezza, BMC Control M

Confidential, Houston, TX

Informatica ETL Developer/Lead

Responsibilities:

• Created the nightly integration ETL processes to batch process the customer data from WM’s iSeries AS 400 DB2 system and into the Salesforce objects.
• Utilized Power Exchange CDC real-time capabilities to replicate the AS 400 DB2 customer and their associated services data into an oracle staging DB. Then used Informatica Cloud data synchronization utility to process this data into the SFDC objects.
• Utilized PowerCenter batch ETLs to perform one-time historical data loads after major SFDC releases.

Environment: Informatica PowerCenter 9.6.1, Informatica Cloud Services, PowerExchange, SFDC, Control M

Confidential, Houston, TX

Informatica ETL Developer/Lead

Responsibilities:

• Led the ETL team to create feeds to transfer the transactional payment data from Cyber-source (vendor) to the MAS and eBiz billing/ecom systems, by utilizing XML/XSD’s to read the source data.
• Troubleshot and resolved the QA bugs raised during the QA, SIT and data validation testing with user.

Environment: Informatica PowerCenter 9.6.1, Linux, Control M.

Confidential, Houston, TX

Senior Informatica ETL Developer

Responsibilities:

• Designed and developed ETL processes to feed the various vehicle, property and accident processing loaders of the AIC system.
• Created re-usable PowerCenter sessions and utilized parameterized datestamps to load the historical incidents data on a YOY basis to the AIC server.
• Made use of the Informatica Developer to enforce Data quality, standardization and consolidation rules before passing the data over to AIC.

Environment: Informatica PowerCenter 10.1.1, Oracle 12g, IDQ, RHEL, Control M

Confidential, Houston, TX

Informatica ETL Developer/Lead

Responsibilities:

• Led the design and development of new ETL processes to forklift the existing ESB mappings and convert them into ETL code.
• Involved in the troubleshooting and performance tuning of the ETL mappings, to achieve the desired throughput.

Environment: Informatica PowerCenter, Linux, Control M

Confidential, Houston, TX

Informatica ETL Developer

Responsibilities:

• Developed ETL processes to move the WM customer data from the MAS customer billing system to the Elasticsearch server.
• Converted the relational customer master data into a Json string format by utilizing various Informatica transformations.
• Created re-usable Powercenter designer mapplet to convert relational customer master data into NoSQL json string.
• Co-ordinated/troubleshot with the Quality, User acceptance teams for Move to Quality & Production activities.

Environment: Informatica PowerCenter, Linux, Control M

Confidential, Houston, TX

Informatica ETL Developer/Lead

Responsibilities:

• Worked with the financial analysts to capture the requirements and convert them into ETL specs.
• Designed and developed ETL’s integrating data from the PeopleSoft Finance and PMT databases to generate Essbase files containing financial consolidation, aggregated volume and rate change and budgeting information.

Environment: Informatica PowerCenter, Linux, Control M, Oracle.

Confidential

Offshore ETL Developer/Technology Lead

Responsibilities:

• Technical lead at offshore, responsible for leading and driving the ETL support team that maintains and provides 24x7 support to the 80+ business critical ETL applications for Confidential Inc.
• Received business knowledge transition from client, and worked on the requirement analysis and development of business-critical applications such as Onboard computing tool, and pricing applications.
• Ownership and accountability of critical ETL applications such as OCS (onboard computing system), Fastlane (Disposal operations), wm.com (Ecommerce application), salesforce (Sales application); providing detailed analysis and implementing plausible solutions for production issues.
• Responsible for performance tuning at a functional level and at a mapping level. Banked on heavy usage of relational SQLs wherever possible to minimize data transfers over the network, thereby improving the ETL’s ability to meet SLAs.
• Developed mappings that landed Netezza tables from other source systems (Oracle, SQL-server and flat files) using simple, medium and complex mapping logics for the WM EBI Business unit.
• Provided technical expertise to the support team which helped the team collaboratively resolve many productions issues.
• Provided techno functional application presentations for certain applications that were developed for client, during the onsite visit around May, 2013.

Environment: Informatica PowerCenter 9.1, TOAD, Oracle 10g/11g, Linux server.

Confidential

Business Objects Developer

Responsibilities:

• Handled the Business Objects module for the DOW support project.

Environment: Business Objects XI R2.

Confidential

Informatica Developer

Responsibilities:

• Analysis of Business Requirements & laid down to a Design Document and Investigation documents.
• Worked on different Sources such as Oracle 10g, Sap R/3, SQL Server, IVR, ICM and Flat Files.
• Role as an ETL developer includes developing simple and complex mappings. Implementing complex business logics by using various transformations at mapping level.
• Understanding business process flow to achieve Application performance.
• Performed Unit Testing, performance tuning of mappings and SQL statements.
• Coordinating/troubleshooting with Support team for the MTP (Move to Production) activities.

Environment: Informatica Powercenter 7x(Later 8.6), Oracle 10g, UNIX.