Nithesh Sarabu

Experienced ETL Developer with a strong background in Informatica Power Center (10.x), specializing in the full lifecycle of data warehousing projects, from analysis and design to implementation and support. Proficient in data migration, conversion, and end-to-end ETL processes across relational databases like SQL Server and Oracle. Skilled in utilizing a wide range of Informatica tools including Repository Manager, Designer, and Workflow Manager, with expertise in creating and scheduling complex workflows.

Expert in developing and optimizing data integration solutions using transformations such as Joiner, Aggregator, Lookup, and Sorter, while managing mapping variables and parameters. Adept at collaborating with business analysts to define requirements and produce detailed technical documentation.

Significant experience in integrating diverse data sources—Oracle, SQL Server, XML, and flat files—into data warehouses and marts, and implementing IDQ-to-Power Center integrations. Highly skilled in E-R modeling and designing schemas (Star and Snowflake) for OLTP/OLAP systems, along with implementing SCD Type 1 & 2 for managing historical data.

Proven ability to troubleshoot, debug, and optimize mappings, with hands-on experience in performance tuning at the mapping, session, and database levels. Skilled in writing UNIX shell scripts for automation, and developing stored procedures, complex SQL queries, and database objects in Oracle PL/SQL.

Extensive experience across the SDLC, including requirements gathering, data mapping, integration, and User Acceptance Testing (UAT). Familiar with software testing methodologies and tools, including Smoke, Functional, Regression, and Load testing. Well-versed in both Waterfall and Agile methodologies, with a strong focus on delivering high-quality solutions within performance and compliance constraints.