We provide IT Staff Augmentation Services!

Informatica Consultant, Technical Lead Resume

Saint Louis, MO

SUMMARY

  • 15+ years IT experience specializing in Design, Development, Testing and Application Support and maintenance of various systems.
  • Experience in all phases of SDLC and ETL, Agile methodologies.
  • Strong Data Analysis, Requirement gathering skill.
  • Experienced in executing Jobs on Bigdata Environment on AWS Stack
  • Have knowledge in creating event processing data pipelines using Apache Kafka and Kafka producer Application to produce near real time data using Apache Kafka
  • Have knowledge on Spark (Streaming, Spark SQL), RDD, Dataframe and Datasets.
  • Strong Presales Solution Architecting experience.
  • Strong ETL skill on Load Planning, Monitoring, Auditing and Error handling.
  • Strong Analysis, Design, Build, Test, Deployment experience in Informatica, Ab Initio, Hadoop with various databases like Oracle, Teradata, SQL Server, My SQL, Redshift, PostgreSQL
  • Hands on knowledge on UNIX operating systems
  • Very good understanding of Project standards and Procedure.
  • Strong coordination Skills (onshore & offshore)
  • Adhered to 24/7 support to ETL Applications.
  • Managed application development and maintenance activities which include establishing project standards and procedures, Planning and managing the work for the team members.
  • Very good Exposure to Issue management, highlighting critical issues and getting it resolved within required time limit.
  • Very good exposure to monitor service levels for area of responsibility and take proactive actions to address issues.
  • Participated in continuous improvement efforts related to issues management or project processes.
  • Managed delivery transition from client to team and vice versa.

TECHNICAL SKILLS

Databases: Oracle, Teradata, SQL Server, DB2, Sybase, MYSQL, Redshift, PostgreSQL

ETL Tools: Informatica BDM, Informatica PowerCenter, Ab Initio, SSIS

Languages: COBOL, SQL, JCL, Shell Scripting

Operating System: MVS, Windows, Unix

Reporting Tools: Business Object, SSRS, Tableau, Qlikview

Big Data Management: Informatica BDM, HADOOP - HIVE, Amazon EMR, Amazon S3, SPARK

Informatica Products: BDM, PowerCenter, EDC, Analyst, Metadata Management, IDQ, Cloud

Tools and Utilities: File Zilla, Toad, SQL Assistant, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Informatica Consultant, Technical Lead

Responsibilities:

  • Administration and Development of Informatica BDM and PowerCenter Application.
  • Identifying tools and technology
  • Requirement Gathering
  • Creating Stories, backlog, estimating work effort
  • Designing application as per the business
  • Developing and Testing ETL Applications as per the system Requirement
  • SME application review
  • Incorporating feedback on process, tools as received from client

Environment: Informatica BDM, Informatica PowerCenter. Amazon S3, Teradata, Amazon Redshift, Oracle, SQL Server, DB2, Sybase

Confidential, Greensboro, NC

Informatica BDM and PC Consultant

Responsibilities:

  • Allows an incremental approach to Distribution and Marketing (Pipeline Data Management) IT applications whereby after a "rough" layout of the warehouse has been defined.
  • A subject by subject area build is initiated prioritized by business benefit and feasibility.
  • This design replaced the existing "Legacy" architecture of flat aggregate level summary tables and operational reports that would run directly against the OLTP schema.
  • The new design assures that all data is derived from the same definitions in a consistent manner. Additional near instantaneous performance is assured by the dimensional schema.
  • It is combination of on-premise and cloud applications to enhance the performance of Distribution and Marketing(Pipeline Data Management) IT applications.
  • To acts as brand ambassador between the business and the various projects teams involving Application Support Team, Network, Database, Security Teams
  • Develop and build infrastructure onboarding requirement on On-Prem and cloud platform
  • Analyzing the Requirement
  • Involved in Identifying Backlog, creating Story and Sprint planning, Developing Work Plan, Work Effort estimates.
  • Designing application as per the business
  • Developing ETL Application as per the system Requirement
  • Testing the Application.
  • Automating ETL environment as much as possible

Environment: Informatica BDM 10.1.1 HF1/10.2.1, Amazon S3, PostgreSQL, Salesforce, Springboot, MuleSoft API Gateway

Confidential, Greensboro, NC

Informatica BDM Consultant

Responsibilities:

  • To provide a single platform for self-service analysis and reporting.
  • The platform must support a wide range of advanced data visualizations that are easy to use, while remaining very interactive for data exploration.
  • Empower users to respond to ad-hoc reporting requests and share the results, without complex processes or significant formal training.
  • Maintain a highly scalable solution to support evolving business needs.
  • To acts as brand ambassador between the business and the various projects teams involving Application Support Team, Network, Database Teams
  • Installation and configuration of Informatica BDM and other related products
  • Managing the DEV/QA/UAT/PRE-PROD/PROD environments
  • Setting up access roles and privileges, appropriate ETL migration activities and scheduling jobs using AutoSys
  • Automating Server Alerts, backup and notifications
  • On Call Support as required during the week ends and off hours
  • Developing Prototypes to be used in Environment, developing mapping and workflows and setting up environments.
  • Developing Jobs to be executed on Blaze, Spark and Hive on EMR
  • Root Cause analysis for ETL job failures/Data issues raised by business

Environment: Informatica BDM 10.1.1 HF1/10.2.1, Amazon S3, Amazon RDS Oracle, Informatica, Blaze, Spark, AWS EMR, Amazon Redshift, Amazon EC2, EDC

Confidential

Technical Architect

Responsibilities:

  • Interact with business team to understand the current business processes
  • Understand the System Requirements
  • Analyzing the Requirements
  • Create Models as per requirement
  • Data Preparation as per the System
  • Creating Data models
  • Creating Views and Queries for Reporting Developers
  • Colleting report matrix and analyzing the data

Environment: Tableau, Excel, SQL Server

Hire Now