SUMMARY

• 17 years of experience in IT industry with over 14 years of experience in designing, developing and implementing Data Warehouse Applications and Transformation processes using Informatica Power Center 10.1, 9.5/9.1/8.6/8.1/7. x (Repository Manager, Workflow Manager, Designer, Workflow Monitor, Admin Console), Teradata Utilities, SSIS, Oracle PL/SQL.
• Over Six years of proven track in handling Informatica Admin & Operations tasks such as Installation, Building/Managing environments, Patching, Performing Version Upgrade(s) of Informatica PowerCenter and Informatica Big Data (BDE/BDM), Informatica MDM applying Hot Fix (HF) & Emergency Bug Fix (EBF), Providing Platform Support, Creating User Accounts and Managing Access Levels, Migrations across environments.
• About Five years of experience in Administering & Supporting Hadoop/Big Data tools in a Kerberized Cluster which included Informatica BDM/BDE (ETL), Platfora, Datameer & Tableau (Analytical), Azkaban & StreamSets (Data Ingestion), Control - M/Autosys (scheduling).
• Hands on experience in Project Management, Leading ETL Development and Operations teams, Mentoring and Supervising on-site/off-shore resources in the areas of Development, Administration and Operations.
• Exposure to Amazon Web Services (AWS) utilities/services EC2, S3 & CLI., Microsoft Azure Cloud Computing Platform & Services, Tableau
• Hands on experience in querying data from Hadoop (HDFS) using Hive & Impala for analytical purposes.
• Data Modeling (Physical and Logical) experience using Dimensional Data modeling ( Star Schema and Snowflake) modeling, using ERwin 4.1, ER Studio
• Experience in Automotive, Health Care, Communication, Financial Services and Insurance Domains
• Hands on experience in Unix Shell Scripting, Pre-Session, Post-Session UNIX commands for automation of Informatica job scheduling, backup of repository.
• Proficiency in the areas of Project Management, Resource Management (Interviewing & selection), Access Management and Technical Documentation.
• Experienced in different Project Management Methodologies like Traditional water fall and Agile. Proactive in learning new technologies and updating skills.
• Proven team player with excellent communication and interpersonal skills meeting the deadlines.

TECHNICAL SKILLS

Databas es: Netezza, Oracle, Teradata, SQL Server, Athena, Vertica, DB2, MS Access

ETL Tools: Informatica PowerCenter 10.1, 9.5/9.1/8.6/8.1/7. x/6.2, Informatica BDM / BDE 10.2/10.1/9.6 , Informatica MDM 10.1/9.7, SSIS, PL/SQL, Teradata utilities (B-Teq, Fast / Multi Load, T-Pump)

Big Data: Cloudera CDH 5.9, Horton Works HDP, Platfora, Datameer, Azkaban, Hive, Impala, StreamSets/Jenkins

Cloud Computing: AWS (EC2, S3, Redshift, DynamoDB), MS Azure (Cosmos DB, App Services, Function APP, API Management Service)

Languages: SQL, T-SQL, PL-SQL, XML and Unix Shell Scripting

Other tools: Aginity Workbench, Toad, SQL Server Management Studio, Oracle SQL Developer, Teradata SQL Assistant, Jenkins, StreamSets, MS Visual SourceSafe, Control-M, Autosys, MS Office, MS Project

Operating Systems: UNIX/LINUX, Windows

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Technology Lead

Responsibilities:

• Responsible for Reviewing and Analyzing business requirements and transforming and incorporating them into the existing DW Architecture.
• Responsible for driving Change Log Review meetings involving DBA’s, Data Modeler & Enterprise Architect(s) where the proposed changes that need to be incorporated into the Data Model are discussed and finalized.
• Responsible for reviewing and approving Informatica code developed by off-shore team(s) to make sure the development standards/best practices are met/followed.
• Successfully Led cloud implementation which involved coordinating with various/specific teams in the setting up of Infrastructure/Environment for Microsoft Azure and Tableau.
• Responsible for creating/Iterating Development and Deployment Standards document that were to be used by the development teams.
• Responsible for tracking/logging Informatica failures and take-up additional development tasks to work towards enhancement/modifying the code to make the processes more resilient.
• As a voluntary task, successfully identified and modified numerous processes that were residing on Productions systems that missed the Coding/Naming Standards, Alerting/Notification Standards.
• Responsible maintaining the Change Log to capture and keep track of the changes made to the Entities of the Data Model.
• Participate in Sprint ceremonies to track the progress of the development work and help Dev Teams in resolving Blockers.
• Knowledge of Auto Scaling (Scale Out & Scale Up) and Deployment of Functions & APP’s and API’s.
• Exposure to VersionOne, CyberArk, GIT, Microsoft TFS

Environment: Informatica PowerCenter 10.1, Informatica MDM 10.1/9.7, Informatica BDM 10.1, Teradata, HDFS-Horton Works 2.7.3, YARN, Spark, Kafka, MS Azure, Cosmos DB, Ambari Hive, Business Objects, Tableau 2018.1.1, Autosys, Jenkins, Maven, CyberArk, Active Directory (AD), Microsoft VSS 6.0, LINUX (RedHat).

Confidential

Tech Lead

Responsibilities:

• Lead/Train/Mentor Business Intelligence Operations team on various tools that it supported which included Informatica PowerCenter, Informatica MDM, Informatica Big Data Edition(BDE/BDM), Cloudera (Hadoop), SAS, MicroStrategy, Platfora, Azkaban, StreamSets, Control-M
• Responsible for Business Intelligence day-to-day Operations of both Legacy (Informatica PowerCenter, SAS, MicroStrategy) and Big Data systems (Informatica BDE/BDM, Platfora, Datameer, StreamSets) in a Kerberized cluster.
• Responsible for Infrastructure Administration (Installation, Patching/Upgrade, Support & Maintenance, Managing User Access & Privileges, Creating ODBC connections for relational Data Bases, Integration with new source systems like SalesForce & HDFS) of the various tools involved in Business Intelligence/Analytics (Platfora, Datameer, Azkaban, Informatica BDE/BDM, Informatica PC, Informatica MDM, StreamSets, Jenkins). Installation/Upgrade of Database drivers, Generating SSH Keys on Informatica Unix Boxes for SFTP.
• Successfully configured Java and HTTP transformations to be used to invoke web service endpoints for SOAP/REST Services and to invoke a REST based web service from Informatica PowerCenter.
• Responsible for developing ETL code to generate weekly and monthly reports & statistics on the statuses of the jobs from Meta data / Repository tables.
• Responsible for conducting code review sessions to make sure the code developed by the Development teams adhere to the standards of the company and provide suggestions as and when required.
• Successfully led ETL Resilience Project, the main emphasis of which was to identify the frequently failing jobs and enhance the code to not let the job(s) fail without considerable number of reattempts so that there would be minimal manual intervention, which involved selection/hiring resources, assigning/tracking tasks, frame/provide specs for development/enhancement, code review and code migration to PROD.
• Successfully handled the Informatica OS migration (from Windows to Linux) for KBB (Kelly Blue Book) Business Unit, which involved building a new Informatica environment to reside on Linux with AD/LDAP Authentication/Integration and Confidential the same time migrated the repositories from Windows.
• Built extensive documentation on ETL processes to enable the team understand the dependencies of the jobs across various subject areas and resolution steps/strategy in the event of failures, which helped the team members to troubleshoot and recover the failure(s).
• Successfully performed Version Upgrade of Informatica BDE (BDM) from 9.6.1 HF1 to 9.6.1 HF3 as recommended by Informatica to overcome an AD issue.
• Took Ownership and Supported the Demdex project that utilized Amazon Web Services utilities to process Web Logs data for reporting.
• Hands on experience in configuring and creating Jenkins pipelines to pump data continuously from Netezza into Hadoop Data Lake using StreamSets.
• Exposure to Syncsort DMX-H8, AWS utilities like S3 (Storage), EC2 (Services), Athena/DynamoDB (Database), Elasticsearch. Familiarity with REST & SOAP web services.

Environment: Informatica PowerCenter 9.5/9.1, Informatica MDM 10.1/9.7, Informatica BDE 9.6, Netezza, Oracle 11G/12C, SalesForce, HDFS-Cloudera CDH 5u9, MongoDB, Kerberos, MapReduce, YARN, Apache Hive, Kafka, AWS (S3, EC2, Athena), Maven, Vertica, REST Services, Impala, Platfora, Datameer, Azkaban, StreamSets, GIT, Jenkins, Control-M, Microsoft VSS 6.0, MS Office, LINUX, Active Directory, MicroStrategy.

Confidential

ETL Development Lead / Informatica Admin

Responsibilities:

• Responsible for Business analysis and Requirement Gathering.
• Maintained warehouse metadata, naming standards and warehouse standards for future development.
• Developed data model (conceptual/logical/physical) for data mart according to the requirements using ER Studio.
• Understand and apply design/coding standards defined by TI Decision support team to ensure run/maintain supportability.
• Designed mapping documents and created Informatica mappings for the development of WCH Operational Data Store.
• Lead a team of developers both on-site and off-shore, assigning them tasks and conducting daily status review meetings to ensure the deadlines are met.
• Developed and supported the extraction, transformation and load process (ETL) for Data Warehouse on SQL Server 2005 from the source systems using Informatica PowerCenter 9.1/8.6.1/ 8.1.1 & SSIS
• Coordinate and assist in system testing, performance testing and integration testing cycles.
• Was responsible for documentation of the all the ETL processes and maintain those using Visual SourceSafe (VSS) 6.0.
• Participated in knowledge transition to IT Decision support team.
• Interacting and communicating with the various sources for enhancement process of the application.
• Developed Detail Design document for data warehouse Development.
• Involved in Testing and developed test scenarios/cases.
• Worked on various enhancements and break fixes of the application as part of On-Call support.
• Preparation of Unit Test Plans and verification of functional specifications and review of deliverables.
• Was responsible for all the deployments/code migrations (ETL and DB) across the environments, played the role of Administrator.
• Successfully upgraded Informatica version from 8.6 to 9.1
• Managed PROD, QA and DEV servers (Informatica), some of the roles included - Creating and Managing Folders/ Users, Periodically cleaning-up repository, Scheduling jobs, Configuring e-mail notifications, creating and configuring Re-usable objects.

Environment: Informatica PowerCenter 9.1/8.6.1, SQL Server 2008, Oracle 11G, PeopleSoft, MS Access, SSJS,vER Studio, Microsoft VSS 6.0, MS Office, Cognos

Confidential

Sr. ETL Developer / Architect

Responsibilities:

• Was involved in the Design, Development and Unit Test of the ETL code as per the requirements.
• Extensively used the utilities of Teradata - BTeq, Multi-Load to load data into the Teradata V2R6 Target database.
• Used the Fast Export utility of Teradata to run the Extracts (Extracting the data from BID tables and writing to flat files).
• Used Teradata SQL Assistant 7.0 to frame and test the SQL queries as part of the ETL process
• Created Mappings using Lookup, Expression, Filter, Router, Union and other transformations, Sessions and Workflows using Informatica 7.1.4 for loading the data into Stage tables
• Was involved in creating new Unix Shell Scripts and modifying the existing for enhancing the performance (optimizing) the ETL jobs.
• Created and used parameter files to provide values to the variables used across sessions and workflows of Informatica.
• Involved in creating the new job schedules using Maestro Scheduler when ever the necessity was felt.
• Utilized the Explain Plan utility of Teradata SQL Assistance to optimize the queries for better performance.
• Coordinated with the QA team and Operations (production) team while the code was being migrated across the servers
• Worked closely with Business Objects (BO) Reposting team to make sure the tables used for reporting are populated within SLA time.
• Was responsible for working with BO team to triage data load issues related schema tables within the Universe.

Environment: Informatica PowerCenter 7.1.4, Teradata V2R6, Teradata SQL Assistant 7.0, Oracle 9i, SQL Server 2005, UNIX Solaris, ERwin, Maestro, Java, Windows 2000/XP, Business Objects