Informatica Consultant, Technical Lead Resume Saint Louis, MO - Hire IT People

SUMMARY

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:

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 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

We provide IT Staff Augmentation Services!

Informatica Consultant, Technical Lead Resume

Saint Louis, MO

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship