Job Description :
Position Title: Software Engineer
Contract Length:1+year
Location: Albany, NY
Hourly Rate: Open
Job Title: Software Engineer
Gather, Analyze the requirement, and converting Functional Requirements into Technical Specifications.
Design of ETL methodology using Informatica PowerCenter / PowerMart to accomplish data transformation and load processes.
Create multiple PowerCenter mapplets, mappings and sessions using various transformations like Lookup, Filter, Normalizer, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator, XML Generator Transformations and merged them into workflows. Logically planned and designed the inter-linking of these workflows with other ETL processes to make various parts of the application work together as a single system.
Design the Extract Transform and Load processes for data migration using Informatica to load data from Flat files/ Excel to source staging database and from staging to target SQL server Data Warehouse.
Development of SQL Server scripts and use of various database objects like Stored Procedures, Functions, Views, Triggers, Tables, synonyms and DB-links .
Recommended software upgrades to process data in real-time mode by using PWX CDC (PowerExchange Change Data Capture) rather than in batch processing mode to achieve optimum load times.
Created a variety of models, Proof of concepts with relevant pieces of code and screen shots to show other developers and admins on how various parts of the application are designed and works, and upload these to TortoiseSVN for reference.
Enhance the ETL processes by tuning the mappings for better performance with SQL Server Procedures/Functions, Push down Optimization and also by using different Session Partitioning techniques like Round robin, Hash-Key, Range & Pass Through.
Collaborates with Data Modeler and other ETL developers to create optimum software and to modify the code as per the changes in the business requirements throughout the Software Development Life Cycle.
Schedules the application to run daily using Control-M and automate the processes using Command Task and UNIX Shell scripts which ensures that the application continues to function normally through software maintenance and testing.
Create a reliable recovery process to protect the system in the event of a failure and also developed relevant back-up applications to run during such failures.
Create numerous test cases, test plans and performed the unit test and documented the results. Bugs found during testing were analyzed (root cause analysis) beyond their obvious reason to extrapolate various errors that can occur in future.
Document ETL test plans, test cases, test scripts, test procedures, assumptions and validations based on design specifications for unit testing, expected results, preparing test data and loading for testing, error handling and analysis.
Deployed PowerCenter code to higher environments using Informatica Deployment groups and DTLURDMO utility tool.
Documents each and every design, development, test cases and deployment including the Mapping and Transformation Rules, Source and Target definitions as a reference for future maintenance and upgrades.
Because of the complexity of the project and the assigned duties, the minimum requirement for performance of these duties is a bachelor’s degree in computer science or a closely related field.
Send resume to Wafts Solutions, Inc. 41 State Street 604-14, Albany, NY - 12207.