ETL Informatica Architect Resume

SUMMARY

Self - motivated, innovative, and goal-oriented professional committed to pursuing a long-term career in building business intelligence (BI) and data warehousing (DW) solutions. Offer 15 years of track record demonstrating strong management, analytical and problem-solving skills, computer proficiency and ability to follow through with projects from inception to completion.
Managed the Offshore model and was responsible for interacting with the offshore team
Hands on experience using ETL Informatica Developer for Big Data Management (Version: 10.2.0) and Informatica Power Center 10.2 and AWS Cloud services
Extensive experience using ETL methodology for supporting Data Extraction, Transformations and Loading. Processing, using Informatica BDM 10.x. Informatica power center 9.x\8.x, Informatica Power Exchange, and Informatica Analyst tool.
Extensive experience working in an Agile Development environment.
Configuration and deployment experience in two or more of the following: AWS technologies such as RDS, Elastic Beanstalk, DynamoDB, RedShift, AWS IaaS Technologies such as EC2, S3, EBS, ELB, VPC, Route 53
Design complex solutions to meet business requirements and manage the projects efficiently.
Ability to deliver multiple projects with competing priorities and ensuring the deliverables are met within the agreed time, cost & quality.

TECHNICAL SKILLS

ETL Tools: Informatica BDM (Big Data Management) Power Center 10.2, Power Exchange 8.x, Informatica Analyst), Informatica Cloud Designer, Talend

AWS: RedShift, RDS, Elastic Beanstalk, DynamoDB, AWS IaaS Technologies such as EC2, S3, EBS, ELB, VPC, Route 53

BI Tools: Business Objects, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), MicroStrategy

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN

Operating Systems: Windows NT/98/95, MS DOS, UNIX.

Other Tools: WATTS, ICOMS, Toad 9.x/8.x, PL/SQL-Developer, MS-Office, Data Integration Scheduler (DIS), SM9, Quality Center, Business Process Model and Notation (BPMN), Decision Model Notation (DMN), Microsoft Azure Storage Explorer, Microsoft Cosmos Data Base, Jira, Confluence

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Architect

Responsibilities:

Analyzed business requirements, performed source system analysis, prepared functional and technical design documents
Design complex solutions and develop ETL jobs to meet business requirements and manage the projects efficiently.
Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
Created re-usable transformations/mapplets and used across various mappings
Data acquisition, Data analysis, Data mapping, data profiling and source to target mapping
Creation of LSDD. Data Requirements, Data flow diagrams, key data analysis and data remediation
Plan and execute tasks to meet Organizational objectives and goals.
Responsible for the Data model design and implementation using Informatica.
Interfacing with the Business users and the client Technical teams during various stages of the project.

Environment: Informatica BDM 10.2 (Big Data Management), Informatica Power Center 10.2, Microsoft SQL Server Management 17.4, Microsoft Visio

Confidential

ETL Informatica Architect

Responsibilities:

Lead Onsite and Offshore developers
Analyzed business requirements, performed source system analysis, prepared functional and technical design documents
Design complex solutions and develop ETL jobs to meet business requirements and manage the projects efficiently.
Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
Created re-usable transformations/mapplets and used across various mappings
Subject Matter Expert (SME) for the Data warehouse.
Data acquisition, Data analysis, Data mapping, data profiling and source to target mapping
Creation of BRD/DSD. Data Requirements, Data flow diagrams, key data analysis and data remediation
Plan and execute tasks to meet Organizational objectives and goals.
Responsible for the Data model design and implementation using Informatica.
Interfacing with the Business users and the client Technical teams during various stages of the project.

Environment: Informatica BDM 10.2 (Big Data Management), Informatica Power Center 10.2, Microsoft SQL Server Management 17.4, Microsoft Azure Storage Explorer, AWS RDS, Elastic Beanstalk, DynamoDB, RedShift, AWS IaaS Technologies such as SNS,EC2, S3, EBS, ELB, VPC, Route 53, Kafka, PySpark, Hadoop, Microsoft Cosmos Data Base, Jira, Confluence, WATTS, ICOMS

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship