Bharat Kumar

Sr. Informatica Developer

adytd6@r.postjobfree.com

+1-240-***-****

Professional Summary:

An experienced and highly motivated IT professional with 9+ years of experience in analysis, design,

development, testing, and support of Business Intelligence products and services in Informatica PC, IICS, SQL,

Data warehousing and ETL.

Hands-on experience in the development, administration, managing, designing, modeling, and testing of

enterprise-wide reporting systems.

Strong business requirement analysis using agile methodologies.

Enjoys leading, motivating, and being part of a specialized team, bringing strong leadership qualities, and equally comfortable working on their initiative.

Possesses exemplary technical problem-solving and negotiation skills and is accustomed to delivering results

under considerable pressure, remaining calm and effective, and prioritizing wisely.

Expertise in utilizing Informatica PowerCenter to extract, transform, and load large volumes of complex data from multiple sources to various targets.

Building pipelines to copy the data from source to destination in Azure data factory.

Knowing Dimension Data Modelling and manipulations in SQL Server Analysis Services.

Coordinated and participated in weekly estimation meetings to provide high-level estimates for backlog items.Created the KPI scorecards to show the difference between actual and forecast data.

Experience configuring and maintaining report manager and server for SSRS deployed and scheduled the reports in report manager.

Highly experienced in the whole cycle of DTS/SQL server integration services Packages (SSIS) for performing Data transfers and ETL processes across different servers.

Integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 uses OLE DB connection providers by creating various SSIS packages.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, and Data Modelling

like Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, and FACT and Dimensions Tables using MS Analysis Services.

Experience in using ETL methodology for performing Data Migration, Extraction, Transformation, and Loading using Informatica and designed data conversions from a wide variety of source system

Experience working in agile scrum development methodology and Azure Dev ops.

9+ years of Experience on Informatica Power Center ETL for Big data/Data integration/Data Quality.

Experienced in ETL methodology for performing Data Migration, Data Profiling, Extraction, Transformation and

Loaded using Informatica PC and designed data conversions from a large variety of source systems including

Oracle 10g/9i/8i/7.x, DB2, SQL Server, Teradata, and non-relational sources like flat files, and XML files.

Involved in code migrations from Dev. to QA and production and providing operational instructions for deployments

Expertise in Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation, and production support.

Strong Data Warehousing ETL experience using Informatica 9.x/8.x/7.x Power Centre Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.

Expertise in Using transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Java Transformation, Router, and Sequence generator.

Strong experience in Dimensional Modelling using Star and Snow Flake Schema, Identifying Facts and Dimensions.

Technical Skills:

Databases

MS SQL Server, MS Access, SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2, NoSQL Databases (HBase), PostgreSQL, DB2, AWS Redshift, Azure, Snowflake.

Database Tools

Snowflake, Oracle 12c/11g/10g/9i/8i, MS SQL Server 20142012 /2008/2005, DB2 v8.1, SQL Server Management Studio (SSMS),

Tableau Desktop.

ETL Tools

Informatica Power Center 9.x/8.x/7.x/6.x (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), IICS

SQL Server Tools

SQL Server Business Intelligence Development Studio, Enterprise Manager, TIBCO Data virtualization, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS, Visual Studio, Informatica power center.

Reporting Tools

Tableau, Report Builder, SQL Server Reporting Services (SSRS),SQL Reporting

Tools/Methodologies

Data Modelling – Logical Physical

Dimensional Modelling - Star / Snowflake

Languages

SQL, PL/SQL, UNIX, Shell scripts, Python

Data Modeling:

MS Access, MS SQL Server, Star Schema/Snowflake Schema

Modeling, logical data modeling, Waterfall & Agile Scrum

Methodologies.

Operating Systems

Windows 2008/2007/2005/NT/XP, UNIX, MS-DOS

CI/CD tools

Azure, AWS.

Packages

MS Outlook, MS Excel.

CERTIFICATIONS:

Microsoft Azure Data Fundamentals (Certification Number: 056CE6-Z3C6A9)

Microsoft Azure Data Engineer Associate (Certification Number: 6613B9-A4CB8C)

Professional Skills:

Client: MetLife Inc Jun 2021 – Jul 2023

Role: Senior Informatica Developer

Responsibilities:

Proven experience in the IT industry with business analysis, development, and Database focusing on Requirement Analysis, Development, Testing, Administration, and Implementation of BI Solutions in various verticals such as Banking, Insurance, and Energy Domain.

Designed strategic plan for component development practices to support future projects. Worked in Agile Environment.

Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.

Extensively worked in development of Informatica Mappings and Informatica Workflows which involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.

Expertise in Informatica Power Center 10.x/9.x extracting data from Oracle, SQL Server and DB2 databases.

Developed various Mappings for loading of source data from various source systems to EDW which perform Extraction, Transformation and Loading of Source data from all legacy systems and guide ware into the EDW, and used different Transformations like Source Qualifier, Expression, Lookup,Update Strategy, Sorter, Aggregator, Filter, Router, Joiner etc.

Led a team of developers in the design and implementation of a complex, mission-critical software system, resulting in a 20% reduction in maintenance costs and improved system reliability.

Mentored junior developers, conducting code reviews, and providing technical guidance to enhance team productivity and code quality.

Designed and optimized SQL databases, reducing query response time by 30% and improving overall application performance.

Collaborated with product managers and stakeholders to gather requirements, provide technical insights, and deliver innovative solutions to business challenges.

Implement ETL process to extract the data from source system and load the data to the target system.

Create mappings and data synchronization tasks in IICS Cloud data Integration to perform daily loads and incremental loads of data from salesforce objects to SQL server.

Document mapping and transformation details, user requirements, implementation plan and schedule.

Conducted technical training sessions for team members to improve their skills and keep them updated with the latest technologies and industry trends.

Collaborated with cross-functional teams, including UX designers and QA engineers, to deliver end-to-end software solutions with a strong focus on user experience.

Participated in system architecture reviews and made strategic recommendations to align technology choices with business objectives.

Performed all testing and troubleshooting methods and documented resolutions in the system.

Experienced with Sprint Planning, Daily Scrums, Sprint Reviews, and Retrospective Meetings, Creating the Task Board and Sprint Burndown Chart at the start of every Sprint, attending all Scrum meetings and continually working with the Team and business to find and implementing improvements.

Client: National Australia Bank Sep-2019 to Apr -2021

Role: Informatica Developer

Responsibilities:

Perform data extraction, transformation, and loading (ETL) between systems using SQL tools such as SSIS.

Created and enhanced data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing, and analyzing large sets of data.

Uses different data warehousing concepts to build a data warehouse for internal departments of the organization.

Reviewed test plans and monitored testing process to ensure that business results are tested.

Performed root cause analysis on all processes and resolve all production issues and validate all data and performed routine tests on databases and provide support to all ETL applications.

Translated data access, transformation, and movement requirements into functional requirements and mapping designs.

Proficient in designing, developing, and implementing data integration workflows using Informatica PowerCenter.

Extensive experience in extracting, transforming, and loading (ETL) data from various sources into target data warehouses and databases.

Skilled in creating and maintaining complex mappings, mapplets, and reusable transformations to ensure data accuracy and consistency.

Hands-on experience in integrating data from disparate sources, including relational databases, flat files, APIs, and cloud-based systems.

Expertise in performance tuning Informatica workflows and sessions to optimize data processing and load times.

Implemented error handling mechanisms and automated data reconciliation processes to ensure data integrity and reliability.

Proficient in scheduling and monitoring Informatica workflows using the Workflow Manager and Workflow Monitor.

Collaborated with cross-functional teams to gather requirements, design data integration solutions, and deliver on-time projects.

Experience in using Informatica Power Exchange for real-time data integration and change data capture (CDC) solutions.

Strong SQL skills to write complex queries and optimize database interactions within Informatica workflows.

Client: WORLD VISION AUSTRALIA Mar-2017 to Jun -2019

Role: Intern

Responsibilities:

Designed strategic plan for component development practices to support future projects.

Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.

Independently designed and executed company catalog for infrastructure support and development.

Familiarity with data warehousing concepts, dimensional modeling, and star schema design.

Stayed up-to-date with the latest Informatica product releases and best practices to drive continuous improvement.

Formulated new scripts for the ongoing transition to cloud to implement the business logic.

SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long-running queries using indexing strategies and query optimization techniques.

Transformed data as I ensured data integrity was maintained through ETL Process.

Coordinated statistical data analysis, design, and information flow.

Collaborated with clients from concept through final delivery of product or service.

Conducted in-depth business analysis to understand stakeholders' needs, objectives, and requirements for various projects.

Client: TECH MAHINDRA Mar-2014 to Feb -2017

Role: ETL/BI Developer

Responsibilities:

Work within the professional engineering practices & best practices for the Software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations.

Planned, designed, and implemented diverse business intelligence solutions.

Improved data gathering, analysis and visualisation procedures with strategic optimisations which improved the performance of the jobs by 10 Percent.

Automated scheduled ETL processes which reduced the error rate of human failures to 90 percent.

Developed data architecture design to enable analysts to perform targeted customer analysis.

Formulated the ETL mappings to implement the business logic.

Designed and developed ETL (Extract, Transform, Load) processes to extract data from various sources, transform it according to business rules, and load it into the data warehouse.

Collaborated with business stakeholders and data analysts to understand data requirements and design efficient data models for business intelligence reporting and analytics.

Developed and optimized SQL queries for data extraction and reporting, ensuring data accuracy and high performance in data retrieval.

Implemented data quality checks and data cleansing routines to identify and resolve data issues, ensuring the integrity of data stored in the data warehouse.

Created interactive and visually appealing dashboards and reports using BI tools such as Microsoft Power BI, Tableau, or QlikView to enable data-driven decision-making for business users.

Collaborated with cross-functional teams to gather business requirements and translate them into technical specifications for ETL and BI solutions.

Conducted performance tuning and optimization of ETL processes and data models to improve data processing and query performance.

Implemented data security measures and access controls to protect sensitive data in the data warehouse and BI reports.

Documented ETL processes, data models, and data integration workflows for knowledge sharing and team collaboration.

Performed all testing and troubleshooting methods and documented resolutions in the system.

Involved in performance optimisation of the ETLs, which helps the load to be completed in the given load window.

Contact this candidate