We provide IT Staff Augmentation Services!

Onsite Lead Resume

Schaumburg, Il

SUMMARY:

  • 12+ years of extensive experience in Data Integration solutions, with a strong background in Data warehousing and 9+ years of experience in Administering, architecting, Implementing and supporting projects using Informatica Products. 1+ Years of experience in using snowflake cloud data warehouse.
  • Successfully implemented a very important project(unify the data across the enterprise) for the customer, transition from Traditional warehouse to Snowflake
  • Interfaced with clients on transformation from traditional data warehousing solutions to Snowflake cloud warehouse
  • Worked on Snowflake Data Platform Solution Architecture, Design, Development and deployment - - solution focused to unify the data across the enterprise
  • Have Strong knowledge in cloud computing, data warehousing principles, Data Quality, Master Data Management, Infrastructure requirements and capacity planning.
  • Expertise in installation, Configuration, Development and diagnosing of Informatica tools like Power center, BDM, MDM, IDQ, Information Life Cycle Management (ILM) Data Masking, Informatica Power Exchange for SAP and Teradata TPT, Informatica services like SAPBW services, Web Services Hub, Data Quality, Informatica Data Virtualization (IDS), Informatica cloud services and LDAP( All versions from 8.1.1 to 10.2 Unix Primarily & Windows
  • Extensive expertise on Informatica Data Quality(IDQ), Informatica Data virtualization(IDS) & Cloud Services(ICS)
  • Expertise in migration of Informatica PC from one version to other version, code development& deployment (Versioned and Non Versioned Repositories) and user access management.
  • Experience in debugging mappings, Identifying bugs in mappings by analyzing the data flow and evaluating transformations.
  • Created a windows based Python module that helped in our transformation from Netezza to Snowflake.
  • Experience in developing solutions using Python programming language
  • Created data pipelines using Apache-Airflow which is used for Data Orchestration, for migration from Netezza to Snowflake.
  • Experience in using the Informatica command line utilities like infacmd, pmcmd, pmrep to configure automated scripts related to Informatica processes.
  • Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, DB2, Oracle, SQL Server and Teradata.
  • Worked on Change Management Tools to track all the incidents and changes and to plan the production changes as per the change management policies.
  • Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Primary Skills: Informatica Power Center, BDM, MDM, IDQ, IDS, Informatica Cloud Services, Power Exchange

Secondary Skills: Snowflake, Python

Cloud Platform: AWS

Databases: Oracle 12c/11g/10g, MS SQL Server2008,Teadata,DB2, Netezza

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

Operating System: UNIX ( Solaris, LINUX), Windows NT/XP/2008

Other Technologies: Autosys, SAS 9.4, Attunity, Composite 5.1, Cisco Data Virtualization(CDV 6.2)

PROFESSIONAL EXPERIENCE:

Onsite Lead

Confidential, Schaumburg, IL.

Responsibilities:

  • Providing 24X7 support to all administrative issues related to Informatica, Snowflake and Autosys
  • Worked on Snowflake Data Platform Solution Architecture, Design, Development and deployment - solution focused to unify the data across the enterprise
  • Successfully Deployed 45 TB Netezza system into Snowflake data platform
  • Worked with Architect on final approach and streamlined the integration - Informatica with Snowflake
  • Have built new Informatica environments by architecting the severs including the Disaster Recovery Servers with standard specifications directly with Power center 10.1 in DEV/UAT/PROD with multiple nodes for production environment
  • Installed and Upgraded Informatica BDM and other platforms to facilitate connectivity to HDP 2.6
  • Installed and Upgraded Informatica MDM to 10.1 HF5
  • Helped integrating many source systems into MDM to provide customer and distributor master data.
  • Provided Informatica based solutions to connect to SalesForce, MuleSoft APIs and Message Queues
  • Responsible for setting up SAS connectivity to Azure SQL warehouse and HDInsight
  • Created a windows based Python module that helped in our transformation from Netezza to Snowflake.
  • Used Python pytest, pyodbc, numpy, openpyxl, MySQLdb, sqlite3, snowflake-python-connector and other packages.
  • Developed a Python script to integrate DDL changes between on-prem Netezza warehouse and snowflake
  • Automated regular monitoring and other admin activities on Informatica platform using Python and shell scripts.
  • Developed SnowSql scripts to deploy new objects and update changes into Snowflake
  • Autosys Integration with S4 HANA and MuleSoft - successfully completed the whole deployment into Autosys scheduler

Environment: Snowflake, AWS, Informatica Big Data Management, Informatica MDM, Informatica Power Center 10.2/10.1 HF5/9.6.1, IDQ 10.1, ICS, SaleForce, SnowSQL, SnowPipe, Apache-Airflow, Oracle 12c/11g, DB2 10.5, Microsoft SQL Server 2008/2012, PyCharm, Atom, Autosys, ServiceNow.

Onsite Lead, Informatica L3 Support

Confidential, Collegeville, PA.

Responsibilities:

  • Providing 24X7 support to all administrative issues, while working with around 3000 users (onsite/offshore model)
  • Have built new Informatica environments from scratch by architecting the severs including the Disaster Recovery Servers with standard specifications directly with Power center 9.1/9.5.1 Real Time edition in DEV/UAT/PROD with multiple nodes for production environment
  • Upgraded Informatica from 9.1 to 9.6.1 version as part of tech refresh project across all environments for few critical applications.(Jan 2015)
  • Installed and configured Power Exchange for CDC and integrated with Power Center.
  • Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments on versioned repositories.
  • Created Groups, roles, privileges and assigned them to each user group.
  • Setup and configure Power Center domain, grid and services.
  • Create and maintain the Relational and Loader ODBC connections in Development, QA and Production environments.
  • Implement capacity management, Debugging, Validation and performance best practice guidelines and monitoring.
  • Configured LDAP Authentication using Microsoft active directory services.
  • Worked with UNIX Admin and DBA team related to OS and Database related issues.
  • Worked closely with Informatica Technical support on Informatica related technical & environmental issues.
  • Extensively worked on UNIX shell scripts on automation (Auto restart of services, Disk space utilization, cleanup the logs directories) and scripts using Informatica Command line utilities.
  • Performed System level health checks CPU, Memory utilization, Number of parallel loads (sessions) running on each node.
  • Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
  • Performed Testing, Debugging and Validation and Performance Tuning of Data Warehouse deliverables.
  • Provide standards using Informatica velocity guidelines to application development teams.
  • Worked on HP ServiceCenter tool to plan production changes as per the change management policies and get it approved along with other dependent changes.

Environment: Informatica Power Center 9.6.1/9.5.1/9.1.0 , IDQ 9.5.1, ICS, Informatica data virtualization(IDS 9.5.1),Oracle 11g/10G, DB2 9.5, Teradata, Microsoft SQL Server 2008, HP ServiceCenter.

Sr. Informatica Administrator

Confidential

Responsibilities:

  • Installed, configured & upgraded to Informatica Power Center 9.5.1 from previous versions and applying EBF and Hotfixes.
  • Creating Object Queries, Deleting and purging objects.
  • Formulating deployment plans and reviewing installation instruction (ETL/Unix migrations) documents.
  • Created Users, Groups and Roles in Admin console (Administrator) and granted the privileges to the same.
  • Managing nodes, servers and services.
  • Configured the HA/Grid setup for High Availability and recoverability.
  • Responsible for migrations/upgrades for different versions of informatica.
  • Creation of Static and Dynamic deployment Groups, Labels and Queries.
  • Managing disparate databases by making server level ODBC entries and testing connectivity
  • Creating the Web Service hub service in the Informatica domain to avail web functionality for few customers.
  • Involved in Performance tuning for long running ETL processes.
  • Identifying root cause of the issues in infrastructure.
  • PowerExchange CDC for Oracle data sources on Linux
  • Installed and maintained Informatica Data Virtualization (Informatica Data Services), Informatica Cloud Services.
  • Performed IDS, ICS migrations to different environments and worked on related issues.
  • Created data quality services (IDS) to accomplish Data Profiling, Data standardization and cleansing.
  • Provided 24/7 Support related to Administration tasks (Emergency Deployments, FATAL ERRORS on the Informatica Server, unexpected Informatica services failures, Repository issues etc.)
  • Monitored the Workflows and worked on recovery strategies.
  • Implemented Disaster recovery setup for critical applications and performed annual DR test.
  • Created UNIX shell scripts for repository backups, domain backups and session recovery
  • Successfully restored data from ILM file archives to a different oracle landing zone.

Environment: Informatica 9.5.1 /9.1.0 , IDQ 9.5.1, ICS, Informatica data virtualization(IDS 9.5.1),Oracle, DB2 9.5, Teradata, HP ServiceCenter, UNIX, Windows 2003,UNIX Shell Scripting..

Informatica developer

Confidential

Responsibilities:

  • Created sessions, database connections and batches using Informatica Workflow Manager. Developed mappings to load data in slowly changing dimension.
  • Created mappings/workflows to extract data from SQL Server, Sybase and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting.
  • Involved in Extraction, Transformation and Loading job of the data warehouse Using Informatica.
  • Creating the detailed design documents.
  • Creating and enhancing the data mappings for the ETL design.
  • Creating Informatica workflows/sessions for the mappings.
  • Creating technical specification documentations for the mappings developed.
  • Development of Required oracle packages/procedure/functions.
  • Involved in Unit Testing.
  • Validating the data after each scheduling process completion

Environment: Informatica powercenter 8.6.1, Oracle 10g, Unix, Windows, Toad.

Informatica Developer

Confidential

Responsibilities:

  • Involved in ETL job of the data warehouse Using Informatica
  • Used ETL to load data from Oracle and flat files to Oracle.
  • Created mappings based on the Business Logic.
  • Creating technical specification documentations for the mappings developed.
  • Involved in modifications and performance tuning of mappings.
  • Created and scheduled workflows thereby combining sessions for individual units.
  • Involved in fixing invalid Mappings, testing of Stored Procedures and Functions.
  • Process monitoring the daily, weekly, monthly jobs in Informatica.
  • Developed the Oracle packages and procedure required.
  • Environment: Informatica powercenter 8.1.1, Oracle 10g, Unix, Windows, Toad.

Hire Now