SUMMARY

• 10+ years' experience in Information Technology with specialization in Data Warehousing Technologies with strong combination of data analysis and database concepts . I have worked as an ETL Tech lead, Solution Lead, Migration and Module lead for various client engagement projects.
• Specialize in ETL Architecture, roadmap, upgrade plan, execute architecture simplification to invest in newer technologies to solve current business needs with automation at scale
• Proficient in end to end installation and configuration of Databases(11g/12c), Informatica 9.x/10.x suits ( PC, BDM, IDQ, MM, BG, TDM, DVO, B2B, PWX ) in Grid and HA platform
• Exposure in Informatica Big Data Management (BDM 10.x) on Hadoop Eco Systems (HDFS, Hive, Map - Reduce, Impala etc.)
• Experience in setting up User Security Model in multi-tenant ETL platform
• Experience in NFS mounting, SSH, users setup, installation of RPM packages in RHEL platform
• Worked extensively with SQL and PL/SQL, UNIX shell scripts
• Experience in designing and building Data Quality Architecture incorporating with ETL process
• Proficient in Business Analysis, Development Lifecycle, ETL, QA and Testing and Performance Tuning and Tableau reporting
• Proficient in setting up Cloudera Distributed Hadoop ( CDH ) on cluster nodes and enabling the services for HDFS, Hive, Hue, Map-Reduce, Zookeeper, Oozie etc.
• Have worked as Oracle DBA to some extent and proficient in setting up the Database, schemas, profiles, tablespaces and user and roles setup and regular maintenance activities
• Leads proof of concept evaluations, vendor and product selection for data management technologies as required
• Provides design recommendations, best practices, standards and guidelines for the enterprise data lake solution

AREAS OF EXPERTISE

• Installation and Configuration and Administration of Informatica Product suits
• SQL, PL/SQL Programming and Performance Tuning
• Integration of Informatica Big Data Management (BDM) in Hadoop Cluster
• Evaluation Enterprise capabilities, provide Best Practice and solution for an enterprise Define the technology/architecture strategy, roadmap and thought leadership

TECHNICAL SKILLS

Hardware / Platforms Language: Windows 2000/7, MS Windows Server 2008/2012 R2, Vista, Linux, AIX Concepts in DBMS, SQL and PL/SQL TOAD Data Modeler, Erwin V8 Oracle 10g/11g/12c,Unix Shell Scripting, Python

Data Modeling Tool: nformatica PowerCenter(PC), Informatica Data Quality(IDQ),Informatica Big Data Management(BDM),Metadata Manager(MM), Test Data Manager(TDM)

Databases Scripting Languages Tools: Data Validation Option(DVO),Business to Business Data Object(B2B), Alteryx, CDH, Hadoop, Hue, Hive, Impala, SQL Loader, PL/SQL Developer, Putty, Toad, WinSCP, SQL Developer, Oracle Discoverer 4, Autosys, Teradata SQL Assistance

Utility Reporting Tools Monitoring Tools: Tableau 9.x, Oracle Discoverer, Proactive Monitoring for PowerCenter Operation and Governance(PMPC)

PROFESSIONAL EXPERIENCE

Informatica Architect

Confidential, Pleasanton, CA

Responsibilities:

Working in Confidential as an Informatica Architect. Involved in installation of Informatica and Hadoop platform (PC, IDQ, MM, BG, TDM, B2B, DVO, PWX, BDM, CDH) in Linux Platform, heavily involved in ETL roadmap, platform assessment, tool selection for new use cases and future enhancement of the highly scalable product. Have hands-on expertise with Cloudera Distribution Hadoop (CDH) setup and Informatica suits installation with Grid and HA in Linux RHEL platform.

Technologies used: Informatica PowerCenter - 9.x/10.x, Informatica Data Quality -9.x/10.x, Informatica Big Data Management -10.x, Data Validation Option -9.x/10.x, B2B 9.x/10.x, Linux, Tableau, Python, Unix Shell Script, Safenet, Oracle 12c, Exadata, CDH 5.x, Hive, MapReduve, HDFS, Impala, Mongo DB

ETL Solution Architect

Confidential, Thousand Oaks, CA

Responsibilities:

Worked in Confidential as an ETL Solution Architect. Involved in designing the solution using Informatica PowerCenter and Data Quality solution and leading team of developers to implement the design the deliver the interface. Most of the build interface was reusable in nature and used the metadata to achieve multitenancy. Also Design a framework for uploading PowerCenter generated QC reports into SharePoint through batch process.

Technologies used: Informatica PowerCenter - 9.x, Informatica Data Quality -9.x, Oracle, PL/SQL, Linux, Unix Shell Script, Data Flux, Erwin, WinSCP, SQL Loader

ETL Design Lead and Migration Architect

Confidential

Responsibilities:

Worked as an ETL Design lead to build the ETL interface. Worked as a lead developer, mentoring team members for high quality delivery on time. In the second phase of this project, worked as Migration Architect for the Migration Activities including Project plan, deployment and execution of the project, resource load and monitor the execution of the project. Involved in system and integration testing of ETL interface.

Technologies used: Informatica PowerCenter - 9.x, Informatica Metadata Manager -9.x, Oracle, PL/SQL, Linux, UNIX Shell Script, Informatica MDM, Erwin, WinSCP, SQL Loader

IT Engineer

Confidential

Responsibilities:

Worked as a Module Lead Confidential and was responsible for developing codebase, applying the new patches, releasing new version time to time. Worked as an Oracle DBA for two years and involved in any database setup and migration activities.

Technologies used: Oracle 10g/11g, PL/SQL, Linux, UNIX Shell Script, SQL Loader, Oracle Discover

Software Engineer

Confidential

Responsibilities:

Worked as a team member in Materials Module and involved in developing package, procedure, triggers, and functions for the software product.

Technologies used: Oracle 10g/11g, PL/SQL, Linux, UNIX Shell Script, SQL Loader

Project Trainee

Confidential

Responsibilities:

Worked as a trainee engineer in designing Access database.

Technologies used: MS Access, LabView 6.1