SUMMARY

• 7+ years of software development and sustenance experience which includes design and development of data warehousing projects as ETL Developer/Designer using Informatica, Oracle and UNIX.
• Strong Skills in Data Warehousing Concepts, Informatica, Oracle, SQL, PL/SQL.
• Well conversant in Software Development Methodology, analysis, business process, designs, coding and participated in all phases of Software Development Life Cycle.
• Experience in requirement gathering from business users and provide designing approach to reviewers.
• Exposure to Health care and financial domains.
• Capability of deploying projects from development environment into Production.
• Strong skills in defect resolution.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Strong knowledge on Audit Balance Framework.
• Proficient in creating accurate and comprehensive code to meet the business requirements.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Skilled to provide out - of-the-box approaches to fulfill design requirements within existing technology and process constraints.
• Provide technical leadership, mentorship, and coaching to team members.

TECHNICAL SKILLS

Technology: Tools

Data Warehousing: Informatica 7.1.2, 8.1.1,8.6,9.5

Databases: Oracle 10g /11g(Exadata),MS SQL Server2005/2008/2012

Languages: SQL, PL/SQL, UNIX Shell Scripting

Verticals: Health care and Financing

PROFESSIONAL EXPERIENCE

Confidential

Sr Developer / Designer

Environment: Informatica9.5, SQL Server, UNIX.

Responsibilities:

• Gather requirements and provide efficient designs.
• Design end-to-end flow to meet LFGD requirements.
• Develope reusable Informatica mappings, mapplets and sessions for audit balance framework.
• Worked closely with business for DMD changes.
• Develop ETLs, Unit Test, Assembly Test and provide support during QA and UAT.
• Build reusable components wherever possible for better reusability and reduce complexity.
• Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
• Prepare Unit test documents, Assembly Test Documents and LLD Documents.
• For Assembly testing, worked with business to provide and validate the data for business test cases
• For Assembly testing, create the list of jobs to be executed and the order of execution in Dev to simulate it in Production for Autosys.
• Co-ordinate with other source systems to load the data for Assembly Testing.

Confidential

Sr Developer / Designer

Environment: Informatica9.5, Oracle10g/11g, HP Quality Center, UNIX.

Responsibilities:

• Gather requirements and provide efficient designs.
• Design end-to-end flow to meet Confidential requirements.
• Develop ETLs, Unit Test, provide UAT/Prod support and handle production release.
• Deployment of ETL changes to higher environments.
• Create UNIX scripts for ftp’ing the target files.
• Build reusable components wherever possible for better reusability and reduce complexity.
• Use pushdown optimization concept for better performance.
• Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
• Leading the ETL Development team

Confidential

Developer/Designer

Environment: Informatica8.6, MS-SQL Server 2005, UNIX

Responsibilities:

• Design end-to-end flow for GSL.
• Develop ETLs, Unit Test and provide UAT/Prod support and handle production release.
• Deployment of ETL changes to higher environments.
• Create UNIX scripts for ftp’ing the target files.
• Build reusable components wherever possible for better reusability and reduce complexity.
• Used pushdown optimization for better performance.

Confidential

Developer/Designer

Environment: Informatica8.1.1/8.6, MS-SQL Server 2005, UNIX.

Responsibilities:

• Redesign CRC ABC architecture to fit GSL project.
• Design end-to-end flow for GSL.
• Develop ETLs, Unit Test cases and provide UAT/Prod support and handle production release.
• Deployment of ETL changes to higher environments.
• Create UNIX scripts for ftp’ing the target files.
• Build reusable components wherever possible for better reusability and reduce complexity.

Confidential

Developer/Designer

Environment: Informatica8.1.1/8.6, Oracle10g/11g, HP Quality CenterResponsibilities:

• Involved in all phases of the cycle(Requirement gathering to Production deployment)
• Design and develop the mappings using different sources like XML, COBOL, Flat files, Oracle, SQL Server, and Message Queues etc.
• Design and develop reusable components.
• Automate some of the processes in the project.
• Design, Code, Unit Test, provide UAT/Prod support and handle production release.
• Ensure high efficiency by providing better performance tuning concepts for ETL’s and SQL queries.
• Deployment of ETL changes and DB changes to higher environments.

Confidential

Informatica Developer

Environment: Informatica8.1.1, Oracle10g, UNIX

Responsibilities:

• Analyse the Business Requirements Documents.
• Design and develop the mappings/workflows as per the high level ETL architecture.
• Prepare unit test cases.
• Design and develop reusable components to reduce complexity and encourage reusability.
• Involved in Unit Testing and Performance tuning of both Informatica mappingsand database queries.
• Writing stored procedures and shell scripts.