Informatica Developer Etl

Location:

Downtown, TX, 78701

Posted:

October 23, 2024

Contact this candidate

Resume:

Satish Mutyala

E-Mail: ***********@*****.*** Mobile: +1-540-***-****

Summary

With around 13 years of experience in Data Warehousing Technologies, encompassing analysis, design, coding, testing, and support for business applications, as well as migration within the domain, I bring a proactive and self-motivated approach to my work. I am well-organized, efficient, and capable of thriving both individually and in team settings, fostering a collaborative work environment. My strong leadership qualities, ability to meet deadlines, manage multiple tasks, and flexibility in work schedules are complemented by excellent communication skills.

Skill Set:

Strong knowledge of Software Development Life Cycle (SDLC), Methodologies and Techniques. Involved in writing detailed description of needs, system design, program functions, and steps required to modify existing application as per business needs.

Exposed to different ticketing and testing tools such as (for change and incident management) Service now, BMC Remedy

Experience in conducting User Acceptance Testing (UAT). In-depth knowledge of the software maintenance and development life cycle utilizing SDLC design. Proficient in different phases of Testing like Unit Testing, Integration Testing and System Testing. Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts, Test Procedure based on the User Requirement Document, System Requirement documents, and functional Requirement documents.

Expertise in User Requirement Analysis, Functional Specifications, Business Requirements, Business Rules to Prepare Test Schedules, Identify Test Requirements. Strong analytical, problem solving, organization, presentation, and communication skills.

Work with business and technical stakeholders to understand and gather ETL (Extract, Transform, Load) requirements.

Created mappings that include various transformations (e.g., expression, aggregator, joiner, lookup) to process data efficiently.

Used advanced transformations like Rank, Filter, and Router to manipulate and refine data.

Translate business requirements into technical specifications for ETL development.

Design efficient ETL solutions to extract data from multiple sources (databases, flat files, XMLs, etc.).

Design, develop, and implement ETL (Extract, Transform, Load) processes using Informatica PowerCenter.

Develop ETL mappings, workflows, and sessions in Informatica PowerCenter or other Informatica tools.

Ensure that the mappings are optimized for performance (e.g., using partitioning, parallel processing, etc.).

Implement data validation and transformation rules to ensure data consistency and integrity.

Participate in data governance initiatives to align with organizational data management standards

Domain experience in Retail, Banking and Telecom verticals.

Extensively involved in designing different kinds of Reports in IBI WebFocus, IBM Cognos and MicroStrategy.

Extensively involved in designing different kinds of Dashboards in Microsoft Power BI, Tableau, Cognos Analytics and WebFocus and MicroStrategy Dashboard.

Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights.

Using Power BI, create dashboards and interactive visual reports.

Experience in ETL (Extraction, Transformation and Loading) and Data Integration using Informatica from heterogeneous data sources.

Worked with RDBMS like MS-SQL Server, Oracle, Teradata database and SQL DW using Third Party tools like SQL Server Management Studio.

Expertise in preparing scripts to ensure proper data access, manipulation and reporting functions and testing Database integrity/ validation with SQL, and PL/SQL.

Development of Tableau Dashboards to perform YOY, QOQ, YTD, QTD and MTD analysis.

Providing customer support to Tableau users and wrote optimized Custom SQL to support business.

Involved in creating, modifying Reports, data presentation, implementing Business logic and report layout in Cognos, WebFocus.

Involved in data analysis, querying, working with stakeholders, prompts pages, filters.

Possess knowledge and experience with Iterative, Scrum, Agile development methodologies.

Experience in Jira Task management and involved in Sprint schedule, Retrospective meeting.

Worked with users and team for resolution of production complex issues of reports and dashboards.

Expertise in End-to-end design, development, and Support Application.

Accomplishments

Received CGI APEX Awards Couple of times.

Received a “PAT on the BACK” award from the senior management in 2016 and 2018.

Multiple Client appreciation on successful completion of MicroStrategy Upgrade and MicroStrategy Migration (Legacy Window to Unix Environment).

Received BELL Canada client appreciation for my proactive approach, dedication, and immense commitment towards delivery of reports well in advance. It has resulted in winning important additional contracts and built client relationships.

One of the achievements in the project that client Royal Bank of Canada, London rated very high is the migration/development of WebFocus Report. These reports we need to migrate from mainframe to WebFocus which were one of the major hurdles in the project and I was able to do it as required successfully with in the deadline.

Skills

ETL Tools: Informatica PowerCenter, Cognos Decision Stream, SSIS, Data Stage, WebFocus

Data Migrator.

Reporting Tools: WebFocus, Power BI (Desktop, Gateway, Embedded), MicroStrategy, Cognos,

Microsoft BI (SSAS, SSRS), Tableau

Programming: COBOL, JCL SQL, PL/SQL, HTML, UNIX Scripting

Databases: Oracle, MS-SQL Server, DB2, Teradata and Sybase.

Operating Systems: Windows NT/XP/2000, UNIX.

Agile Tools: JIRA, SNOW (MSP and FMO).

Other Tools: SQL Server Management Studio, RStudio, MS-Visual Source Safe, Toad, WinSCP,

MobaXterm, MotioPI, ControlM, HPSM, ITSM, SSM (SAP Solution Manager)

CRM: Salesforce Development & Administration.

Education

Bachelor of Technology 2007 Jawaharlal Nehru Technological University, Hyderabad.

Professional Summary

Working in Capgemini Technology Services Pvt Ltd, from Feb 2022 to till date.

Worked in CGI Information Systems and Management Consultants Pvt Ltd, Bangalore from Sep 2013 to Jan 2022.

Worked in Future Focus PVT LTD., Chennai from June 2011 to Sep 2012.

Professional Experience

Senior BI Consultant Date: June 2023 – July 2024

Capgemini Technology Services India Limited

Client: CCP (Coca-Cola Partners) Demonstrator

Technical Environment: Informatica PowerCenter, Oracle, UNIX, WinSCP, GitHub, Toad.

CCEP is one of the world’s leading consumer goods companies. Coca-Cola Europacific Partners plc (CCEP), formerly Coca-Cola European Partners (2016–2021) is a British company formed because of the combination of the three main bottling companies for The Coca-Cola Company in Western Europe: Coca-Cola Enterprises Work with business and technical stakeholders to understand and gather ETL (Extract, Transform, Load) requirements.

Responsibilities:

•Translated business requirements into technical specifications for ETL development.

•Designed efficient ETL solutions to extract data from multiple sources (databases, flat files, XMLs, etc.).

•Developed ETL mappings, workflows, and sessions in Informatica PowerCenter.

•Designed and developed ETL workflows using IICS to extract, transform, and load data from various data sources to the target systems

•Ensure that the mappings are optimized for performance (e.g., using partitioning, parallel processing, etc.).

•Created mappings, tasks, and taskflows to automate data integration processes.

•Design complex data transformations such as aggregations, lookups, joins, and data cleansing to ensure high-quality data movement.

•Involved in integrating data from SaaS platforms like Salesforce and Google Cloud) with on-premises systems such as relational databases and data lakes.

•Implement data validation and transformation rules to ensure data consistency and integrity.

•Participate in data governance initiatives to align with organizational data management standards

•Analyze and troubleshoot failed workflows, applying fixes and updating business users on root causes and impacts.

•Integrate data from various source systems, including RDBMS, cloud platforms, and third-party applications.

•Developed and implemented automation for ETL processes using task scheduling, triggers, and dependencies in IICS.

•Cleanse, transform, and load data into target systems such as data warehouses or data lakes.

•Implement error handling and exception mechanisms to ensure data quality.

•Validate source files for size and duplicate data and create weekly validation reports before data warehouse loading.

•Developed and validated data mappings for accurate and consistent data transformation between source and target systems.

•Scheduled data integration workflows and ensure timely execution to meet business requirements for reporting and analytics.

•Maintain Informatica services, including startup, shutdown, and debugging using server and service logs.

•Install, configure, and perform maintenance on Informatica components and services.

•Manage PowerCenter domain, security, users, roles, and privileges, handle folder creation and code migrations.

•Optimize ETL processes, including tuning SQL queries and workflows, and implement error-handling mechanisms to ensure data quality.

•Document ETL processes, data mappings, and workflows, and stay updated on Informatica PowerCenter features and updates.

•Worked on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing

•Perform UNIX file migrations, manage user connections and locks, and handle service desk tickets and outage notifications.

Senior Consultant Date: Feb 2022 – May 2023

Capgemini Technology Services India Limited

Client: BAYER CROP SCIENCE

Technical Environment: Informatica PowerCenter, Oracle, UNIX, WinSCP, GitHub, Toad

Bayer Crop Science works for a world where biodiversity thrives in harmony with humankind. Where hunger and climate change are terms relegated to history books. Where farms are more sustainable, with plants that are more adaptive and resilient, to help improve life for families and communities. In short, where agriculture is part of the solution.

Responsibilities:

•Translated business requirements into technical specifications for ETL development.

•Created ETL mappings and workflows using PowerCenter to extract, transform, and load data from various sources into data warehouses or databases.

•Implemented data quality checks to ensure the accuracy and integrity of the data being processed.

•Optimized mappings and workflows for better performance and efficiency, including partitioning and indexing strategies.

•Conducted unit testing and assisted in system integration testing to ensure data transformations are correct.

•Documented ETL processes, including mapping specifications, transformation logic, and workflow designs.

•Worked with stakeholders to gather data requirements and understand business needs for reporting and analytics.

•Analyzed source data to identify patterns, inconsistencies, and potential issues before ETL processes.

•Create reports and dashboards to provide insights from transformed data, often using BI tools in conjunction with Informatica.

•Performed row-wise calculations and data manipulations using expressions.

•Created derived fields by writing expressions and Implement business logic to transform incoming data.

•Validate and test expressions for correctness and performance and Filter data based on specified conditions.

•Strong troubleshooting and problem-solving skills for diverse BI tools and ETL environments.

•Proficiency in SQL and data integration technologies, with experience in performance tuning and system optimization.

•Ability to work independently and collaboratively, with a focus on continuous learning and improvement in BI and data management practices.

•Performed aggregate calculations on data (e.g., sum, average, count), mainly Group data based on specified keys and calculate aggregate values and Optimize performance by configuring caching and sorting options.

•Route data to multiple output groups based on conditions in define multiple output groups with specific conditions for routing.

Senior Software Engineer Sept 2017 – Jan 2022

CGI Information Systems and Management Consultants Pvt Ltd

Clients: Bell Canada

Technical Environment: Informatica Power Center 10.2, Core FTP, Oracle 11g, Qlik Sense, WinSCP

Bitbucket, Window, HPSM, ITSM, WebFocus, RedHat Enterprise, Linux

Server, Tableau.

Bell Canada commonly known as Bell is a Canadian telecommunications company headquartered at 1 Carrefour Alexander-Graham-Bell [6] in the borough of Verdun in Montreal, Quebec, Canada. It is an ILEC (incumbent local exchange carrier) in the provinces of Ontario and Quebec; as such, it was a founding member of the Stentor Alliance. It is also a CLEC (competitive local exchange carrier) for enterprise customers in the western provinces.

Responsibilities:

•Translated business requirements into technical specifications for ETL development.

•Provide 24x7 support for Informatica PowerCenter jobs and workflows, ensuring they run efficiently and address issues promptly.

•Analyze and troubleshoot failed workflows, applying fixes and updating business users on root causes and impacts.

•Validate source files for size and duplicate data and create weekly validation reports before data warehouse loading.

•Develop and validate data mappings for accurate and consistent data transformation between source and target systems.