Hi, I’m
ARCHANA NIVARTHY
Summary
A Lead Migration Architect with over 15 years of experience working with data, leading cloud migrations, solution design, and delivering customer success. Passionate about continuously learning the latest and greatest advancements in AI to drive innovation and enhance solution effectiveness. Known for being results-oriented, resourceful, and a problem solver with strong leadership and people skills. Demonstrates a proven ability to manage tight deadlines while maintaining high-quality outcomes.
Overview
16
years of professional experience
1
Certificate
4
years of post-secondary education
Work History
InformaticaDallas, TX
LEAD MIGRATION FACTORY ARCHITECT
07.2022 - Current
Job overview
- Partner with customers and being their technical point of contact for all aspects of the product.
- Act as technical advisory to customers, guide them through the process of migration and make sure they are successful.
- Work closely with key customer stakeholders, deliberate and provide Architectural guidance.
- Lead the curation and delivery of relevant technical knowledge, presentations, and conversations at all client levels.
- Communicate platform best practices and performance/optimization methods.
- Guide customers throughout the migration lifecycle; including obtaining relevant pre-migration information, monitoring the execution of migration, and following up with the customer post-migration.
- Partner with internal delivery team to ensure smooth migration and help resolve any technical roadblocks.
- Proactively drives discovery and understanding of customer IT current state, goals, outcomes, and initiatives.
- Internally partner with Product team to explore any new areas where customer could use Informatica's product services.
- Actively mentor and enable other team members. Share methods, content, and lessons learned with team.
Neiman Marcus GrpDallas, TX
SR. SOFTWARE ENGINEER (MDM)
03.2021 - 07.2022
Job overview
- Work with multiple products of Reltio MDM.
- Interact with the Business Users on requirement gathering and communication to stakeholders on development activities.
- Develop MDM Solutions independently following the key practices of the SDLC.
- Improve Data Stewards experience by constantly working towards improvements in UI and underlying functionalities of MDM system including Match/Merge Rules.
- Architect innovative, framework based, high-performance and quality solutions to cater to the Business needs.
- Identify and Implement process improvements and leverage out of box MDM features with minimum customizations.
- Provide technical leadership and mentoring to team members.
- Support the solutions and work with the distributed team across geographical locations.
- Interact with Business to understand their integration needs and create high level design and technical specifications.
- Preparing technical design documents and writing test cases.
ConocoPhillipsHouston, TX
SR. INTEGRATION DEVELOPER
05.2019 - 03.2021
Job overview
- Interact with Business to understand their integration needs and create high level design and technical specifications.
- Design, Develop & Test and Implement ETL processes using Informatica Power Center & Informatica Cloud.
- Convert specifications into data mapping in an ETL Informatica Cloud environment/ Power Center.
- Complete technical documentation to ensure system is fully documented.
- Cleanse data prior to loading it into the target system.
- Develop reusable integration components, transformation, logging processes.
- Support system and user acceptance testing activities, including issue resolution.
- Develop ETL with SCD's, caches, complex joins with optimized SQL queries.
- Create workflow instances and improve performance of huge data loads using partitions and pushdown optimization.
- Identify, research, and resolve production issues, find root cause or system problems.
- Create, execute and Optimize SQL queries to analyze the data, provide support to BAs, and create various DDL and DML scripts on daily basis.
- Use shell scripts to perform ETL processes to call SQL or pmcmd commands, pre-post ETL processes like file validation, zipping, massaging and archiving the source and target files, and use UNIX scripting to manage the file systems.
- Automate and schedule Informatica jobs using Control-M application.
Phillips66Bartlesville, OK
SR. INTEGRATION DEVELOPER
12.2012 - 05.2019
Job overview
- Interacting with Business Users, Business Analysts to understand and document their integration requirements.
- Creating high-level design and providing work estimates.
- Followed Informatica best practices, such as creating shared objects for reusability and standard naming convention of ETL objects while developing interfaces.
- Assisted and managed overall project until solution delivery.
- Developed complex mappings that perform Extraction, Transformation and load of source data using various power center transformations.
- Performed thorough testing of interfaces and took care of production deployment along with postproduction support activities.
- Implemented performance tuning on a variety of Informatica maps to improve their throughput.
- Created Unix scripts to perform any additional functionalities needed.
- Used Informatica Data transformation tool/Informatica Developer to process Excel/PDF files.
- Worked on projects involving SOAP/REST webservice calls, Webservice Hub, JMS queues, Salesforce, SAP/BW, Hadoop File System, AWS S3 bucket.
- Developed Stored Procedures, Functions, Views and Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL and tuned SQL queries manually using EXPLAIN PLAN.
- Developed interfaces in Managed FTP tools such as GIS, SFG & GoAnywhere.
- Assisted Applications move to AWS cloud by moving informatica interfaces from PowerCenter On-Premises to PowerCenter on Cloud.
- Performed unit tests, integration tests on interfaces in AWS and coordinated with business users for validating results.
- Optimized performance of interfaces hosted in AWS PowerCenter.
- Managed all pre/post AWS cutover activities.
- Provided training to interns and new hires on Informatica PowerCenter and Data Warehousing concepts starting from basics.
- Managed and lead projects with offshore resources.
ConocoPhillipsBartlesville, OK
INTEGRATION DEVELOPER
04.2011 - 12.2012
Job overview
- Collaborated with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
- Analyzed existing complex DTS Packages, understanding their purpose and use in business, as well as documenting them.
- Created high-level designs for the DTS packages.
- Developed Mappings, workflows and reusable components to achieve documented design.
- Performed proper testing on the interfaces to compare results to existing DTS Packages.
- Reviewed code with peers, analyzed execution plans, and re-factored any inefficient code.
- Involved in extensive DATA validation by writing complex SQL queries and involved in back-end testing and worked with data quality issues.
- Created UNIX shell scripts to perform any out of Informatica functionalities.
- Actively worked in Company split related activities, such as cloning interfaces, testing them and validating data with Business Users & Business Analysts.
- Provided 24x7 production support for Informatica and GIS interfaces.
- Worked on writing additional code to help with maintenance of jobs in Informatica repository.
- Supported and handled Informatica upgrade related testing activities.
LnT InfotechChennai, India
SOFTWARE ENGINEER
03.2010 - 04.2011
Job overview
- Discuss with Business/Data Analyst to understand nature of the data and document them to help in design process.
- Participated in designing data models for Datawarehouse.
- Used SSIS to build Dimensions, Facts and Datawarehouse for reporting.
- Developed SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
- Used extensive logic to cleanse Toll Data which is manually loaded by various users.
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task.
- Developed, deployed and monitored SSIS Packages.
- Scheduled and maintained daily and monthly loads.
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Database.
- Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
- Performed extensive unit testing, integration testing and User acceptance testing on all the packages to validate and confirm readiness for cutover.
- Documented all test cases and issues in issue logs.
- Managed all Cutover related activities and managed production support.
Education
VISVESWARYA TECHNOLOGICAL UNIVERSITY , KARNTAKA
Bachelor of Science from Computer Engineering
06.2004 - 06.2008
Skills
- Informatica
- Snap logic
- MS SSIS
- MuleSoft
- Oracle
- MS SQL Server
- Sybase
- Postgres
- Teradata
- Snowflake
- Control-M
- Autosys
- Tidal
- Jira
- Azure
- Salesforce
- Python
- C
- C
- Java
- DB Visualizer
- DBeaver
- Teradata SQL assistant
- SQL server Mgmt Studio
- AWS
- GCP
Certification
- PowerCenter Data Integration 9.x: Developer Specialist Informatica
- AWS Certified Cloud Practitioner
- SnapLogic Integrator TrainingSnapLogic
- Cloud Data Quality - Certified Professional Informatica
- Infa-on-AI Informatica
- Agentblazer Champion 2026 Salesforce
- Informatica MDM SaaS: Manage Multidomain Data Informatica
- Customer 360 SaaS for Business Users Informatica
- Agentblazer Innovator Salesforce
Timeline
LEAD MIGRATION FACTORY ARCHITECT
Informatica
07.2022 - Current
SR. SOFTWARE ENGINEER (MDM)
Neiman Marcus Grp
03.2021 - 07.2022
SR. INTEGRATION DEVELOPER
ConocoPhillips
05.2019 - 03.2021
SR. INTEGRATION DEVELOPER
Phillips66
12.2012 - 05.2019
INTEGRATION DEVELOPER
ConocoPhillips
04.2011 - 12.2012
SOFTWARE ENGINEER
LnT Infotech
03.2010 - 04.2011
VISVESWARYA TECHNOLOGICAL UNIVERSITY
Bachelor of Science from Computer Engineering
06.2004 - 06.2008